Jump to content

Archived

This topic is now archived and is closed to further replies.

reazik

HELP! Another question from a NOOOOOBIE

Recommended Posts

I keep getting an "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ----------- on line 13" error for this script (the line in question is red).
_________

<?

mysql_pconnect("localhost","xxxxxxxx","xxxxxxxx");

mysql_select_db("psnincne_JobForms");

$result = mysql_query("select * from `psnincne_job_list`");

?>

<?

[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]while($r=mysql_fetch_array($result)) { [!--colorc--][/span][!--/colorc--]
$job_code = $r["job_code"];
$job_title = $r["job_title"];
$job_state = $r["job_state"];
$job_date = $r["job_date"];

echo "$job_code <br> $job_title <br> $job_state <br> $job_date";

}

?>
_________

What's the problem?

Share this post


Link to post
Share on other sites
change this:
[code]
$result = mysql_query("select * from `psnincne_job_list`");
[/code]
to this:
[code]
$result = mysql_query("select * from `psnincne_job_list`") or die (mysql_error());
[/code]
then post any errors

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.