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. Per

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 ad

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 a

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 Maili

AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread Thomas Lamy
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]; }