Hiya, I'm writing a backend in MySQL with a PHP frontend. One of the PHP
pages searches the database. The user can enter as many or as few fields as
they like. I then search the database using this code:
$result = mysql_query(select * from equipment where (category='$category')
and (description
$result = mysql_query(select * from equipment where (category='$category')
and (description like '%$description') and (roomloc='$roomloc') and
(quantity like '%$quantity') and (serialno like '%$serialno') and (patdue
like '%$patdue'),$db);
Gary Smith wrote:
Hiya, I'm writing a backend in