peoplesfc

Code and databases were resotred from backup. They look exactly the same on both sides (old server and new). It was fairly transparent transistion from one cPanel to another...

Thank you in advance for the support. Hopefully this will be very easy for one of you programmers out there. I recently moved our webiste to a new host provider. Everything worked well besides one page that links to phpMyAdmin. I have requested help from the hosting provider, but have turned me down (only stating it may be a version conflict within the code). I've been researching on the web, but cannot get anything I try to work. On the old server the php version was 5.3.6 . On the new one, I have the options of 5.3.20, 5.2.17, 5.3.8, 5.4.0, 5.4.8. Here is the error message I get on the page: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/peoplesf/COOP/includes/events_listing.php on line 14 Here is a portion (I think the relevant part) of the php file: require_once('../inc/db.php'); $result = mysql_query("SELECT event_date_start, event_date_end, event_title, event_description, a.assoc_name AS registration_type, b.assoc_name AS location, c.assoc_name AS speaker FROM coop_events LEFT JOIN coop_assocs a ON a.assoc_id = event_registration_id LEFT JOIN coop_assocs b ON b.assoc_id = event_location_id LEFT JOIN coop_assocs c ON c.assoc_id = event_speaker_id WHERE event_active = 1 ORDER BY event_weight ASC, event_date_start ASC "); while($row = mysql_fetch_array($result)) { <---line 14 echo '<div class="event_single">'; $date_part_1 = date("l F j", strtotime($row['event_date_start'])); if ($row['event_date_start'] == $row['event_date_end']) { // Do not display time $date_part_2 = ''; } else { // , 7-8:30pm $start_time = date("g:ia", strtotime($row['event_date_start'])); $end_time = date("g:ia", strtotime($row['event_date_end'])); if ( (stristr($start_time,'am') && stristr($end_time,'am')) || (stristr($start_time,'pm') && stristr($end_time,'pm'))) { $start_time = date("g:i", strtotime($row['event_date_start'])); }