Re: AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread Johannes Janson
Hi, $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]; this should be $deptcount[] .= $row[0]; shouldn't it? } cheers J -- PHP Database Mailing List

Re: AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread 1LT John W. Holmes
$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]; this should be $deptcount[] .= $row[0]; shouldn't it? No. The way it's written is it's adding an

Re: AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread Micah Stevens
Nope. Anytime you set an array with no index equal to something, (i.e. $deptcount[]) it will add another element to the end of the array. If you use .=, that means append the data, but since you're not specifying an element, I'm not sure what it would do. Perhaps PHP is smart enough to just

Re: AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread Johannes Janson
Hi, Micah Stevens wrote: Nope. Anytime you set an array with no index equal to something, (i.e. $deptcount[]) it will add another element to the end of the array. If you use .=, that means append the data, but since you're not specifying an element, I'm not sure what it would do. Perhaps