construction — Fri, 14 Jul 2006 09:25:22 +0000

Thanx Busy.

SBalan Group
http://www.sbalanprojects.com/

Busy — Thu, 13 Jul 2006 10:41:16 +0000

Are you able to show us the database query result?

Usually it's somethig like this:

$sqlquery = select * from data_table where item = "$search_term";
$sqlresult = mysql_query($sqlquery);
while($row = mysql_fetch_assoc($sqlresult))
{
//display the data here - is in a loop so just do once like so:
echo "Name = ".$row['name'];
echo "Age = ".$row['age'];
//etc
}

This will list ALL the results in the data base where item equals the search term, can use like search term or %search term% (starts or ends with it), if you want to limit the results add it to the end of the $sqlquery just before the ;