What is wrong ??

[aelma]

What is wrong in this code ??

<?
$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

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

}
?>

When i open this page show me this error:

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

Thx for help

Ana Elisa Martinez

[kevinsequeira]

<?
mysql_connect("localhost", "root","datatec1");
mysql_select_db("intranet");
$sql="select insti from incident";
$result=mysql_query($sql);
if(mysql_error()){
	echo mysql_error();
	exit;
}
echo "<select name=myselect>";
echo "<option value=0>please select</option>";
while($rows=mysql_fetch_array($result)){
	$option = $rows['insti'];
	echo "<option value=".$option.">".$option."</option>";
}
echo "</select>";
mysql_close();
?>

reg
kevin

[aelma]

With the code you give me, i have a similar error:

"; echo "please select"; while($rows=mysql_fetch_array($result)){ $option=$rows[insti]; echo "".$option.""; } echo ""; mysql_close(); ?>

I don't know why, i have other php pages and have not errors, and run correctly.

Thx for help

Ana Elisa Martínez

[artic]

im not sure excatly how to fix but for some reason its echoing the wrong thing. thats y u see "" and not the stuff inside it when it prints the page. i hope that helps ya.

[crazyrick]

<?php
mysql_connect('localhost', 'root','datatec1');
mysql_select_db("intranet");
$sql = 'select insti from incident';
$result = mysql_query($sql) or die(mysql_error());

$html = '<select name=myselect>';
$html .= '<option value=0>please select</option>';

while($row = mysql_fetch_array($result)){
	$option = $row['insti'];
$html .= "<option value=$option>$option</option>";
}
$html .= '</select>';
echo $html;
mysql_close();
?>

Try this, I'm not 100% sure if it will work because I'm writing this top of my head, and haven't tested it.

[Shrike]

Are you sure PHP is actually running on your server? Looks like thats garbled HTML.

View the source to see if this is the case 🙂