AW: [PHP-DB] getting mysql_fetch_row into array
| From: | Thomas Lamy | Date: | Mon, 23 Sep 2002 17:28:31 +0000 |
| Subject: | AW: [PHP-DB] getting mysql_fetch_row into array | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21944@lists.php.net to get a copy of this message | ||
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:LSCEXHIBITS@louky.org]
> Gesendet: Montag, 23. September 2002 19:17
> An: 'php-db@lists.php.net'
> 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
>