This was just an example :) You can do :
<? $result=mysql_query("Select * FROM Packages") or die(mysql_error()); While($row = mysql_fetch_object($result)) { Echo"package" . $row->id : $row->type <BR>"; } ?> You can reuse $result if you need to or you can just assign it all to a variable and dump it multiple times down the page... up to you.... Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. -----Original Message----- From: Ryan A [mailto:[EMAIL PROTECTED] Sent: Saturday, June 07, 2003 9:13 PM To: Boaz Yahav Cc: [EMAIL PROTECTED] Subject: Re: [PHP] please help, simple problem (i think) Hi, I dont have packageName there....just id,type Plus i need to do this in 2 places....so if i could assign each counts result to a variable...it would be realllly easy. Cheers, -Ryan ----- Original Message ----- From: "Boaz Yahav" <[EMAIL PROTECTED]> To: "Ryan A" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, June 07, 2003 8:11 PM Subject: RE: [PHP] please help, simple problem (i think) > I guess you mean something like : > > <? > $result=mysql_query("Select PackageName FROM Packages ORDER BY > PackageName") or die(mysql_error()); > While($row = mysql_fetch_object($result)) { Echo"$row->PackageName > <BR>"; } > ?> > > > Sincerely > > berber > > Visit http://www.weberdev.com/ Today!!! > To see where PHP might take you tomorrow. > > -----Original Message----- > From: Ryan A [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 07, 2003 9:06 PM > To: Boaz Yahav > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] 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:[EMAIL PROTECTED] > > Sent: Saturday, June 07, 2003 8:54 PM > > To: [EMAIL PROTECTED] > > 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 > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php