You are here: Re: [PHP] Converting a query for use in a form « PHP « IT news, forums, messages
Re: [PHP] Converting a query for use in a form

Posted by "Richard Lynch" on 09/28/71 11:18

On Wed, June 8, 2005 9:59 pm, kevin@newage-hosting.com said:
> I hope you can all help me. I want to take the information I get from a
> query and use it is a form as a dropdown select box. For example I want to
> pull the colors from a table and list them in a drop down box and then
> when
> a user selects a color it will pass the colorID for use in writing to
> another table. I hope that comes across the way I mean. :-( Anyway, I
> think
> I used to use something called wddx with java to do this when I was coding
> in ColdFusion.

<?php
$color = isset($_REQUEST['color']) ? $color : 'white';
$query = "select color from soaps";
$colors = mysql_query($query, $connection) or
error_log(mysql_error($connection) . " $query");
$kosher = false;
echo "<select name=\"color\">\n";
while (list($c) = mysql_fetch_row($colors)){
//Cheap and easy data scrubbing:
if ($c == $color) $kosher = true;
$selected = $c == $color ? 'SELECTED' : '';
echo "<option $selected>$c</option>\n";
}
echo "</select>\n";
//If they didn't pick a valid color, make it white
if (!$kosher) $color = 'white';
//Or log their IP
//Or raise a Red Alert.
//Or Whatever.
?>

--
Like Music?
http://l-i-e.com/artists.htm

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация