RE: [PHP] please help, simple problem (i think)
| From: | Boaz Yahav | Date: | Sat, 07 Jun 2003 19:11:26 +0000 |
| Subject: | RE: [PHP] please help, simple problem (i think) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-150597@lists.php.net to get a copy of this message | ||
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:ryan@jumac.com]
Sent: Saturday, June 07, 2003 9:06 PM
To: Boaz Yahav
Cc: php-general@lists.php.net
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: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
>
>