View Full Version : Help with converting array into for loop statement in php

12-05-2007, 07:07 PM
I have the following example of array, what I want to do it have it be store in a database and then retrieve it using "for loop" statement. How to do that?

I know how to get the $mode array, but how to programmed the $transport array in php.

code for $mode array:

$sql = "select distinct model from tblcar order by car_di";
$rssql= DBUtils::runQuery($sql,$dbhandle); --> this execute the query

$mode = array();
while ($rsdata = mysql_fetch_assoc($rssql)) {
$mode[] = $rsdata['model'];}

Array Example:

$mode = array('air','water','land');

$transports = array(

$brands = array(
'plane'=>array('Boeing707', 'F-16', 'Columbia'),
'helicopter'=>array('BayWatch Heli', 'Police Heli'),
'boat'=>array('Baywatch Safeguard Boat', 'JetBoat'),
'motorcycle'=>array("Yamaha", "Harley Davidson", "Ducati"),
'car'=>array("Hummer", "Renault", "Porsche")

12-05-2007, 07:34 PM
You don't need a for loop if you're already using a while loop.

I don't really understand the question.

What should happen? You get data from the database, then you determine which part of the arrays it matches?