DaniWeb Forum Index > Web Development > PHP

combobox

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2007

Posts: 45

Reputation: rohitrohitrohit is an unknown quantity at this point

Solved Threads: 3

rohitrohitrohit rohitrohitrohit is offline

Offline

Light Poster

combobox

Nov 11th, 2008

hi all,
i am fetching recods from mysql in a combobox.but only one record display .... i want all record display in combobox ......................i write query below and need help how to sote fetch row in array i declered "$va[]"

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
    // echo "Connected MySql";
  $res1 = mysql_query("SELECT gp FROM gp order by gp") or die("Invalid query: " . mysql_query());
  //echo ".mysql_query()";
   $row=mysql_fetch_array($res1,MYSQL_ASSOC);
$va=array()
   $va[] =$row['gp'];/?????????????????????????????????????????????
 echo '
	<select name="gp" id="gp">';
for($x = 0; $x < count($va); $x++)
{
	  // write "selected" if the value matches the one posted
	  if($va[$x] == $_POST['gp'])
	  {
		  $selected = 'selected';
	   }else{
		  $selected = '';
	   }
	   // print the option
	   echo '
		<option value="'.$va[$x].'"'.$selected.'>'.$va[$x].'</option>';
}echo '</select>';
?>
<?php
    // echo "Connected MySql";
  $res1 = mysql_query("SELECT gp FROM gp order by gp") or die("Invalid query: " . mysql_query());
  //echo ".mysql_query()";
   $row=mysql_fetch_array($res1,MYSQL_ASSOC);
$va=array()
   $va[] =$row['gp'];/?????????????????????????????????????????????
 echo '
	<select name="gp" id="gp">';
for($x = 0; $x < count($va); $x++)
{
	  // write "selected" if the value matches the one posted
	  if($va[$x] == $_POST['gp'])
	  {
		  $selected = 'selected';
	   }else{
		  $selected = '';
	   }
	   // print the option
	   echo '
		<option value="'.$va[$x].'"'.$selected.'>'.$va[$x].'</option>';
}echo '</select>';
?>

Last edited by peter_budo; Nov 12th, 2008 at 5:25 am. Reason: Correcting code tags, please use [code], DO NOT USE <code>

•

Join Date: Oct 2006

Posts: 232

Reputation: Rhyan is an unknown quantity at this point

Solved Threads: 24

Rhyan

Offline

Posting Whiz in Training

Re: combobox

Nov 11th, 2008

Dude,
First of all you have to read all records returned from the DB. You cannot fetch the whole result table from the database using a single php function. PHP can retrieve only one record at a time, so if you want to retrieve all rows from the SQL result, you have to type this many times mysql_fetch_array(), as many rows have been returned from the sql query.
Please check my post here, explaining result retrieval.
http://www.daniweb.com/forums/thread156511.html

Then, once you have all your data, you can proceed with selected / non-selected verification of values in the <select> element.
Instead of loading a variable with name $selected, in my opinion it is better that you do the following

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
if ($result[key] == $_POST[whatever]
 {
 echo '<option value="'.$result[key].'" selected="selected">Whatever text here</option>';
 }
else{
echo '<option value="'.$result[key].'">Whatever text here</option>';
}
if ($result[key] == $_POST[whatever]
 {
 echo '<option value="'.$result[key].'" selected="selected">Whatever text here</option>';
 }
else{
echo '<option value="'.$result[key].'">Whatever text here</option>';
}