Hi there, I am posting this message again sice my previous post was vague.
I have recently configured a server which runs redhat 7.2. I followed the installation procedures to install mysql database and PHP on the same server and they seem to run properly. My aim is to load data into a mysql database and view the same data using web page. Before I implement my own project i stolen the following code from the web and tried to customize it on my server. (section of the code customized code is the following) ------------------------------------------------------ //////////////////////////////// if (($REQUEST_METHOD=='POST')) { //////////////////////////////// // This loop removed "dangerous" characters from the posted data // and puts backslashes in front of characters that might cause // problems in the database. //////////////////////////////// for(reset($HTTP_POST_VARS); $key=key($HTTP_POST_VARS); next($HTTP_POST_VARS)) { $this = addslashes($HTTP_POST_VARS[$key]); $this = strtr($this, ">", " "); $this = strtr($this, "<", " "); $this = strtr($this, "|", " "); $$key = $this; } //////////////////////////////// // This will catch if someone is trying to submit a blank // or incomplete form. //////////////////////////////// if ($name && $email && $message ) { //////////////////////////////// // This is the meat of the query that updates the guests table //////////////////////////////// $query = "INSERT INTO guests "; $query .= "(guest_id, guest_name, "; $query .= "guest_email, guest_time, guest_message) "; $query .= "values(0000,'$name','$email',NULL,'$message')"; mysql_pconnect("","bereket","iloveumom") or die("Unable to connect to SQL server"); mysql_select_db("employee") or die("Unable to select database"); mysql_query($query) or die("Insert Failed!"); } else { //////////////////////////////// // If they didn't include all the required fields set a variable // and keep going. //////////////////////////////// $notall = 1; } } ----------------------------------------------------- Result: Everything seems fine. Except when you fill the form and click submmit, it doesn't update the database. But if i connect to mysql maually and add some records, you can automatically see the new data posted on the web, which is what I wanted. problem: It is not updating the database from the web form. YOUR HELP IS APPRICIATED, Cheers, Aron __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]