All pastes #461941 Raw Edit

Something

public text v1 · immutable
#461941 ·published 2007-04-27 23:00 UTC
rendered paste body
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource  when I run the following... how do i suppress that?

<?php
$sql="select jobid, jobtitle, jobcode from jobposting where category = 'thera' and dateactive < $currentdate and active = 'yes'";
$query=mysql_query($sql);
 
if ($row=@mysql_fetch_array($query)){
        do {
        ?>
                <p><a class="jobgrn" href="joblisting.php?jobid=<?echo $row['jobid'];?>"><?echo $row['jobtitle'];?></a><br>
                <span class="jobcodewht">JOB CODE: <?echo $row['jobcode'];?></span><br> 
        <?      
        } while ($row=@mysql_fetch_array($query));
} else {
?>      
<p>No listings at this time<br>
<?      
}
?>