$db Converstion

Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

Code:

 $result = $db->sql_query("SELECT modulename, auto_start, picture, picture_dir, defpicture, nopicture_name FROM ".$prefix."_internet_radio_settings", $sql );


  list($modulename, $auto_start, $picture, $picture_dir, $defpicture, $nopicture_name) = mysql_fetch_row ($result, $sql);

Whats wrong with this? can you help please

Thanks

Involved Joined: Jul 03, 2006 Posts: 273

remove the comma $sql from both lines

oh and turn Mysql_fetch_row to $db->sql_fetchrow

Posted: Sat Mar 21, 2009 2:22 pm

Parse error: syntax error, unexpected T_VARIABLE on line 36
Line 36

Code:




$result = $db->sql_query("SELECT radio_id, radio_name, radio_language FROM ".$prefix."_internet_radio ORDER BY radio_name ASC" $sql );

Posted: Sat Mar 21, 2009 2:41 pm

ok I added

Code:

$db->sql_fetchrow

but it still needed the comma

Posted: Sat Mar 21, 2009 4:28 pm

Read the sticky.

Posted: Sat Mar 21, 2009 4:48 pm

Shoudl look like this:

Code:

 $result = $db->sql_query("SELECT modulename, auto_start, picture, picture_dir, defpicture, nopicture_name FROM ".$prefix."_internet_radio_settings");


  list($modulename, $auto_start, $picture, $picture_dir, $defpicture, $nopicture_name) = $db->sql_fetchrow ($result);