Re: Table Search ... HELP
| From: | Jacob Singh | Date: | Fri, 07 Sep 2001 12:20:20 +0000 |
| Subject: | Re: Table Search ... HELP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12245@lists.php.net to get a copy of this message | ||
Hello Devon,
Thursday, September 06, 2001, 8:41:55 PM, you wrote:
D> Below is an example of my code which searches a table and prints the result,
D> the problem is that it only displays the TechContact where I want it to
D> display all the fields that associated with it in that row off the colum eg.
D> Mobile, AdminContact etc etc Any suggestions?
D> if ($TechContact == "")
D> {$TechContact = '%';}
D> $result = mysql_query ("SELECT * FROM enet
D> WHERE TechContact LIKE '$TechContact%'");
D> print $row["TechContact"];
Devon, http://php.net - use it. Go to the mysql_query,
mysql_result,mysql_fetch_array functions. Also you should probably
learn some more MySQL, a good place for this is .... http://mysql.com. also
checkout devshed they wave some good tutorials dealing with what you
are doing.
--
Best regards,
Jacob mailto:jsingh@balances.com