question about search

[Gruzin]

hi again,
one more question: I want to make a simple search, here is the code but it doesn't work, thnks for your help.

[color=red]<?php
$con = mysql_connect("localhost","3d","pass");
if(!$con){
  die('Error:'.mysql_error()); // if not connected
}
mysql_select_db("3d",$con);
$result = mysql_query("SELECT * FROM text WHERE text");
while($row = mysql_fetch_array($result))
  {
  if($row['text'] == $_POST['search']){
  echo "Think I've found something";
  echo "</br>";
  echo $row['text'];
  }
  else {
  echo "no mathes found";
  }
}
mysql_close($con);
?>[/color]

[JadedLucidity]

maybe this will help.

<?php
$con = mysql_connect('localhost','3d','pass')
  or die('Error:'.mysql_error()); // if not connected
}
mysql_select_db('3d',$con)
  or die ('Could not select database');
<-----------SELECT col_name FROM tbl_name WHERE col_name > 0;----------> where requires a condition

$result = mysql_query("SELECT * FROM text WHERE text");
while($row = mysql_fetch_array($result))
  {
  if($row['text'] == $_POST['search']){
  echo "Think I've found something";
  echo "</br>";
  echo $row['text'];
  }
  else {
  echo "no mathes found";
  }
}
mysql_close($con);
?>