> Feeling a little braindead, please help.
You post here more than I do.
> The below program as you can see is extremly simple,
> it connects to the database and runs a select (COUNT) query, this
query
> will
> return 5 rows...so far so good, everything is working but I have no
idea
> how
> to assign each of the rows to a variable so I can use it...
> something like:
> $one=$row[1];
> $two=$row[2];
> $thr=$row[3];
>
> heres the code:
>
> <?php
> require "configbwh.php";
>
> $connected=mysql_connect ("$hostt", "$userr", "$passs") or die ('I
cannot
> connect to the database because: ' . mysql_error());
> mysql_select_db ("$db");
>
> $tt = "SELECT ptype, count(*) FROM mylist WHERE ptype IN ('1', '2',
'3',
> '4','5') GROUP BY ptype";
>
> if($res= mysql_query($tt))
> {
> while($row = mysql_fetch_row($res))
> {
> print($row[1]);
$var[$row[0]] = $row[1];
Now $var is an array such as
$var[type 1] = count 1
$var[type 2] = count 2
To cycle through and display it:
foreach($var as $key => $value)
{ echo "$key : $value"; }
---John W. Holmes...
Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
