Please can someone Help Me

toplinkage · April 25, 2008

Hi,

I am new here, I hope someone can help me, here is my problem. I own this auction website and the Date and Time for the site does not work, when I go to the admin area and click the Date and Time there is an error, here is the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/k/u/s/kuspe/html/admin/templates/general_settings.tpl.php on line 247

Ok now here is the file that this error is coming from, I think, I at not that great at this stuff, I like working websites but not working the inside. Here is the file that it is talking about

<?

#################################################################

## PHP Pro Bid v6.03 ##

##-------------------------------------------------------------##

#################################################################

if ( !defined('INCLUDED') ) { die("Access Denied"); }

?>

<table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>

<td rowspan="2"><img src="images/i_tables.gif" border="0"></td>

<td width="100%"><img src="images/pixel.gif" height="24" width="1"></td>

<td> </td>

</tr>

<tr>

<td width="100%" align="right" background="images/bg_part.gif" class="head"><?=$header_section;?>

/

<?=$subpage_title;?></td>

<td><img src="images/end_part.gif"></td>

</tr>

</table>

<br>

<?=$msg_changes_saved;?>

<table width="100%" border="0" cellpadding="3" cellspacing="3" class="border">

<tr align="center" class="c3">

<td colspan="2"><b>

<?=$subpage_title;?>

</b></td>

</tr>

<form name="form_general_settings" method="post" action="general_settings.php">

<input type="hidden" name="page" value="<?=$page;?>">

<? if ($_REQUEST['page']=="signup_settings") { ?>

<tr class="c1">

<td align="right" nowrap><?=AMSG_NO_CONF_REQ;?></td>

<td><input type="radio" name="signup_settings" value="0" <? echo ($setts_tmp['signup_settings']==0) ? 'checked' : ''; ?> /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_NO_CONF_REQ_DESC;?></td>

</tr>

<tr class="c1">

<td align="right" nowrap><?=AMSG_EMAIL_ADDR_CONF;?></td>

<td><input type="radio" name="signup_settings" value="1" <? echo ($setts_tmp['signup_settings']==1) ? 'checked' : ''; ?> /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_EMAIL_ADDR_CONF_DESC;?></td>

</tr>

<tr class="c1">

<td align="right" nowrap><?=AMSG_ADMIN_APPROVAL;?></td>

<td><input type="radio" name="signup_settings" value="2" <? echo ($setts_tmp['signup_settings']==2) ? 'checked' : ''; ?> /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_ADMIN_APPROVAL_DESC;?></td>

</tr>

<tr class="c3">

<td align="right" nowrap></td>

<td></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_SIGNUP_SETTS_NOTE;?></td>

</tr>

<? } else if ($page == 'closed_auctions_deletion') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_CLOSED_AUCT_DEL;?></td>

<td><input name="closed_auction_deletion_days" type="text" id="closed_auction_deletion_days" value="<?=$setts_tmp['closed_auction_deletion_days'];?>" size="8">

<?=GMSG_DAYS;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_CLOSED_AUCT_DEL_EXPL;?></td>

</tr>

<? } else if ($page == 'hpfeat_items') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_ITEMS_PER_ROW;?></td>

<td><input name="hpfeat_nb" type="text" id="hpfeat_nb" value="<?=$layout_tmp['hpfeat_nb'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_ITEMS_PER_ROW_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_FEAT_BOX_WIDTH;?></td>

<td><input name="hpfeat_width" type="text" id="hpfeat_width" value="<?=$layout_tmp['hpfeat_width'];?>" size="8">

<?=GMSG_PIXELS;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_FEAT_BOX_WIDTH_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_MAX_ITEMS;?></td>

<td><input name="hpfeat_max" type="text" id="hpfeat_max" value="<?=$layout_tmp['hpfeat_max'];?>" size="8"></td>

</tr>

<? } else if ($page == 'catfeat_items') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_ITEMS_PER_ROW;?></td>

