setting the selected value of a drop down box using php and mysql database?

Question

hello .. m trying to get/fetch the database value into dropdown box as a selected value in the dropdown box using PHP script and mysql - phpmyadmin database ..

but m having problems in it .. here is my script which i m using ..


----------------------------------------------------------------------------------------------------
try.php
-------------------------------------
$conn = mysql_connect("localhost","root","") or die("could not connect to localhost");
mysql_select_db("test") or die("could not connect to database");
$qry = "select * from table1 where id=1";
$result = mysql_query($qry) or die(mysql_error());

while($rows = mysql_fetch_array($result))
{
$myDate=$rows['date'];
?>
Date :


for ($date=1;$date>=31;$date++)
{
if ($myDate==$year)
{
$s="selected='selected'";
}
else
{
$s="";
}
?>
>



}

}
?>
----------------------------------------------------------------------------------------------------

m getting the BLANK DROPDOWN BOX as soon as i run my webpage ..

please suggest me whats wrong m doing here ..

Answer 1

Build a string using the php and display it later. So :

$option_str = "",

//your date select routine here with this in each loop :

{



$res = mysql_query(select whatever where your criteria and datefield = '$thisloopdate' );

if(mysql_num_rows($res) = 1){

$selected = "selected='selected' ";

}

$option_str .= "$thisloopdate";

// do not leave the gaps between the ' and " I did this for clarity

}//end loop

echo $option_str;

?

2016-10-16 05:23:48 UTC

i do no longer comprehend why you probably did that ? in case you opt to try this use this way . >/option /choose

Arvin Clark Rivera

2015-01-06 00:10:05 UTC

so hard

ⓘ

This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.

about - legalese

Loading...

Answer 2

i do no longer comprehend why you probably did that ? in case you opt to try this use this way . >/option /choose

Answer 3

so hard