I basically want to be able to pull down a row and have it all be entered into text boxes and be able to update the row when i want as this is what is diesplyed on the front page. can you give me a script to do this i already have a db_connection.php so i jsut need to rest of hte script. if i coud just have one row i could sort it out from there

cheers

any help would be really apreciated! i could use it! all i need to know is how to populate text boxes etc in a form with information from a database so i can edit it and then up date the databse!

thats a whole lot of coding.... maybe this will get you started;

PHP Code:

<?php
$result = mysql_query("SELECT * FROM database_name WHERE rowid='id_you_want_to_edit'", $db);
if(!mysql_num_rows($result)) { $die(); }
$retval = mysql_fetch_array($result);

echo "<table>\n";
foreach($retval as $key=>$value) {
   echo "<tr><td>$key</td><td><input type=\"text\" name=\"$key\" value=\"$value\"></td></tr>\n";
}
echo "</table>\n";
?>

That will put all your info into a row of text boxes.... really need more info to help more.

well basically...i have a reiew script that generates a new row with loads of information about a game that i then put in to a template that processes the review! then inow need a page that will take all the information and put it into seperate boxes so that i can edit it and update the database. here is a copy of the form

http://www.scottsgameroom.co.uk/form.html