<td><input name="catfeat_nb" type="text" id="catfeat_nb" value="<?=$layout_tmp['catfeat_nb'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_ITEMS_PER_ROW_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_FEAT_BOX_WIDTH;?></td>

<td><input name="catfeat_width" type="text" id="catfeat_width" value="<?=$layout_tmp['catfeat_width'];?>" size="8">

<?=GMSG_PIXELS;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_FEAT_BOX_WIDTH_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_MAX_ITEMS;?></td>

<td><input name="catfeat_max" type="text" id="catfeat_max" value="<?=$layout_tmp['catfeat_max'];?>" size="8"></td>

</tr>

<? } else if ($page == 'recently_listed_auctions') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_RECENT_AUCTIONS;?></td>

<td><input name="nb_recent_auct" type="text" id="nb_recent_auct" value="<?=$layout_tmp['nb_recent_auct'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_RECENT_AUCTIONS_EXPL;?></td>

</tr>

<? } else if ($page == 'popular_auctions') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_POPULAR_AUCTIONS;?></td>

<td><input name="nb_popular_auct" type="text" id="nb_popular_auct" value="<?=$layout_tmp['nb_popular_auct'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_POPULAR_AUCTIONS_EXPL;?></td>

</tr>

<? } else if ($page == 'ending_soon_auctions') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_ENDING_SOON_AUCTIONS;?></td>

<td><input name="nb_ending_auct" type="text" id="nb_ending_auct" value="<?=$layout_tmp['nb_ending_auct'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_ENDING_SOON_AUCTIONS_EXPL;?></td>

</tr>

<? } else if ($page == 'auction_images') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_NB_IMAGES;?></td>

<td><input name="max_images" type="text" id="max_images" value="<?=$setts_tmp['max_images'];?>" size="8" maxlength="2"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_NB_IMAGES_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_MAX_FILE_SIZE;?></td>

<td><input name="images_max_size" type="text" id="images_max_size" value="<?=$setts_tmp['images_max_size'];?>" size="8" maxlength="4">

KBytes </td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_IMAGE_MAX_SIZE_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_WATERMARK_TEXT;?></td>

<td><input name="watermark_text" type="text" id="watermark_text" value="<?=$setts_tmp['watermark_text'];?>" size="20" maxlength="80"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_WATERMARK_TEXT_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_MAX_RESIZE;?></td>

<td><input name="watermark_size" type="text" id="watermark_size" value="<?=$setts_tmp['watermark_size'];?>" size="20" maxlength="80"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_MAX_RESIZE_EXPL;?></td>

</tr>

<? } else if ($page == 'currency_setts') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_SELECT_SITE_CURRENCY;?></td>

<td><?=$currency_drop_down;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_SELECT_SITE_CURRENCY_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_AMOUNT_DISPLAY_FORMAT;?></td>

<td><input type="radio" name="amount_format" value="1" checked>

<? echo AMSG_US_STYLE . ': ' . $setts_tmp['currency'] . ' 2,999.95'; ?></td>

</tr>

<tr class="c1">

<td> </td>

<td><input type="radio" name="amount_format" value="2" <? echo ($setts_tmp['amount_format']==2) ? 'checked' : ''; ?>>

<? echo AMSG_EURO_STYLE . ': ' . $setts_tmp['currency'] . ' 2.999,95'; ?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_AMOUNT_DIGITS;?></td>

<td><input name="amount_digits" type="text" id="amount_digits" value="<?=$setts_tmp['amount_digits'];?>" size="8" maxlength="1"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_AMOUNT_DIGITS_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_CURRENCY_SYMBOL_POSITION;?></td>

<td><input type="radio" name="currency_position" value="1" checked>

<? echo AMSG_SYMBOL_BEFORE_AMOUNT . ': ' . $setts_tmp['currency'] . ' 395'; ?></td>

</tr>

<tr class="c1">

<td> </td>

<td><input type="radio" name="currency_position" value="2" <? echo ($setts_tmp['currency_position']==2) ? 'checked' : ''; ?>>

