UPDATE content SET..... Problem, a blank page displayed.

[runar56]

Hi, I am trying to run this query. What it does is modify the row of a database, replacing the information with the submitted info via form. Problem is that the query doesn't execute, all I get is a blank page, no error messages or nothing. Here is teh code:

<?php  

error_reporting(E_ALL);
include "common_db.php";  

$host="localhost"; 
$user="****"; 
$password="****"; 
$db="****"; 

$conn=mysql_connect($host,$user,$password); 
mysql_select_db($conn,$db);  

if($_POST['submit'])   

{  

$pageid = $_POST["pageid"];  

$pagename = $_POST["pagename"];  

$pagecontent = $_POST["pagecontent"];  

$pageurl = $_POST["pageurl"];  

$pagemenu = $_POST["displaymenu"];  

if (!mysql_query( sprintf("UPDATE content SET page_id = '$pageid', page_name = '$pagename', page_content = '$pagecontent', page_url = '$pageurl', display_menu = '$pagemenu'  WHERE page_id = '$pageid'"))) 
{ 
echo mysql_error();  

exit;
} 

echo "Query finished!";  

} 

?>  

Thanks for your help.😃

[andrewm]

Instead of running the query, echo it out. Then copy and paste the echo'ed query into your mysql command prompt and see what is displayed.

Edit: Also, try removing that the sprintf(""). That's probably it.

[Roger_Ramjet]

SEE MY NEW POST

[Roger_Ramjet]

From the manual

Some queries (LOAD DATA INFILE ..., INSERT INTO ... SELECT ..., UPDATE) return additional information. The result is returned by mysql_info(). See the description for mysql_info() for the format of the string that it returns. mysql_info() returns a NULL pointer if there is no additional information.

I wish they would include this sort of information in the individual documentation for each query type. If anyone has read and acted upon my previous post, I apologise.