Re: Arrays from forms

"Jamie" <jssmith@echidna.stu.cowan.edu.au> wrote: > $results = mysql_query("SELECT option_type, code FROM options WHERE > code='000' ORDER BY option_type",$db); > mysql_fetch_array($results); > // From what understand I should have an array some thig like this: > // ("Size"=>"A4" , "Size" => "A3", > "Size"=>"A5", "Colour"=>"Red", etc..); According to your SQL statement that doesn't appear to be true. According to your SQL statement you'll return two fields: option_type and code. > $types = array_values($results); > // OK so now I think I have an array like this: > // ("A4" , "A3", "A5", "Red", etc..); > while ($type =array_pop($types)){ > echo $type."<br>"; > } I'd avoid using array_values() and array_pop(). Simply do this: while ( $row = mysql_fetch_array( $result ) ) { $option_type = $row[option_type]; $code = $row[code]; echo "$option_type $code<br>"; } Hopefully that'll be enough to get you going. -- Steve Werby COO 24-7 Computer Services, LLC Tel: 804.817.2470 http://www.247computing.com/