<? echo AMSG_SYMBOL_AFTER_AMOUNT . ': 395 ' . $setts_tmp['currency']; ?> </td>

</tr>

<? } else if ($page == 'time_date_setts') { ?>

<tr class="c4">

<td colspan="2"><?=AMSG_TIME_OFFSET;?></td>

</tr>

<tr class="c1">

<td width="150" align="right"><?=AMSG_SELECT_TIME_OFFSET;?></td>

<td><?=$timezones_drop_down;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_SELECT_TIME_OFFSET_EXPL;?></td>

</tr>

<tr class="c4">

<td colspan="2"><?=AMSG_DATE_FORMAT;?></td>

</tr>

<?

$sql_select_dateformat = mysql_query("SELECT * FROM probid_dateformat");

while ($date_format_details = mysql_fetch_array($sql_select_dateformat)) { ?>

<tr class="c1">

<td width="150" align="right"><? echo $date_format_details['type'] . ' ' .AMSG_FORMAT;?></td>

<td><input type="radio" name="date_format" value="<? echo $date_format_details['id'];?>" <? echo $date_format_details['active'];?>>

<? echo $date_format_details['name'];?></td>

</tr>

<? } ?>

<? } else if ($page == 'ssl_support') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_ACTIVATE_SSL;?></td>

<td><input type="radio" name="is_ssl" value="1" checked>

<?=GMSG_YES;?>

<input type="radio" name="is_ssl" value="0" <? echo (($setts_tmp['is_ssl'] == 0) ? 'checked' : '');?>>

<?=GMSG_NO;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_ACTIVATE_SSL_EXPL;?></td>

</tr>

<tr class="c1">

<td width="150" align="right"><?=AMSG_ACTIVATE_EHANCED_SSL;?></td>

<td><input type="radio" name="enable_enhanced_ssl" value="1" checked>

<?=GMSG_YES;?>

<input type="radio" name="enable_enhanced_ssl" value="0" <? echo (($setts_tmp['enable_enhanced_ssl'] == 0) ? 'checked' : '');?>>

<?=GMSG_NO;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_ACTIVATE_EHANCED_SSL_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_ENTER_SSL_ADDRESS;?></td>

<td><input name="site_path_ssl" type="text" id="content" value="<?=$setts_tmp['site_path_ssl'];?>" size="50">

</td>

</tr>

<? } else if ($page == 'meta_tags') { ?>

<tr class="c1">

<td align="right" width="150"><?=AMSG_ADD_META_TAGS;?></td>

<td><textarea name="metatags" style="width: 100%; height: 150px;" id="metatags"><?=$setts_tmp['metatags'];?></textarea></td>

</tr>

<? } else if ($page == 'cron_jobs') { ?>

<tr class="c1">

<td align="right" width="50%"><?=AMSG_CRON_JOB_CPANEL;?></td>

<td><input type="radio" name="cron_job_type" value="1" <? echo ($setts_tmp['cron_job_type'] == 1) ? 'checked' : '';?>>

</td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_CRON_JOB_PPB;?></td>

<td><input type="radio" name="cron_job_type" value="2" <? echo ($setts_tmp['cron_job_type'] == 2) ? 'checked' : '';?>>

</td>

</tr>

<? } else if ($page == 'min_reg_age') { ?>

<tr class="c1">

<td align="right" width="150"><?=AMSG_MIN_AGE;?></td>

<td><input type="text" name="min_reg_age" value="<?=$setts_tmp['min_reg_age'];?>" size="6">

<?=GMSG_YEARS;?></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_MIN_AGE_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_DATE_OF_BIRTH_TYPE;?></td>

<td nowrap><input type="radio" name="birthdate_type" value="0" checked>

<?=AMSG_DOB_FULL_FORMAT;?></td>

</tr>

<tr>

<td></td>

<td class="c1"><input type="radio" name="birthdate_type" value="1" <? echo ($setts_tmp['birthdate_type']==1) ? 'checked' : '';?>>

<?=AMSG_DOB_YEAR_ONLY;?></td>

</tr>

<? } else if ($page == 'recent_wanted_ads') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_RECENT_WANTED_ADS;?></td>

