toplinkage Posted May 4, 2008 Share Posted May 4, 2008 The Time and Date for my website does not work, it controls all the start and ending times for all auctions. Here is the error code that I get when I log into my admin area under Time and Date. 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 248 Here is the file that it is in $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') { ?> Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/ Share on other sites More sharing options...
pocobueno1388 Posted May 4, 2008 Share Posted May 4, 2008 Change this line: $sql_select_dateformat = mysql_query("SELECT * FROM probid_dateformat"); To: $sql_select_dateformat = mysql_query("SELECT * FROM probid_dateformat")or die(mysql_error()); See if you get an error. I'm guessing you spelled the tables name wrong. Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533050 Share on other sites More sharing options...
toplinkage Posted May 4, 2008 Author Share Posted May 4, 2008 Yes I got an error, and every time that I have someone tell me to try and switch things like you did the error just goes to another line, like this error started on line 247, then 248 and now it went to 250. This sucks so much. Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533054 Share on other sites More sharing options...
BlueSkyIS Posted May 4, 2008 Share Posted May 4, 2008 is it the same error or a different one now that you changed the code as shown? Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533059 Share on other sites More sharing options...
toplinkage Posted May 4, 2008 Author Share Posted May 4, 2008 This is what I get on the admin page, where the first code was, it actually messed up the whole admin area. Where is says Select time offset there is a drop down box to change the server time. Table 'kuspe.probid_dateformat' doesn't exist Time and Date Settings Time Offset Select time offset Server Time Select the time difference between your local time and the server's time. This setting will apply to all instances where dates are displayed. Date Display Format Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533064 Share on other sites More sharing options...
BlueSkyIS Posted May 4, 2008 Share Posted May 4, 2008 the problem appears to be: Table 'kuspe.probid_dateformat' doesn't exist there is no table called probid_dateformat in the database kuspe Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533069 Share on other sites More sharing options...
toplinkage Posted May 4, 2008 Author Share Posted May 4, 2008 Thanks for trying I will keep working on it? Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533070 Share on other sites More sharing options...
pocobueno1388 Posted May 4, 2008 Share Posted May 4, 2008 Check your database and make sure there is a table called "probid_dateformat". You probably spelled it wrong. Link to comment https://forums.phpfreaks.com/topic/104119-i-need-help-with-this/#findComment-533092 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.