Dynamic List box

Aybabtu

I am trying to build a list box in PHP that will go to the database we have and pull the options from all the rows in one collum in the database.

for example, if I had a database and I wanted all of the fields from imported into a list box with all of the data from one collum of the database.

Please help me out I am starting to go insane from all of this code. Thanks

ahundiak

Something like:

<form method="get" action="process.php">
<select name="pick">

<?php
  /* Connect to database as usual */

  /* Query value and content */
  $items = mysql_query('SELECT value,content FROM atable');
  if (mysql_errno()) die(mysql_error();

  /* Cycle through an build option elements */
  while($item = mysql_fetch_object($items))
  {
?>
<option value="<?= $item->value ?>"><?= $item->content ?></option>
<?php } ?>
</select>
<input type="submit" name="submit" value="Push Me" />
</form>

And process.php:
<?php
$value = $_GET['pick'];
echo $value;
?>

Aybabtu

I tried the code you gave me but it is still not working I get the options box but is just says content ?>. Here is my code.

<html>
<head><center><strong>Barberino Car Search</strong></center></head>
<body>
<form method="get" action="process.php">
<select name="pick">

$user="vminter_admin";
$host="localhost";
$password="12041980";
$database="vminter_cars"

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to the server");

/ Query value and content /
$items = mysql_query('SELECT * FROM inventory');
if (mysql_errno()) die(mysql_error();

/ Cycle through an build option elements /
while($item = mysql_fetch_object($items))
{
?>
<option value="<?= $item->value ?>"><?= $item->content ?></option>
<?php } ?>
</select>
<input type="submit" name="submit" value="Push Me" />
</form>

</body>
</html>

kevinsequeira

<?php while($row = mysql_fetch_array($items)){?>
<option value="<?php print($row['id']);?>"><?php print($row['id']);?></option>
<?php } ?>

just replace ['id'] with the column name in your table like ['column_name']

reg
kevin

Aybabtu

Maybe I am just retarded but I cant get it to work. What am I doing wrong.

kevinsequeira

try this

<?php
$user="vminter_admin";
$host="localhost";
$password="12041980";
$database="vminter_cars"

mysql_connect($host,$user,$password);
mysql_select_db($database);
if(mysql_error()){
	echo mysql_error();
}

$query = "select * from inventory";
$result = mysql_query($query);
if(mysql_error()){
	echo mysql_error();
}
if(mysql_num_rows($result) > 0){
	$debug_info = "there are records";
}else{
	$debug_info =  "no records in database";
}
?>
<html>
<head><center><strong>Barberino Car Search</strong></center></head>
<body>
<form method="get" action="process.php">
<?php print($debug_info);?>
<select name="pick">
<?php while($row = mysql_fetch_array($result)){?>
<option value="<?php print($row[0]);?>"><?php print($row[0]);?></option>
<?php } ?>
</select>
<input type="submit" name="submit" value="Push Me" />
</form>
</body>
</html>

what is the output, what are the errors if any? if you cant see the dropdown box with values what is present when you view source for the generated page ??

reg
kevin

Aybabtu

Guys,

Thank you for all your help, I was finally able to get it once I looked at kevins example. You guys rock!! If I have anymore questions I will be sure to ask here.