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
