Populating combobox from sql

Toadums

Hey..i cant find anything on google about this...chances are i'm wording it wrong...

But I have a combo box for project numbers, which I would like to be filled from my Project Number field in the databse that holds projects...

how do i go about doing this?

I tried putting

<td><select name="projNum"><option value= "<?php echo $ProjectID;?>">"<?php echo $ProjectID;?>"</option></select></td>

(something like that)

also:

$query="SELECT * FROM tblProjects";
$result=mysql_query($query);


$num=mysql_numrows($result);

$ProjectID=mysql_result($result,$i,"ProjectID");

I put that in the while loop which populates the report...but it just created a different combobox for each row of the report >.< ...i also tried using javascript...but couldnt get that work either

I have tried a bunch of other things too with no success..

any suggestions would be a huge help!

Thanks,
paul

dagon

$query="SELECT * FROM tblProjects";
$result=mysql_query($query); 

$f='<select name="projNum">';
while ($row = mysql_fetch_array($result)) {
   $f.='<option value= "'.$row['ProjectID'].'">'.$row['ProjectID'].'</option>';
}
$f.='</select>';

echo $f;

Toadums

you are a freaking GOD. thank you!! i spent 1-2 hours yesterday just trying to write it myself.!!!

thanks,
Paul

dagon

Toadums;10915795 wrote:
you are a freaking GOD.

your right: Dagon :-)

Toadums

thats what i mean...of course! lol

It seems my Session date storer isnt working now...it was working yesterday tho..i think. What it does is everytime submit is hit (when it was incrementing the day yesterday), it just decrements the month by 1 and the day switches to either 29,28,27 or 26...its really wierd...

here is the code where my session things happens....

<?php
session_start(); 

$_SESSION['name'] = $_POST['Name'];
$_SESSION['date'] = $_POST['Date'];
$_SESSION['projID'] = $_POST['ProjectID'];
$_SESSION['projName'] = $_POST['ProjectName'];
$_SESSION['client'] = $_POST['Client'];
$_SESSION['type'] = $_POST['Type'];


if($_SESSION['date'] != null){
$year = substr($_SESSION['date'],0,4);
$month = substr($_SESSION['date'],5,2);
$day =substr($_SESSION['date'],7,2);

$dateMK = mktime(0,0,0,date($month),date($day)+1,date($year),dst);

$_SESSION['date'] = date('Y-m-d',$dateMK);

}

then this is on the form where the date is autopopulated...wrong

if($_SESSION['date'] == null){
?>
<tr><td align="right" width="20%">Date: </td><td colspan="2"><input type="text" name="Date" value="yyyy-mm-dd"/></td>

<?php	
}else{




?>



<tr><td align="right" width="20%">Date: </td><td colspan="2"><input type="text" name="Date" value="<?php echo $_SESSION['date']; ?>"/></td>

Also, another question regarding the code you wrote up there. I have to query from another database...is it alright to half way thru my code switch databases??:

(could this be where the error comes from, it wasnt until i added this code)

mysql_connect("url",$username,$password) or die ("Unable to connect to server");
@mysql_select_db("my second database") or die("Unable to select database");

$query="SELECT * FROM tblProjects";
$result=mysql_query($query);

?>

<tr><td align="right" >Project ID: </td><td colspan="2">

<?php


$f='<select name="ProjectID">';
while ($row = mysql_fetch_array($result)) {
   $f.='<option value= "'.$row['ProjectID'].'">'.$row['ProjectID'].'</option>';
}
$f.='</select>';

echo $f; 

?>

</td> 

<td align="right"></td><td colspan="2"><input type="submit" name="projInfo" value="Show Project Information" /></td></tr> <!-- the button will generate project info for Project Name, Client and Type based on project number-->

I hope this all makes sense,
Paul

dagon

don't know what your doing with the date or why. For the db part, if you have two open connections you need to specify which you are using when you query the db.

$connection_one=mysql_connect("url",$username,$password) or die ("Unable to connect to server");
mysql_select_db("my second database",$connection_one) or die("Unable to select database");

$query="SELECT * FROM tblProjects";
$result=mysql_query($query,$connection_one);

if your only using one connection you don't need to specify it, you can change db and keep using the same connection.

Toadums

ahhh, I knew that there had to be something like that!!

What Im doing with the dates...im saving them in the session, and then when the user hits submit it increments the date by 1 (so that they dont have to enter the date everytime)

dagon

so what is echo $_SESSION['date']; returning, and what do you want it to return?

Toadums

I want it to be returned when the new form (after submit refresh) shows up...and I would like it to show the day AFTER the day that the user just inputted. so say the user put in May 20, 2009, after they hit refresh the box already has may 21, 2009 in it (except formatted yyyy-mm-dd)

Also, when I am using the mysql_fetch_row and mysql_fetch_array functions, do i need to put the database name in? ie:

$NameRow = mysql_fetch_row($Pname, $projectDatabase); //gets the project name

or just

$NameRow = mysql_fetch_row($Pname); //gets the project name