differences between php3 and php4

[Anon]

This code works in php3, but not php4, can anyone help?

$db = mysql_connect("localhost", "me", "mypassword");
mysql_select_db("hprhs",$db);
$result = mysql_query("SELECT * FROM joblist where jobstatus = 'Active'",$db);

while ($myrow = mysql_fetch_array($result)) {

I have tried this, but it returns "0 is not a valid mysql result" error:

$db_name = "hprhs";

$table_name = "joblist";

$sql = "SELECT *
FROM joblist
WHERE jobstatus = 'Active'
";

$connection = mysql_connect("localhost", "me", "mypassword") or die("Couldn't
connect.");

mysql_select_db("classDB", $connection) or die("Couldn't select database.");
$result = mysql_query("SELECT * FROM joblist");

while ($myrow = mysql_fetch_array($result)) {

moonie 😉

[[deleted]]

Error checking is not a luxury, it's a must

try this:

if (!$result = mysql_query("SELECT * FROM joblist"))
{
echo mysql_error();
}
else
{
while ($myrow = mysql_fetch_array($result))
{
}
}