<td><input name="nb_want_ads" type="text" id="nb_want_ads" value="<?=$layout_tmp['nb_want_ads'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_RECENT_WANTED_ADS_EXPL;?></td>

</tr>

<? } else if ($page == 'auction_media') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_NB_MEDIA;?></td>

<td><input name="max_media" type="text" id="max_media" value="<?=$setts_tmp['max_media'];?>" size="8" maxlength="2"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_NB_MEDIA_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right"><?=AMSG_MAX_FILE_SIZE;?></td>

<td><input name="media_max_size" type="text" id="media_max_size" value="<?=$setts_tmp['media_max_size'];?>" size="8" maxlength="4">

KBytes </td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_MEDIA_MAX_SIZE_EXPL;?></td>

</tr>

<? } else if ($page == 'buy_out_method') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_CHOOSE_METHOD;?></td>

<td nowrap><input type="checkbox" name="buyout_process" value="1" <? echo ($setts_tmp['buyout_process']==1) ? 'checked' : '';?>>

<?=AMSG_BUY_OUT_BUYOUT;?></td>

</tr>

<tr>

<td></td>

<td class="c1"><input type="checkbox" name="makeoffer_process" value="1" <? echo ($setts_tmp['makeoffer_process']==1) ? 'checked' : '';?>>

<?=AMSG_BUY_OUT_MAKEOFFER;?></td>

</tr>

<tr>

<td></td>

<td><?=AMSG_BUY_OUT_ALTER_WARNING;?></td>

</tr>

<? } else if ($page == 'sellitem_buttons') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_CHOOSE_POSITION;?></td>

<td nowrap><input type="radio" name="sell_nav_position" value="1" checked>

<?=AMSG_SELLNAV_POS_1;?></td>

</tr>

<tr>

<td></td>

<td class="c1"><input type="radio" name="sell_nav_position" value="2" <? echo ($setts_tmp['sell_nav_position']==2) ? 'checked' : '';?>>

<?=AMSG_SELLNAV_POS_2;?></td>

</tr>

<? } else if ($page == 'nb_autorelists') { ?>

<tr class="c1">

<td width="150" align="right"><?=AMSG_ENTER_NUMBER;?></td>

<td><input name="nb_autorelist_max" type="text" id="nb_autorelist_max" value="<?=$setts_tmp['nb_autorelist_max'];?>" size="8"></td>

</tr>

<tr>

<td> </td>

<td><?=AMSG_NB_AUTORELISTS_EXPL;?></td>

</tr>

<? } else if ($_REQUEST['page']=="enable_tax") { ?>

<tr class="c1">

<td align="right" nowrap><?=AMSG_ENABLE_TAX;?></td>

<td><input type="checkbox" name="enable_tax" value="1" <? echo ($setts_tmp['enable_tax']==1) ? 'checked' : ''; ?> /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_ENABLE_TAX_DESC;?></td>

</tr>

<tr class="c1">

<td align="right" nowrap><?=AMSG_VAT_NUMBER;?></td>

<td><input type="text" name="vat_number" value="<?=$setts_tmp['vat_number'];?>" size="20" /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_VAT_NUMBER_DESC;?></td>

</tr>

<? } else if ($_REQUEST['page']=="invoices_settings") { ?>

<tr class="c1">

<td align="right" nowrap><?=AMSG_INVOICE_HEADER;?></td>

<td><textarea name="invoice_header" style="width=100%; height: 80px;"><?=$setts_tmp['invoice_header'];?></textarea></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_INVOICE_HEADER_DESC;?></td>

</tr>

<tr class="c1">

<td align="right" nowrap><?=AMSG_INVOICE_FOOTER;?></td>

<td><textarea name="invoice_footer" style="width=100%; height: 80px;"><?=$setts_tmp['invoice_footer'];?></textarea></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_INVOICE_FOOTER_DESC;?></td>

</tr>

<tr class="c1">

<td align="right" nowrap><?=AMSG_INVOICE_COMMENTS;?></td>

<td><textarea name="invoice_comments" style="width=100%; height: 80px;"><?=$setts_tmp['invoice_comments'];?></textarea></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_INVOICE_COMMENTS_DESC;?></td>

</tr>

<? } else if ($_REQUEST['page']=="mcrypt") { ?>

<tr class="c1">

<td align="right" nowrap><?=AMSG_ENABLE_MCRYPT;?></td>

<td><input type="checkbox" name="mcrypt_enabled" value="1" <? echo ($setts_tmp['mcrypt_enabled']==1) ? 'checked' : ''; ?> /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_ENABLE_MCRYPT_EXPL;?></td>

</tr>

<tr class="c1">

<td align="right" nowrap><?=AMSG_MCRYPT_KEY;?></td>

<td><input type="text" name="mcrypt_key" value="<?=$setts_tmp['mcrypt_key'];?>" size="20" /></td>

</tr>

<tr>

<td align="right" nowrap> </td>

<td><?=AMSG_MCRYPT_KEY_EXPL;?></td>

</tr>

<? } ?>

