Problem with php search code

[kpetsche20]

Everytime I execute the code below even when a result is in the database it only displays it works.

 

<?

if(isset($_POST['Submit']))

{

$searchsql = "SELECT * FROM tblpeople";

$searchquery = mysql_query($searchsql);

while($data = mysql_fetch_array($searchquery))

{

$search = $data['tblpeople'];}

if($data['tblpeople'] != $_POST['search'])

{  echo "works"; }

else { "doesn't work";}

}

 

?>

[br0ken]

Try this...

 

<?php

if(isset($_POST['Submit']))
{
$searchsql = "SELECT * FROM tblpeople";
$searchquery = mysql_query($searchsql);
while($data = mysql_fetch_array($searchquery))
{
$search = $data['tblpeople'];}

if($data['tblpeople'] != $_POST['search'])
{  echo "works"; }
else { "doesn't work";}
}
}
?>

[kpetsche20]

Doesn't work even when i typed in the correct info it gives me the same error as if it was incorrect..

 

 

 

Here's the new code

 

<?php

if(isset($_POST['Submit']))
{
$searchsql = "SELECT * FROM tblpeople";
$searchquery = mysql_query($searchsql);
while($data = mysql_fetch_array($searchquery))
{
$search = $data['tblpeople'];}

if($data['tblpeople'] != $_POST['search'])
{  echo "doesn't work"; }
else { "works";}
}

?>

[br0ken]

What is the name of the field in the table that you're trying to extract data from?

 

$search = $data['tblpeople'] - Where you have tblpeople (the table name) you need to have the field name you want to get the data from.