RE: [PHP] PHP array information.

i dont quite think i understand the question, but if you want to fetch results as an array with mysql, do this: $result = mysql_query(".... sql ...."); mysql_fetch_array($result); > -----Original Message----- > From: Chris Oxenreider [mailto:oxenreid@state.net] > Sent: Monday, July 09, 2001 12:39 PM > To: php-general@lists.php.net > Subject: [PHP] PHP array information. > > > > Hello: > > My apologies if this has been covered before, or if i have missed it on > the php manual web pages. I am looking for some information on how to do > a perl like array with a *sql call in PHP. > > > Here is what I want to do: > > table: > problem_class > _rid (tinyint) > description (mediumtext) > > Sample data: > _rid description > 1 open > 2 closed > 3 testing > 10 S > 11 M > 12 L > 13 XL > 20 Black > 21 Red > 22 Green > 23 Blue > > > In perl this might be accomplished by doing this: > (Note some pseudo code is used here. Assume mysql as database but > could be others like Oracle.) > > $query = "SELECT _rid,description FROM problem_class"; > $q_pointer = sql_query($query); > @problem_class = sql_associate_array_get($q_pointer); > > print "<select name=\"status\">\n"; > for ($i = 0; $i < 10 ; ++$i) { > if ( $problem_class[$i] ne "") { > print " <option value=\"$i\"> $problem_class[$i]\n"; > } > } > print "</select>\n"; > > print "<select name=\"size\">\n"; > for ($i = 10; $i < 20 ; ++$i) { > if ( $problem_class[$i] ne "") { > print " <option value=\"$i\"> $problem_class[$i]\n"; > } > } > print "</select>\n"; > > print "<select name=\"color\">\n"; > for ($i = 20; $i < 30 ; ++$i) { > if ( $problem_class[$i] ne "") { > print " <option value=\"$i\"> $problem_class[$i]\n"; > } > } > print "</select>\n"; > > > This produces something very close to this: > > <select name="status"> > <option value="1"> open > <option value="2"> closed > <option value="3"> testing > </select> > > <select name="size"> > <option value="10"> S > <option value="11"> M > <option value="12"> L > <option value="13"> XL > </select> > > <select name="color"> > <option value="20"> Black > <option value="21"> Red > <option value="22"> Green > <option value="23"> Blue > </select> > > > If I could use something like this, it would allow me to produce different > 'for' statements for each select drop down I wanted to create. One table > to maintain, and change encase politics force me to change some of > definitions with out having to do a massive sql update. This works as > long as the problem_class table is rather short (ie less than 1,000 > records). > > I know I am missing something 'obvious' in this. Your help is > appreciated. Thank you. > > > > > -- > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Chris Oxenreider | oxenreid@state.net | > http://www.state.net/~oxenreid > | MicroSoft Windows 2000: The De facto sub standard. > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >