Advanced php mysql query

why_not2

Hi,
i have 3 plan for my shopping script.
Mysql :

|id|name|level|credit|money

now for show 3 plan i write this code :

<?php $plan=mysql_fetch_array(mysql_query("select * from plans where level=1"));
$plan1 = $plan["money"];
?>
<?php $plano=mysql_fetch_array(mysql_query("select * from plans where level=2"));
$plan2 = $plano["money"];?>
<? $planp=mysql_fetch_array(mysql_query("select * plans where level=3
"));
$plan3 = $planp["money"];
echo $plan1; echo $plan2; echo $plan3; //NOTE :  need to show 3 array plan. without string. without list. 
?>

this worked !! but i dont know this code is good ? bad ? perfect ?
how to write advanced or better code for this??

thanks
Happy New Year :p

bradgrafelman

Are you trying to retrieve all "levels" (even if you only have three at the moment) or only the first three? Assuming the former is true...

There's no need to waste the overhead of using multiple queries - just use one, e.g.

SELECT money
FROM plans
ORDER BY level DESC

If you wanted only the first three, then throw a LIMIT clause onto the end.

why_not2

bradgrafelman;10971656 wrote:
Are you trying to retrieve all "levels" (even if you only have three at the moment) or only the first three? Assuming the former is true...

There's no need to waste the overhead of using multiple queries - just use one, e.g.
SELECT money
FROM plans
ORDER BY level DESC
If you wanted only the first three, then throw a LIMIT clause onto the end.

this plan list updated dynamic. yea i need to check (show $plan1,$plan2,$plan3,..etc) all plane ( 1,2,3, etc).

bradgrafelman

Well in that case I would do as I suggested above, and perhaps store all the plan prices e.g.:

$plans = array();

// $result is mysql resource returned by mysql_query()
while($row = mysql_fetch_assoc($result))
    $plans[$row['level']] = $row['money'];

That way you'd be left with an array $plans with the plan level # being the array key and the 'money' column would be that key's value.

why_not2

bradgrafelman;10971668 wrote:
Well in that case I would do as I suggested above, and perhaps store all the plan prices e.g.:
$plans = array();

// $result is mysql resource returned by mysql_query()
while($row = mysql_fetch_assoc($result))
    $plans[$row['level']] = $row['money'];
That way you'd be left with an array $plans with the plan level # being the array key and the 'money' column would be that key's value.

thanks,Nice. what's a better way for echo (show plan1,plan2,etc... ) plan money ?

bradgrafelman

Well once you build an array like the above, you could use a [man]foreach[/man] loop to echo out the 'level' and corresponding 'money' values in the array.

why_not2

i now! but better foreach method ? please e.g

bradgrafelman

I don't understand what you're asking? What do you mean "but better foreach method" ?