Re: please help, simple problem (i think)

Hi, Basically I am offering some packages and I want to say: These are the following packages with your account: package1 (-$row1-) package2 (-$row2-) package3 (-$row3-) package4 (-$row4-) package5 (-$row5-) how to do it? Thanks, -Ryan > Maybe you should tell us what you really want to do? > Usually you don't just assign a row value to a variable. > > Sincerely > > berber > > Visit http://www.weberdev.com/ Today!!! > To see where PHP might take you tomorrow. > > > -----Original Message----- > From: Ryan A [mailto:ryan@jumac.com] > Sent: Saturday, June 07, 2003 8:54 PM > To: php-general@lists.php.net > Subject: [PHP] please help, simple problem (i think) > > > Hi, > Feeling a little braindead, please help. > 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]); > } > } > ?> > > Cheers, > -Ryan > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >