php list box from database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

php list box from database

Post by mhouldridge »

Hi,

I have an update page in which I have echo'd database results like below;

Code: Select all

<? echo $formVars["ThisField"]; ?>
This works for text boxes, however with a list box it does not.


Any ideas?
User avatar
Nathaniel
Forum Contributor
Posts: 396
Joined: Wed Aug 31, 2005 5:58 pm
Location: Arkansas, USA

Post by Nathaniel »

What do you mean by list box? Radio buttons? Could you show us your HTML?
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Sorry,

I mean selection box with say yes or no values...

I am trying to populate it from my database query as follows;

Code: Select all

<?php
session_start(); 
foreach($HTTP_POST_VARS as $varname => $value)
        $formVars[$varname]=$value;
$db = mysql_connect("localhost","",""); 
mysql_select_db ('audit'); 
$query="SELECT * FROM dedicated WHERE asset = \"".$_GET['varl']."\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$formVars = array();
$formVars["title"]=$row["title"];
$formVars["customer"]=$row["customer"];
$formVars["type"]=$row["type"];
$formVars["serial"]=$row["serial"];
$formVars["os"]=$row["os"];
$formVars["oemfull"]=$row["oemfull"];
$formVars["oslicense"]=$row["oslicense"];
$formVars["IP"]=$row["IP"];
$formVars["location"]=$row["location"];
$formVars["processor"]=$row["processor"];
$formVars["memory"]=$row["memory"];
$formVars["motherboard"]=$row["motherboard"];
$formVars["disksize"]=$row["disksize"];
$formVars["value"]=$row["value"];
$formVars["value2"]=$row["value2"];
$formVars["networkcard"]=$row["networkcard"];
$formVars["graphics"]=$row["graphics"];
$formVars["asset"]=$row["asset"];
$formVars["stopped"]=$row["stopped"];
$formVars["recon"]=$row["recon"];
mysql_close($db);
?>

taking the ["recon"] value for the selection box.


thanks
User avatar
Nathaniel
Forum Contributor
Posts: 396
Joined: Wed Aug 31, 2005 5:58 pm
Location: Arkansas, USA

Post by Nathaniel »

Code: Select all

<select name="recon">
<option value="yes"<?PHP if ( $formVars['recon'] == 'yes' ) { ?> selected="selected"<?PHP } ?>>Yes</option>
<option value="no"<?PHP if ( $formVars['recon'] == 'no' ) { ?> selected="selected"<?PHP } ?>No</option>
</select>
I think that may be what you want.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

yep,

that's sorted it - Thanks for you help, much appreciated.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Er,

Just tested this - I thought it was working but it does not..

It does not display the value, just Yes all the time.
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

That's because the value is set to yes or no.
Last edited by Jenk on Mon Oct 10, 2005 9:45 am, edited 1 time in total.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Uhh?

Sorry, I dont follow...

I need this to display the formVar['recon'] value in the selection box.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Hi,


That's definately working now.

One more question. How could I display "no" in the selection box if there is no value entered into that field.

Could I use another if statement to take "" ?
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Ignore that last one, I answered it myself.

Cheers peeps!
Post Reply