Re: PHP and MYSQL query
| From: | David Balatero | Date: | Sat, 10 Mar 2001 08:41:03 +0000 |
| Subject: | Re: PHP and MYSQL query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7268@lists.php.net to get a copy of this message | ||
First, try just calling the form action like:
<form action="luquery.php?DB=csjoa&TA=associates&SortField=company"
method="POST">
Turning the & into & chars (maybe my mail prog formatted it like this?
...nevertheless..)
Also, try doing:
$result=mysql_query("select * from $TA where $SortField='%".$search."%'
order by $SortField");
-------
David Balatero
www.icegaming.com
db@icegaming.com
-------
Jim Ray wrote:
> 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
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net