I want to...

[Wuggy]

Have a search for something in the database, if its not in the database to say like Error not in the database or something. Example:

Database = test

Search for: Test

"Test is in the database"

Search for: Other stuff

"Other stuff is not in the database"

how would I do that?

[jannoy]

we assume that you already have connection to your database

$query="select * from yourtable where yourfield like '%yoursearch%' "
$result = mysql_query($query);
$row=mysql_num_rows($result);
if ($row==0){
echo "not in database";}
else
{ echo " found";}

[Wuggy]

could I have two different rows? like
$query="select * from yourtable where yourfield like '%yoursearch%' "
$result = mysql_query($query);
$row=mysql_num_rows($result);
if ($row==0){
echo "not in database";}
else
{ echo " found";}

Could I have yourfield and yourfield2?

[jannoy]

yes

[Wuggy]

:-p

[jannoy]

select * from yourtable where yourfield like '%yoursearch%' and yourfield2 like '%yoursearch2%'";