RE: [PHP] please help, simple problem (i think)
| From: | Boaz Yahav | Date: | Sat, 07 Jun 2003 19:19:26 +0000 |
| Subject: | RE: [PHP] please help, simple problem (i think) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-150600@lists.php.net to get a copy of this message | ||
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:ryan@jumac.com]
Sent: Saturday, June 07, 2003 9:13 PM
To: Boaz Yahav
Cc: php-general@lists.php.net
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" <berber@netvision.net.il>
To: "Ryan A" <ryan@jumac.com>
Cc: <php-general@lists.php.net>
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: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
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>