selecting an array of titles from a table so that i can change the status OF EACH >>
Code: Select all
<?
$grab_usertitles = "SELECT * FROM titles WHERE recID = '$id'";
$result = @mysql_query($grab_usertitles);
sql_query("$result", "1", "$errorsї03]");
while ($row = mysql_fetch_array($result))
{
$tid = $rowї"id"];
$title = $rowї"title"];
$status = $rowї"status"];
echo "<tr><td width="150">$tid - $title </td><td width="400">
<select name="status"><option value="$status">$status</option>
<option value="Received">Received</option>
<option value="Under Review">Under Review</option>
<option value="Approved">Approved</option>
<option value="Declined">Declined</option>
</select></td></tr>";
/*
echo "<tr><td width="150">$title </td><td width="400">
<input type="text" name="status" value="$status"></td></tr>";
*/
}
?>so the function that the form calls is (in another page):
Code: Select all
$grab_usertitles = "SELECT * FROM titles WHERE recID = '$id'";
$result = @mysql_query($grab_usertitles);
sql_query("$result", "1", "$errorsї03]");
$tid = $rowї"id"];
$input1 = "UPDATE titles SET
status = '$status'
WHERE (recID = '$id')";
$result1 = @mysql_query($input1);
sql_query("$result1", "1", "$errorsї03]");
echo ("<font color="blue"><b>User Updated Successfully.</b></font>");
include ("user_display.inc");can someone show my what query will get what i need done?
i thank you,
glenn
Code: Select all