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:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 12:39 PM
> To: [EMAIL PROTECTED]
> 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 | [EMAIL PROTECTED] | 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
