RE: [PHP-DB] PHP and MYSQL query

[Oson, Chris M.]

For starters, your statement is wrong...

$result = mysql_query($strSQL, $db);

where $db is your connection string to the database you already have opened.

If you have problems with your sql statement, try something like this and
see 
what your results are:

$strSQL = "SELECT * FROM $TA WHERE $SortField = '$search%' ORDER BY
$SortField";
print $strSQL;

$result = mysql_query($strSQL);

Once you have the results of the query printed out, copy and paste it into
the 
command line in mySQL.  You'll know if you're doing something wrong or not.

-----Original Message-----
From: Jim Ray [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 8:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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 Database 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 Database 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]