PHP query help

Anon

I'm very new to mysql, and PHP ( like just a few days.

I've setup a mysql server, and created the database..entered some data, and have had no problem creating some pages that will list the data in a table.

The problem is when I try to limit the query using the WHERE statement.

The basic working sql query is as follows.

if(!isset($sqlf)) $sqlf = "SELECT * FROM listdata ORDER by et ";
$result = mysql_query("$sqlf",$db);

I have one column name pa that I want to check for a value = to the characters "N/A" that are entered

So I changed the sql statement to

if(!isset($sqlf)) $sqlf = "SELECT * FROM listdata where pa='N/A' ORDER by et ";
$result = mysql_query("$sqlf",$db);

which didn't work, and many different methods have not worked. any ideas will be greatly appreciated!

Anon

Are you getting any messge back from MYSQL about why your query isn't working? Have you tried phpMyAdmin? It will give you feedback if your query fails.

LC wrote:

I'm very new to mysql, and PHP ( like just a few days.

I've setup a mysql server, and created the database..entered some data, and have had no problem creating some pages that will list the data in a table.

The problem is when I try to limit the query using the WHERE statement.

The basic working sql query is as follows.

if(!isset($sqlf)) $sqlf = "SELECT * FROM listdata ORDER by et ";
$result = mysql_query("$sqlf",$db);

I have one column name pa that I want to check for a value = to the characters "N/A" that are entered

So I changed the sql statement to

if(!isset($sqlf)) $sqlf = "SELECT * FROM listdata where pa='N/A' ORDER by et ";
$result = mysql_query("$sqlf",$db);

which didn't work, and many different methods have not worked. any ideas will be greatly appreciated!

Anon

Basically I have one page that shows a table using the sql statement:

$sql = "SELECT * FROM listdata";

At the bottom of the page I have a drop down menu box where users could potentially select a filter for the table.
The html looks like this:
<form name="form1" method="post" action="<?php echo $PHP_SELF?>">
<select name="sqlf">
<option value="SELECT * FROM listdata where pa=\"TTC\" ">TTC</option>

If the user submits the info it is loaded back to the page, but the new sql statement doesn't quite make it: I end up with this error:
Warning: Supplied argument is not a valid MySQL result resource in...

and the sql I passed ends up like this:
SELECT * FROM listdata where pa=\.

quess I'm just to new at this stuff...I'll keep plugging though.