[kevinb]

I have a problem, I've been trying to make a script that shows members (gets from the database), I can get it to pull up the data.. Then I tryed making an admin page that has the same view of the members, but has links to add more, edit and delete them. All my scripts work, I can add, and delete. but I can't update. I made it so it stores the Username, Rank, Email, and Date they joined, but when I goto my update page, it puts all the right data in a form to edit but when I submit it, it doesn't update the data base. Here's the script that my update from points to

PHP Code:

<?php

$id = $_REQUEST['id'];

$username = $_REQUEST['username'] ;

$rank = $_REQUEST['rank'] ;

$email = $_REQUEST['email'] ;

$date = $_REQUEST['date'];

include('includes/db.php');  //this connects to my database

$query="UPDATE `members` ( `id` , `username` , `rank` , `email` , `date` ) VALUES ('$id', '$username', '$rank', '$email', '$date') WHERE id='$id'";



$result=mysql_query($query)

    or die(mysql_error());



$numrows=mysql_affected_rows();

echo "Records updated: $numrows";



?>

I don't have a clue how to get it to update my database. I've tried millions of things, I've looked at tutorials of how to do it, all I haven't been able to get one to work.. Help Please

Thanks

[kevinb]

never mind, I figure it out, thanks anyway

[Romeo]

Try this...
$query="UPDATE `members` ( `id` , `username` , `rank` , `email` , `date` ) VALUES (" .$id .", '" .$username ."', " .$rank .", '" .$email ."', '" .$date ."') WHERE id=" .$id;

Aiby@hotmail.com