Update Statement

[bullbreed]

HOw does the update statement work?

 

I have some data that is echoed into form fields on the page from the database. I then want the user to be able to edit the data and submit it to the database.

I can't get my head around the UPDATE statement.

 

I tried this

//Enter into Database

                $queryreg = mysql_query("UPDATE webpages SET

                page_name = $pagename,

                page_order = $pageorder,

                page_parent = $pageparent,

                page_title = $pagetitle,

                page_description = $pagedescription,

                page_keywords = $pagekeywords,

                page_content = $pagecontent");

                echo("<font size=\"2\" color=\"#00cc00\">Your page has been updated! </font>");

        }else{

                echo ("<font size=\"2\" color=\"#ff0000\">Please complete <b>ALL</b> fields</font>");

                }

        }     

 

It didnt work. Any ideas everyone. 

 

Thanks

 

 

[jl5501]

I would imagine you would want some kind of where clause in there unless you want it to update every row in the database, and you need your values in single quotes, where they are string values.

[bullbreed]

Thank you very much