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

Reply via email to