Getting values from a data base

aelma

How can i get the values for a combo box from a database field ??

Thx for your help.

Ana Elisa Martínez

bastien

like this:

//connect to db - code not included

$sql="select comboFieldName from table";

$result=mysql_query($sql);

echo "<select name=\"myselect\"><option value=\"\">Choose";

while ($rows=mysql_fetch_array($result)){

 $option=$rows['comboFieldName'];
 //can also get ID or other value here too

echo "<option value=\"$option\">$option";

}//end while

aelma

I write this code, for get a values of a field for a Select:

<?
$link = mysql_connect("localhost", "root","datatec1");
mysql_select_db('intranet',$link);

//$sql="select insti from incident";

$result=mysql_query("SELECT insti from incident");

//echo "<select name=\"myselect\"><option value=\"\"></option>";
//echo "<INPUT TYPE="hidden" name=\"myselect\">";
while ($rows=mysql_fetch_array($result)){

 $option=$rows['insti'];
 //can also get ID or other value here too

// print "<tr align=center>\n";
echo "<option value=\"$option\">$option</option>";

}
?>
I get the following error:

"; //echo ""; while ($rows=mysql_fetch_array($result)){ $option=$rows['insti']; //can also get ID or other value here too // print "\n"; echo "$option"; } ?>

What i did wrong ??

Ana Elisa Martinez

amartinez@med.com.do

bastien

looks like you commented out the start of the select box

here:

//echo "<INPUT TYPE="hidden" name=\"myselect\">";


//code looks fine other than that

<? 
$link = mysql_connect("localhost", "root","datatec1"); 
mysql_select_db('intranet',$link); 

//$sql="select insti from incident"; 

$result=mysql_query("SELECT insti from incident"); 

echo "<select name=\"myselect\"><option value=\"\"></option>"; 

while ($rows=mysql_fetch_array($result)){ 

$option=$rows['insti']; 
//can also get ID or other value here too 

echo "<option value=\"$option\">$option</option>"; 

} 
?>

aelma

I correct the things that u told me:
<?
$link = mysql_connect("localhost", "root","datatec1");
mysql_select_db('intranet',$link);

$result=mysql_query("SELECT insti from incident");
echo "<select name=\"myselect\"><option value=\"\"></option>";
while ($rows=mysql_fetch_array($result)){

 $option=$rows['insti'];
 //can also get ID or other value here too

echo "<option value=\"$option\">$option</option>";

}
?>

Now i have this error:

"; while ($rows=mysql_fetch_array($result)){ $option=$rows['insti']; //can also get ID or other value here too // print "\n"; echo "$option"; } ?>

bastien

cut and paste the whole page of code, pls

kevinsequeira

hi aelma,
dont double post the same question in more than one forum topic.

http://www.phpbuilder.com/board/showthread.php?threadid=10262763

reg
kevin

aelma

The code that i paste here, is the all the code of my page.
I need anymore to get the values of a database field in a select ??

Thx.

Ana Elisa Martínez

ahundiak

You might try using <?php for your opening tag.

Your error message does not make much sense. It has the word 'print' in it yet your posted code does not. Uusually you would get some sort of syntax error. Is php even running on the system?

Add some:
if (mysql_errno()) die(mysql_error());
Lines after each mysql function call.

aelma

I have added the line:

if (mysql_errno()) die(mysql_error());

after each function, the error does not appear anymore, but anyway i can't get the values of a database field for a Combobox.

ahundiak

I don't see your </select> line.
What do you see when you view the html source from within a browser?

If you not getting any option elements then just try echoing out some of the rows data with the select element stuff. That will tell you if data is being retrieved or not.

aelma

My problem is resolved, thx for your help !!!!
I resolved adding php in the tag <?php ?>

Now i have other little thing, when i open the page as part of other page, using include(), the data doesn't appear in the Combobox, the value of the field appears as test in the page.

Why this occur ??

Here the code again:

<?php
echo "<html>";
echo "<head>";
echo "<title>Consulta por Instituci&on</title>";
echo "<body>";

$link = mysql_connect("localhost", "log","test");
mysql_select_db('intranet',$link);

echo "<p align=\"center\"><form action='index.php?o=8' method=\"post\">";
//$sql="select insti from incident"; -->
$result=mysql_query("SELECT insti from incident");
echo "<p align=\"center\">";
echo "<select name=\"opcion\"><option value=\"\">Seleccione Institución</option>";
echo "<INPUT TYPE='hidden' name=\"opcion\">";
while ($rows=mysql_fetch_array($result))
{

 $opcion=$rows['insti'];
 //can also get ID or other value here too
 echo "<tr align=center>\n";
 echo "<option value=\"$opcion\">$opcion</option>";

}

echo "</select>";
echo "<br>";
echo "<br>";
echo "<input type='submit' name=\"Buscar\" value=\"Buscar\">";
echo "<input type='reset' value=\"Cancelar\">";
echo "</body>";
echo "</head>";
echo "</html>";
?>

Thx for help.

Ana Elisa Martinez

bastien

What I would do here is place the code into a function and then include the page as you have done...then all you need to do is call the function and it should show the dropdown. Note that you need to have this in a form to pass it to the next page for further processing


<?php
//the included page
//call the page [b]common.php[/b]
//
//
function my_select()
{
  $link = mysql_connect("localhost", "log","test"); 
  mysql_select_db('intranet',$link); 

  echo "<p align=\"center\"><form action='index.php?o=8' method=\"post\">"; 
//$sql="select insti from incident"; --> 
  $result=mysql_query("SELECT insti from incident"); 
  echo "<p align=\"center\">"; 
  echo "<select name=\"opcion\"><option value=\"\">Seleccione Institución</option>"; 
  echo "<INPUT TYPE='hidden' name=\"opcion\">"; 
  while ($rows=mysql_fetch_array($result)) 
  { 

$opcion=$rows['insti']; 
//can also get ID or other value here too 
echo "<tr align=center>\n"; 
echo "<option value=\"$opcion\">$opcion</option>"; 

  } 

  echo "</select>"; 
  echo "<br>"; 
  echo "<br>"; 
  echo "<input type='submit' name=\"Buscar\" value=\"Buscar\">"; 
  echo "<input type='reset' value=\"Cancelar\">"; 
}//end function 
?>

<?php
//some other page that references common.php
//
include("commom.php");

//more code for this page--don;t forget the form tags

//now reference the select function to show the box
my_select();

//more of your code
?>

aelma

Now all is fine

Thx

Ana Elisa Martínez