[need help] change my code so end user can change db info

sniperpaladin

I've wrote code so it pulls the data out of the mySQL DB, but how would I write code so they can edit what they see? Also what extra code would I need for a drop down menu? Thanks for helping a noob

Here's the code I wrote to pull the data

<?php
// create connection
$conn = mysql_connect("mysql.lanset.com","barboyz","xxxxxxx")
or die(mysql_error());

// select database
$db = mysql_select_db("atf_xmb", $conn) or die(mysql_error());

$query="SELECT CallSign , Status , Division
FROM tblroster
WHERE Status = 'Applicant'
ORDER BY `Division";

$results=mysql_query($query)

or die(mysql_error());

// start results formatting
echo "<TABLE BORDER=1>
<TR>
<TH>CallSign</TH>
<TH>Status</TH>
<TH>Division</TH>
</TR>";

// format results by row
while ($row = mysql_fetch_array($results)) {
$CallSign = $row["CallSign"];
$Status = $row["Status"];
$Division = $row["Division"];
echo "<TR>
<TD>$CallSign</TD>
<TD>$Status</TD>
<TD>$Division</TD>
</TR>";
}

?>

MrPixel

You will need to add a form with fields corresponding to the data you want to modify. Then, when the user submits it, you validate it (make sure it's safe and well formatted), and update the database with an UPDATE statement.

For a drop down menu (I'm assuming you mean a <select> box), you'll need to have a result set, iterate over it (while is the easiest), and create an <option> with the appropriate values on each iteration.