some sort of error...

[stew]

the following code gives me an error at the mysql_fetch_array part..

anyone have any ideas?

function index() {

echo ("<P align=center>Please select an artist from the list below</P>");

while ($row = mysql_fetch_array($retid)) {
$artist = $row["artist"];

echo ("<P>$artist</p>"); }

}

function id() {

echo ("this is $artist.");

}

switch($id) {

case 1:
id();
break;

default:
index();
break;

}

cheers,
stew

[cgraz]

is the erorr say not a valid mysql result resource? Do you have a query called $retid?

Cgraz

[sarah]

list $retid as a global?

function index() {
global $retid;

echo ("<P align=center>Please select an artist from the list below</P>");
...

[stew]

$retid is an SQL query, recalling info from a database... what is a global?

[stew]

ok, i got part of the problem sorted... but i have encountered another! 🙁

switch($id) {

case 1:
id();
break;

case 2:
id();
break;

case 3:
id();
break;

...until

default:
index();
break;

}

is it possible to draw the cases from a database, for example an id column in table, and not have to write out an endless number of cases in the script?

ta!

[stew]

function id() {
global $retida;

if($boo = mysql_fetch_row($retida)) {
$artist = $boo["artist"];

echo ("<P>this is $artist.<P>");
}
}

the echo function doesn't show the $artist variable....

hmmm...?

[dustbuster]

You should be using:
mysql_fetch_array($retida)
if you want to reference $boo as an associative array.
mysql_fetch_row() returns an array with numerical indexes.

so:

if($boo = mysql_fetch_array($retida)) { 
 $artist = $boo["artist"];