PHP and MYSQL query
| From: | Jim Ray | Date: | Sat, 10 Mar 2001 04:02:49 +0000 |
| Subject: | PHP and MYSQL query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7267@lists.php.net to get a copy of this message | ||
I have a simpe query that I can not seem to get to work.
Here is the HTML side:
<td width="27%" align="center"><form
action="luquery.php?DB=csjoa&TA=associates&SortField=company"
method="post"><input type="text"
name="search"><br><input
type="submit"></form></td>
Here is the PHP side:
The fields are being past, but I get 0 in the results?
$result=mysql_query("select * from $TA where $SortField='$search%' order
by $SortField");
Am I missing something here?
Thanks for the help.
Jim