$db Converstion

jackel · 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

duck · Involved Joined: Jul 03, 2006 Posts: 267

remove the comma $sql from both lines

oh and turn Mysql_fetch_row to $db->sql_fetchrow

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

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 );

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

ok I added

Code:

$db->sql_fetchrow

but it still needed the comma

Palbin · Posted: Sat Mar 21, 2009 4:28 pm

Read the sticky.

duck · Involved Joined: Jul 03, 2006 Posts: 267

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);