Re: [PHP] PHP and MySQL query

[Yasuo Ohgaki]

Read RFC2396 for URI format. You are escaping query string as HTML where do you don't have to. When you deal with query string, you should escape as URL. Read PHP manual for rawurlencode()/rawurldecode() for URL encode/decode. Regards, Yasuo Ohgaki ----- Original Message ----- From: "Jim Ray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 10, 2001 1:11 PM Subject: [PHP] PHP and MySQL query > 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&amp;TA=associates&amp;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 General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]