Table Search please HELP
| From: | Devon | Date: | Fri, 07 Sep 2001 00:41:06 +0000 |
| Subject: | Table Search please HELP | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-9221@lists.php.net to get a copy of this message | ||
Below is an example of my code which searches a table and prints the result,
the problem is that it only displays the TechContact where I want it to
display all the fields that associated with it in that row off the colum eg.
Mobile, AdminContact etc etc Any suggestions?
if ($TechContact == "")
{$TechContact = '%';}
$result = mysql_query ("SELECT * FROM enet
WHERE TechContact LIKE '$TechContact%'");
print $row["TechContact"];