drop down error

jadi

I have a listbox, and if you click on one value"say XXX" in it then it will display( select * from table where value='xxx')

I tired but i am getting an error

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>

<form id="form1" name="form1" method="get" action="<? echo $PHP_SELF; ?> ">
<?php  

 $host = "localhost"; 
$user = 
$pass =  

$dbname = 

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " . 

mysql_error());
$db_selected = mysql_select_db(' ' , $connection);
$query ="select CELLID from comments"; 


$result=mysql_query($query);


echo "<select name='CELLID'>\n";
while($row=mysql_fetch_assoc($result)){
  echo "<option value=\"$row[CELLID]\">$row[CELLID]</option>\n";
}
echo "</select>";  ?>
<input type="submit" name="Submit" value="Select" />
</form>
<hr>
<p>
<?

if (isset($_GET['submit'])){ 


$result=mysql_query("select problem, solution from comments where id='$select'");

while($row_list=mysql_fetch_assoc($result){
echo $row['problem'];


// End if statement.
}

// Close database connection.
mysql_close();
?>
</p>
</body>
</html>

It gets the cellids from the table but on submit it does not display the related data on the bottom of the page.

Please help

m_tt

I'm pretty sure that the button does not get sent as a variable. So looking for $_GET['submit'] isn't doing anything.

You should either look for another variable or add one to the form:

<input type="hidden" name="submit" value="1">

jadi

<form id="form1" name="form1" method="get">
<select name="select">
<option value="">--- Select ---</option>

<?php

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " .

mysql_error());
$db_selected = mysql_select_db('tmetrix', $connection);
$query ="select CELLID from comments";

$result=mysql_query($query);

// start the select box
while($row=mysql_fetch_assoc($result)){
echo "<option value=\"$row[CELLID]\">$row[CELLID]</option>\n";
}
?>
</select>

<input type="hidden" name="submit" value="1">
<input type="submit" name="Submit" value="Select" />
</form>

<?
// If you have selected from list box.
if(isset($select)&&$select!=""){

// Get records from database (table "name_list").
$result=mysql_query("select problem from comments where id= '$_GET['select']' ");
$row=mysql_fetch_assoc($result);
?>
Information about <strong><? echo $row['Cellid']; ?></strong> company...</p>
echo "shruti";

<?
// End if statement.
}

// Close database connection.
mysql_close();
?>
</p>
</body>
</html>

m_tt

You should have stopped after adding the hidden variable. That's what makes $_GET['submit'] work. So in your current code, you changed that to:

if(isset($select)&&$select!="")

Which I'm guessing register_globals is set to Off. So in order for this code to work you would need to use $_GET

if ( isset( $_GET['select'] ) && $_GET['select'] != "" )

jadi

NOPE....................... NOT WORKING
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>

<form id="form1" name="form1" method="get" action="<? echo $PHP_SELF; ?>">
<select name="select">
<option value="">--- Select ---</option>

<?php

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " .

mysql_error());
$db_selected = mysql_select_db('tmetrix', $connection);
$query ="select CELLID from comments";

$result=mysql_query($query);

// start the select box
while($row=mysql_fetch_assoc($result)){
echo "<option value=\"".$row['CELLID']."\">".$row['CELLID']."</option>\n";
}
?>
</select>
<input type="submit" name="Submit" value="Select" />
</form>

<?
// If you have selected from list box.
if ( isset( $GET['select'] ) && $GET['select'] != "" ) {

// Get records from database (table "name_list").
$result=mysql_query("select problem from comments where id='$select' ");
$row=mysql_fetch_assoc($result);
?>
Information about <strong><? echo $row['Cellid']; ?></strong> company...</p>
echo "shruti";

<?
// End if statement.
}

// Close database connection.
mysql_close();
?>
</p>
</body>
</html>

m_tt

Why does your code keep changing? Where you have used '$select' in the query, you need to change it back to $_GET['select']

jadi

i just did that.....................i was doing trial n error......................coz I am trying to get this since past 6 hrs.

So I am trying all possible things..........
Sorry Sir