Why is the index undefined??

Anon

b0c0d0a1n2, , , , , , , , ,
Warning: Undefined offset: 9 in f:/Xitami/webpages/davjuani/test.php on line 27
, b0c0d0a1n1, , , , , , , , ,
Warning: Undefined offset: 9 in f:/Xitami/webpages/davjuani/test.php on line 27

I have two records in my database.
Above is the result of the code below:

$result=mysql_query(" select * from card_spec
where card_id like '%c0%'");

if(mysql_num_rows($result)==0)
{echo("no results");}
else
{
while ($row=mysql_fetch_array$result))
{
$num_rows=count($row);
for($i=0; $i<$num_rows; ++$i)
{
echo ("$row[$i], ");
}
}

I tried creating an index on the table, but that didn't help. I tried using mysql_fetch_array, but that didn't help either.

Any suggestions??

rrijnders

$result=mysql_query(" select * from card_spec where card_id like '%c0%'");

if(mysql_num_rows($result)==0){
  echo("no results");
}
else {
  while ($row=mysql_fetch_array$result)) {
-----------------------------------/\
*paren missing
  $num_rows=count($row);
  for($i=0; $i<$num_rows; ++$i) {
---------------------------/\
increment after, not before*
    echo ("$row[$i], ");
  }
}

Also, since mysql_fetch_array() creates an associative array, I am not sure whether you can reference the values by index (I have never tried).

-- rich

Anon

It's probably because index of array is counted from zero (0) not from 1 as you have. You have to change your cycle from this
for($i=0; $i<$num_rows; ++$i) to this
for($i=0; $i<$num_rows; $i++)

Incrementation if $i have to be after one cycle not before.

Zdenek

Anon

I hear what your saying, but what confounds me is that I can set creat an array of the selected records

$row=mysql_fetch_array($result);

and I can echo the first element in the array:

echo("$row[0]");

but when I try to echo the second element (which I suppose would be "1") I don't get a return.

echo("$row[1]"); //doesn't work

I thought there might have been something wrong with my table so I did a --recover on it, but it turned out ok.

I don't understand why all of the keys aren't getting put in to the array. (???)