Need some help here please

[VK4KBG]

Hi,

I am getting this error:

http://www.bikesforsale.net.au/admanager/

 

here is the section of  script:

$a = mysql_query("select id, time_hold, grp, count, description, notify from banners where limit_type = 3");

LINE 22  if (mysql_num_rows($a)) {

while ($b = mysql_fetch_array($a)) {

$c = $b[time_hold]; $f = $b[id]; $gr = $b[grp]; $ad = $b[count]; $desc = $b[description]; $not = $b[notify];

if ($sys_time > $c) {

mysql_query("update banners set time_hold = time_hold+1, count = count-1 where id = $f"); }

if ($ad == $nld && $not != 1) {

mysql_query("update banners set notify = 1 where id = $f");

$ntype = "$notify_limit_days Days";

include("config/email.php"); } } } }

?>

 

Any help gratefully received

[PFMaBiSmAd]

Your query failed to execute and returned an error instead of a result resource. For debugging purposes echo mysql_error(); on the line immediately after the line with the mysql_query() statement.

[scvinodkumar]

check all the fields u mentioned in the query, may be the spelling will be wrong or field doesn't exist