Please verify the code..

[glkshankar]

Hi All,

 

I think i have asked a stupid question in my previous post .. I am pasting my code below ... using this code i am able to pass the ID value to the next query but i want the Name aswell to be used .. How can i do that ?

 

$ID send the ID value and i am getting it with no probs. but I want to take the select $CLSNAME also ..

 

<?php

//Cluster Querying starts here

$clsquery1 = "SELECT ID, NAME FROM VPX_ENTITY WHERE TYPE_ID= '3' ";

$results = mssql_query($clsquery1);

$number = mssql_num_rows($results);

$i = 0;

?>

 

<table border=1><tr><td>

<select name='Cluster' id='1'>

<option>Select</option>

 

<?php

while ($i < $number) {

 

$CLSNAME = mssql_result($results, $i, "NAME");

 

$ID = mssql_result($results, $i, "ID");

 

echo $_GET["<option value=$ID>" .$CLSNAME. "</option>"];

 

$i++ ;

 

}

 

?>

<input type=submit>

</select>

</td></tr></table>