Next question

I am creating an SQL statement on the fly, dependent upon the users search.

When I run the code, I am getting the following error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in d:\php\record.php on line 66

The code is below:

Line 65 $strSQL = mysql_query($sql);
Line 66 $totalrows = mysql_num_rows($strSQL);

Any ideas why I am getting this error?

on line 64 can you insert a line that reads:

echo $sql;

then paste that output here. Its probably the format of your query causing the problem.

Also, if you could post the actual line in the code that sets the query.

dont know if this matters but when I do a mysql_query() i do it like this

mysql_query($sqlquery, $connection);
$connection being the connection string connecting the script to the database

hope that helps

Ok SQL being outputted is:

SELECT title, sector, location FROM job WHERE location = 'halifax'

What do you mean by the code that sets the query? Do you want me to post the whole code that creates the SQL query on the fly?

Try inserting this before line 64 and see what it outputs.

$testsql = "SELECT title from job";
$testquery = mysql_query($testsql);
$testrows = mysql_num_rows($testquery);
echo $testrows;
echo $testsql;

and paste the output here.

The problem is with the SQL - just spotted it.

I am trying to return an field that isn't the same name as I am querying.

Phew. Thanks for the responses.

That would do it.

Glad you were able to spot it and get your code working.