Im relatively new to php and am working on a project for a client. I am using the FCKeditor(www.fckeditor.net) version 2.1. The webserver the PHP is running on is(to my knowledge) windows 2000 server, and the PHP version on the server is the latest stable version(which I dont remember the actual number). The editor is posting the data to my script. My post handler script is as follows:
$sValue = stripslashes( $_POST['PSP_editor'] ) ; $posted_id = $_POST['page_id_value'] ; mysql_connect("database URL", "Username", "Password") or die ('I can?t connect to the database.') ; mysql_select_db("clientd_psp") ; mysql_query("UPDATE content_tbl SET page_content=$sValue WHERE page_id=$posted_id") ;
Obviously I have changed the URL, username and password. This has me stumped, if I comment out the mysql commands and have it echo the 2 variables and they come back with the correct data, but it refuses to successfully update the fields. I do have read and write access to the database as I entered the content into the DB. Whats up?
Thanks is advance,