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
