selecting row to edit in mysql

[scbmx]

i made an update script for my site which will update a row in a table in mysql...it works when i put the

UPDATE app_riders WHERE id='0001' or any other id number.

but im trying to figure out how to pass the variables from a page listing the availible rows to edit so i could have something like

UPDATE app_riders WHERE id='.$selectedrow.'

could someone tell me how set the variables for the update form from a previous page?

thanks

[dantone]

Do you want to pass one ID or multiple ID's? There are many ways to pass variables to another page. You can use a form, or imbed it in the target of a hyperlink.

[coditoergosum]

I'm not sure if I understand the question correctly, but maybe this will help.

Use a select statement on the first page to get the row id(s), and then append to the var. Something like this:

$usr = "username"; 
$pwd = "password"; 
$db = "database"; 
$host = "localhost"; 

$cid = mysql_connect($host,$usr,$pwd); 
if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    } 

$SQL = " SELECT * FROM tablename "; 
$retid = mysql_db_query($db, $SQL, $cid); 

if (!$retid) { echo( mysql_error()); } 
else { 

while ($row = mysql_fetch_array($retid)) { 
$id = $row["id"]; 

echo("<a href=\"updatepage.php?selectedrow=$id\">");
}
}

That way it will append the row id onto the link url and pass it to the update script.

Hope this helps.

[scbmx]

thanks alot codito that helped alot