combobox

Expand Post »

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[]"

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>

Similar Threads

Filling a ComboBox.... in Java
ComboBox Events in VB.NET
Issue related to combobox.... in VB.NET
need help with ComboBox (C++, Dialog) in C++
Hiding dataitems in a combobox in VB.NET

rohitrohitrohit

Reputation Points: 15

Solved Threads: 5

Junior Poster

Offline

120 posts
since Oct 2007

Permalink

Nov 11th, 2008

Re: combobox

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

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>';
}

Last edited by Rhyan; Nov 11th, 2008 at 7:41 am.

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: How install APC(Alternative PHP Cache) in window

Next Thread in PHP Forum Timeline: problem to display all datas from database

DaniWeb Message

Cancel Changes

User Name
Password