drop down

jazappi

I got this snippet of code from the boards and it works. But what I would like to do is have the value of the drop down value to be sub_id field and the item label to be the description field. What can I do to change this up? Thanks for the help in advance.

<?php

$link = mysql_connect("localhost", "", "")
        or die("Could not connect");
    //print ("Connected successfully");
		print("<br><br>");
    mysql_close($link);

mysql_select_db(signup);

print ("<form action=\"edit_package.php\">");
print ("Select a Package to Edit<br><br>");
print("<select name=\"description\">");
print("<option selected>Choose a Package</option>");
print("<option>____________________</option>");

$sql = "SELECT description FROM sub_service ORDER BY description"; 
$result = mysql_query($sql);

if (!$result) { 
    echo("<p>Error performing query: " . mysql_error() . "</p>\n"); 
    exit(); // Take out once it's working or do something else on the page*/ 
} 
while ($row = mysql_fetch_array($result)) { 
    printf ("<option value=\"%s\">%s</option>\n", $row[0], $row[0]); 
} 
mysql_free_result ($result);
print("</select>");
print("<br><br>");
print ("<input type=\"submit\" value=\"Edit this Package\">");
print ("</form>");
?>

rachel2004

Ummm... change the values that you want changed?

jazappi

I have changed the values but it won't let me have two seperate values for some reason. I can have one or the other. Unless I am doing something wrong.

rachel2004

Can you post your last modification of the code so I can see how things look. Also, if you are getting an error message or anything, let me know.

rachel2004

BTW, these lines right here:

print("<option selected>Choose a Package</option>");
print("<option>____________________</option>");

do not contain values. They should look like:

print("<option value ="-1" selected=\"selected\">Choose a Package</option>");
print("<option value="0">____________________</option>");
print("<option value="1">Some choice here</option>"); 
print("<option value="2">Another choice</option>");
// and so on

I used numbers for the values, but you should change them to whatever you intend to submit to the PHP script for parsing.