Re: Table Search
| From: | David Robley | Date: | Fri, 07 Sep 2001 00:46:57 +0000 |
| Subject: | Re: Table Search | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-66303@lists.php.net to get a copy of this message | ||
On Fri, 7 Sep 2001 10:11, Devon wrote:
> 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"];
You would need to specify them in a print function, then.
print $row["Mobile"];
print $row["AdminContact"]; etc etc
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Famous last words - Don't worry, I can handle it.