Using a select box

Anthony1312002

I have a select box that I'm trying to use to search for existing records in a database. Here is my select.

<?
$db = mysql_select_db("$DBName",$Link);

	echo" <select name=\"KeyANumber\">  ";  //start the select box 

	$results= mysql_query("SELECT DISTINCT ANumber from activitytracking Order by ANumber asc"); 
	$id = "ANumber";
	$idname = "ANumber"; 
	echo mysql_error(); 

	if (mysql_Numrows($results)>0)                            //if there are records in the fields
	{ 
	  $numrows=mysql_NumRows($results);                       //count them
	  $x=0; 
	  while ($x<$numrows){   //loop through the records
	    $theId=mysql_result($results,$x,$id);                 //place each record in the variable everytime we loop
	    $theName=mysql_result($results,$x,$idname);
	    echo "<option value=\"$theName\">$theName</option>\n";  //and place it in the select
	    $x++;
	  }
	}
	echo "</select>"; 
?>

And here is the sql of the resulting search when I click the submit button.

if (!$CommID) {

// print the list if we are not editing

  $result = mysql_query("SELECT * FROM activitytracking WHERE ANumber Like '%".$_POST[KeyANumber]."%'
            ORDER BY DateOfService",$db);

Everything works just fine when I'm using a simple input box that I can key into. But why doesn't this work with a select list box? I just get a blank page.

kevinsequeira

view the page source, there might be a error message

reg
kevin

kevinsequeira

try this

.
.
.
  if (mysql_Numrows($results)>0){
    while ($row=mysql_fetch_array($results)){
      echo "<option value=".$row['id'].">".$row['idName']."</option>\n";
    }
  }
.
.
.
.

reg
kevin

Anthony1312002

Thanks for getting back to me. I'm still a bit new to PHP and I'm still trying to get my brain around it. Just where would I insert this statement?

kevinsequeira

replace this bit in your code with what i posted

if (mysql_Numrows($results)>0) //if there are records in the fields
{
$numrows=mysql_NumRows($results); //count them
$x=0;
while ($x<$numrows){ //loop through the records
$theId=mysql_result($results,$x,$id); //place each record in the variable everytime we loop
$theName=mysql_result($results,$x,$idname);
echo "<option value=\"$theName\">$theName</option>\n"; //and place it in the select
$x++;
}
}

reg
kevin

Anthony1312002

Okay, this is what I did but now I'm getting nothing in the select box. What did I do wrong?

<?
$db = mysql_select_db("$DBName",$Link);

	echo" <select name=\"KeyANumber\">  ";                      //start the select box 

	$results= mysql_query("SELECT DISTINCT ANumber from activitytracking Order by ANumber asc"); 
	$idname = "ANumber"; 
	$id = "ANumber";
	echo mysql_error(); 

	if (mysql_Numrows($results)>0){ 
   while ($row=mysql_fetch_array($results)){ 
  echo "<option value=".$row['id'].">".$row['idName']."</option>\n"; 
}

}

	echo "</select>"; 
?> <br>

lanjoky

<? 
$db = mysql_select_db("$DBName",$Link); 

echo" <select name=\"KeyANumber\"> "; //start the select box 

$results= mysql_query("SELECT DISTINCT ANumber from activitytracking Order by ANumber asc") or die( mysql_error() ); 
$idname = "ANumber"; 
$id = "ANumber"; 

if (mysql_num_rows($results)>0){ 
while ($row=mysql_fetch_array($results)){ 
echo "<option value='".$row['id']."'>".$idName."</option>"; 
} 
} 

echo "</select>"; 
?>

<br>

Try that and see if it works

kevinsequeira

when u view the source for the page do u see the options like this
<option value=></option>

is the id and name called id and idName in the table, if it isnt you have to replace
$row['id'] and $row['idName'] with what the actual column name is in the table.

ie $row['column name for id'] and $row['column name for name']

run the query in the databse directly, do u get any records [ make sure there are records in the database

reg
kevin