Hi,
it would have been easier to help you if you included some code snippet...
Use something like this:
$res = mysql_query ("SELECT COUNT(deptid) FROM maintenance GROUP BY
deptid");
$deptcount = array(); // reset the array
while ($row = mysql_fetch_row ($res)) {
$deptcount[] = $row[0];
}
Thomas
> -----Ursprüngliche Nachricht-----
> Von: LSC Exhibits Department [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 23. September 2002 19:17
> An: '[EMAIL PROTECTED]'
> Betreff: [PHP-DB] getting mysql_fetch_row into array
>
>
> Going through brain-lock here. From this query "Select
> count(deptid) from
> maintenance group by deptid" ,I get 11 rows. What I need to
> do is get an
> array like $a=array(315,11,43,67,415,32,25,63,93,46,76) from
> this query, so
> that
> $a[0]=315
> $a[1]=11
> $a[2]=43
> and so on. The best I can get is ;
> $a[0][0]=315
> $a[0][1]=11
> $a[0][2]=43 and so on. Does anyone have any ideas???
>
> John Coder
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
