Mysql Fetch row

JRockfl

I'm working on a tutorial.

This is the code provided...

// get list of departments with open jobs
$query = "SELECT DISTINCT id, department from department, listing WHERE department.id = listing.fk_department"; $result = mysql_db_query($database, $query, $connection) or die ("Error inquery: $query. " . mysql_error());

// iterate through resultset
while(list($id, $department) = mysql_fetch_row($result)){

I get an error about mysql_db_query being extinct or something so i change it to

//get list of departments with open jobs
$query = "SELECT distinct id, department from department, listing
WHERE department.id = listings.fk_department";
$result = mysql_query($query);

// iterate through resultset
while(list($id, $department) = mysql_fetch_row($result))
{

The error I get now is mysql_fetch_row(); supplied argument is not a valid MySQl result resource

Any suggestions?

ereptur

use mysql_fetch_array() rather than mysql_fetch_row()

JRockfl

same error mysql_fetch_array() is not a valid MySQL result resource

ereptur

Are you sure that your query is returning any results?

JRockfl

it should be...this is the tutorial im doing...

http://www.webmasterbase.com/article/867/104

hand

I'm missing backticks.
Note that if the identifier is a restricted word or contains special characters you must always quote it with a (backtick) when you use it:column_name` A column that is a keyword or contains special characters.
more ... http://www.mysql.com/doc/en/Legal_names.html

$query = "SELECT DISTINCT id, department from department, listing
    WHERE department.id = listing.`fk_department`";