creating an array with a loop problem

[Anon]

I want to create an array from 2 tables in a database. The code i am using looks something like this:

$i=0;
while($this=mysql_fetch_array($that)){
$myarray[$s]=array(id=>$varfromtable1,
date=>$varfromtable2);
$i++;
}

Can anybody tell me what's wrong with this?

Thanks

[toma42]

$s is always the same.

$myarray[] = array(.....)
will work.

I suspect you started out with an $s iterator and changed it to $i

[[deleted]]

correct, and if you put

error_reporting(E_ALL)

at the top of your script and you'll find a lot more errors.

[Anon]

thanks for the tips guys.

It's still not quite working but if I can iron out some of the errors, i'm sure it will come.

mojodojo