$db = mysql_connect("62.149.150.11","Sql43123","9qA)3WBc");
mysql_select_db("Sql43123_1", $db) or die(mysql_error());
if(isset($_REQUEST['testo'])) $testo=$_REQUEST['testo'];
?>
if(isset($testo))
{
$result=mysql_query("SELECT * FROM forum_posts_text WHERE post_text LIKE \"%$testo%\" ORDER BY post_id DESC");
echo mysql_num_rows($result)." risultati trovati";
echo "\n";
if(mysql_num_rows($result)>0)
{
while($r=mysql_fetch_array($result))
{
$result2=mysql_query("SELECT * FROM forum_posts WHERE post_id=".$r['post_id']);
$r2=mysql_fetch_array($result2);
$result4=mysql_query("SELECT * FROM forum_users WHERE user_id=".$r2['poster_id']);
$r4=mysql_fetch_array($result4);
$result3=mysql_query("SELECT * FROM forum_topics WHERE topic_id=".$r2['topic_id']);
$r3=mysql_fetch_array($result3);
echo "";
if($old!=$r3['topic_title'])
{
echo "".$r3['topic_title']."";
$old=$r3['topic_title'];
}
echo "Messaggio ".$r['post_id']." (".$r4["username"].") | \n";
}
}
?>
}?>
|