Вывод результата поиска из нескольких таблиц БД.

<form action="search.php" method="post">
<tt>
Поиск<br />
<input type="text" name="search" value="что искать?" onclick="search.value='';"/><br /><br />
<input type="submit" name="submit" value="искать"/>
</tt>
</form>

<?
include"bd.php";
$search=$_POST["search"];
$search=trim($search);
$search=htmlspecialchars($search);
$search=stripslashes($search);
 
$products = mysql_query("SELECT `id`,`title`,`text` FROM articles WHERE `title` LIKE '%$search%' UNION SELECT `id`,`title`,`text` FROM blog WHERE `title` LIKE '%$search%' ", $db);
while($array = mysql_fetch_array($products)){
 
    printf('<p><a href="articles.php?id='.$array['id'].'">'.$array['title'].'</a>');
    }   
 
?>

<?php
include"bd.php";
 
$result = mysql_query("SELECT * FROM articles WHERE id='".$_GET["id"]."' UNION SELECT * FROM blog WHERE id='".$_GET["id"]."'");
while($array = mysql_fetch_array($result)){
printf($array['text']);
}
 
?>

$result = mysql_query("SELECT articles.*, blog.* FROM articles, blog WHERE id='".$_GET["id"]."'");

$result = mysql_query("SELECT articles.*, blog.* FROM articles, blog WHERE articles.id='".$_GET["id"]."' AND blog.id='".$_GET["id"]."'");

$result = mysql_query("SELECT articles.*, blog.* FROM articles, blog WHERE articles.id='".$_GET["id"]."' AND blog.id=articles.id");

<?php
include"bd.php";
 
$result = mysql_query("SELECT articles.*, blog.* FROM articles, blog WHERE blog.id='".$_GET["id"]."' AND articles.id='".$_GET["id"]."'");
 
while($array = mysql_fetch_array($result)){
printf($array['text']);
printf($array['text2']);
}
 
?>