get value in a drop down menu

bbmak

Hi:
I try to build a drop down menu in a record update page
the page get the id record to update the page
example update.php?id=2

In the drop down menu, are there anyway I can get the value of the record that already insert? Everytime when i update the record, i have to set this level again.
I use this drop down menu
<br>Level: <select name="level">
<option value="0">admin</option>
<option value="1">mod</option>
</select>

here is my script

<?
include ('connect.php');

if ($action == 'edit') {

?>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<form action="?action=result" method="post">
<?
$mod_id = $_GET['mod_id'];
$query=" SELECT * FROM moderator WHERE mod_id = '$mod_id'";
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{ 
$mod_id = $row['mod_id'];
$mod_password = $row['mod_password'];
$level = $row['level'];
$email = $row['email'];

?>
<br>Mod ID: <input type="text" name="mod_id" value="<? echo $mod_id; ?>">
<br>Mod Password: <input type="text" name="mod_password" value="">
<br>Email: <input type="text" name="email" value="<? echo $email; ?>"><br>
<br>Level: <select name="level">
<option value="0">admin</option>
<option value="1">mod</option>
</select>
<input type="Submit" value="Update">
</form>
<?
}
}
?>

devinemke

<?php
include('connect.php');

if ($action == 'edit')
{
	$result = mysql_query("SELECT * FROM moderator WHERE mod_id = '" . $_GET['mod_id'] . "'") or exit(mysql_error());
	if (!mysql_num_rows($result)) {exit('no records matching that mod_id');}
	$row = mysql_fetch_assoc($result);
	$levels = array('admin', 'mod');

echo '
<form action="' . $SERVER['PHP_SELF'] . '?action=result" method="post">
Mod ID: <input type="text" name="mod_id" value="' . $row['mod_id'] . '"><br>
Mod Password: <input type="text" name="mod_password" value="' . $row['mod_password'] . '"><br>
Email: <input type="text" name="email" value="' . $row['email'] . '"><br>
Level: <select name="level">
';
foreach ($levels as $key => $value)
{
	echo '<option value="' . $key . '"';
	if ($key == $row['level']) {echo ' selected';}
	echo '>' . $value . '</option>';
}
echo '
</select><br>
<input type="Submit" value="Update">
</form>
';
}
?>

bbmak

thank you it is working
are there any turtorial for this part?
i don't get it how the $key will get my level's number?
because i thought

foreach ($levels as $key => $value)
levels is the word admin and mod? how can the admin and mod turn to my 0 & 1 values??? I dont get it on this part

i thought u have to in the array to do that array('0' => 'admin', '1' => 'mod')

echo '<option value="' . $key . '"'; 
        if ($key == $row['level']) {echo ' selected';} 
        echo '>' . $value . '</option>';

devinemke

bbmak wrote:
how can the admin and mod turn to my 0 & 1 values??? I dont get it on this part
i thought u have to in the array to do that array('0' => 'admin', '1' => 'mod')

if you don't specify the keys in your array, the will be auto-numbered starting at "0".

bbmak

oh yes i remember now, when you do a array, it will start from 0

one more question, what is the effect if i use

$row = mysql_fetch_array($result); here because i see you are using mysql_fetch_assoc()

i have read the manual in php.net, but i still don't know what is the different between these 2 functions

    if (!mysql_num_rows($result)) {exit('no records matching that mod_id');} 
    $row = mysql_fetch_assoc($result); 
    $levels = array('admin', 'mod');

Weedpacket

[man]mysql_fetch_assoc[/man] returns results with associative keys named after the database table's fields.
[man]mysql_fetch_row[/man] returns results with numerically-indexed keys.
[man]mysql_fetch_array[/man] returns results indexed both ways.

bbmak

it seems like you are just copying from php.net
Can you do an example on those functions because i kind of want to see the function in action.
I always don't know what to choose when come with it, and i always use mysql_fetch_array

Weedpacket

No, I was doing it from memory. Examples are supplied on those pages.