<tr class="c3">

<td align="right" nowrap></td>

<td></td>

</tr>

<tr align="center">

<td colspan="2"><input type="submit" name="form_save_settings" value="<?=AMSG_SAVE_CHANGES;?>"></td>

</tr>

</form>

</table>

Please help me if you can.

Thanks

toplinkage

DarkWater · April 25, 2008

Why post the whole source...? Next time just give us 5 lines above and below the error, and the line with the error.

toplinkage · April 25, 2008

Like I said I am new and I thought the whole thing is what is needed, next time I will do that.

DarkWater · April 25, 2008

Since I don't feel like finding the 247th line in the long code, can you please give me the whole 10 line thing I mentioned in my last post? It'd help me a lot. I know what the problem is, I just want to see what's causing it. (The problem is a bad query, which is making the mysql_query call fail).

mrdamien · April 25, 2008

1. Make sure you specified the right table name.

2. Use mysql_num_rows() to make sure you got some rows returned from your query before you call mysql_fetch_array()

toplinkage · April 25, 2008

</tr>

<?

$sql_select_dateformat = mysql_query("SELECT * FROM probid_dateformat");

while ($date_format_details = mysql_fetch_array($sql_select_dateformat)) { ?>

<? echo $date_format_details['name'];?></td>

</tr>

<? } ?>

<? } else if ($page == 'ssl_support') { ?>

DarkWater · April 25, 2008

Change:

      $sql_select_dateformat = mysql_query("SELECT * FROM probid_dateformat");
      while ($date_format_details = mysql_fetch_array($sql_select_dateformat)) { ?>
      <tr class="c1">
[/php
To:
[code=php:0]
      $sql_select_dateformat = mysql_query("SELECT * FROM probid_dateformat");
      if (mysql_num_rows($sql_select_dateformat) == 0) {
         die(mysql_error());
      }
      while ($date_format_details = mysql_fetch_array($sql_select_dateformat)) { ?>
      <tr class="c1">

toplinkage · April 25, 2008

That did not work, I will keep trying other ways, thanks for the help, once I put that in there is messed up the whole website page. So I put the old code back and now it says the error is on line 248 instead of 247.

DarkWater · April 25, 2008

You put the if (mysql_num_rows.... thing in there? Ignore the

 bit, I forgot the closing BBCode tag. =P  Just add the IF statement and tell me if you get a MySQL error...

toplinkage · April 25, 2008

Yes I get an error

DarkWater · April 25, 2008

That was the point of that line. Please post the error....

toplinkage · April 25, 2008

I will have to post tomorrow, it is late I have to work tomorrow, I will be back I want this fixed. Thanks for all your help I hope you will help at a later time.

Thanks

toplinkage

Sign In

Please can someone Help Me

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived

Important Information