MySQL

MySQL syntax error 1064

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

Last »

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

MySQL syntax error 1064

Mar 27th, 2008

why i am i getting this synyax error when trying to display data from the database

the code for saving the data is

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
// save content to db
if(isset($_POST["inpContent"])) 
	{
 
	$sContent=stripslashes($_POST['inpContent']); // remove slashes (/)	
	$sContent=ereg_replace("'","''",$sContent); // fix SQL
 
	$sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id";
	$query = mysql_query($sql);
	}
// save content to db
if(isset($_POST["inpContent"])) 
	{
	
	$sContent=stripslashes($_POST['inpContent']); // remove slashes (/)	
	$sContent=ereg_replace("'","''",$sContent); // fix SQL
		
	$sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id";
	$query = mysql_query($sql);
	}

and the code to get the data from the data base is

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
$SQL = "SELECT cms_core FROM '$sContent' WHERE id=1";
 $res = mysql_query( $SQL, $db )
 OR die( "<br><br><b>MySQL
 Error:</b> " . mysql_errno() . " // " .
 mysql_error() . "<br><br>" );
 
 if( $res !== "" ) {
 echo "Nothing in recordset.";
 } ELSE {
 echo "Something in recordset.";
 }
$SQL = "SELECT cms_core FROM '$sContent' WHERE id=1";
 $res = mysql_query( $SQL, $db )
 or die( "<br><br><b>MySQL
 Error:</b> " . mysql_errno() . " // " .
 mysql_error() . "<br><br>" );

 if( $res !== "" ) {
 echo "Nothing in recordset.";
 } else {
 echo "Something in recordset.";
 }

thanks if anyone can help

•

Join Date: Oct 2007

Posts: 60

Reputation: RoryGren is an unknown quantity at this point

Solved Threads: 8

RoryGren

Offline

Junior Poster in Training

Re: MySQL syntax error 1064

Mar 27th, 2008

Hi Kevin

What else does the error message say?

Normally something along the lines of "near..."

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: MySQL syntax error 1064

Mar 27th, 2008

here is the full error message

MySQL Error: 1064 // You have an error in your SQL syntax near '' at line 1

•

Join Date: Oct 2007

Posts: 60

Reputation: RoryGren is an unknown quantity at this point

Solved Threads: 8

RoryGren

Offline

Junior Poster in Training

Re: MySQL syntax error 1064

Mar 27th, 2008

OK. A little hazy still ... We don't know which is line 1.

Print out your queries with echo $SQL and see if that helps.

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: MySQL syntax error 1064

Mar 27th, 2008

Syntax error while updating the record or while fetching ?

•

$SQL = "SELECT cms_core FROM '$sContent' WHERE id=1";

•

$sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id";

cms_core ? is it a table or a column name ?

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Oct 2007

Posts: 60

Reputation: RoryGren is an unknown quantity at this point

Solved Threads: 8

RoryGren

Offline

Junior Poster in Training

Re: MySQL syntax error 1064

Mar 27th, 2008

Maybe my reply was a little hazy too! Sorry! ;-)

By printing out the queries, you will be able to see what the mySQL server is being sent and hopefully that will steer you in the right direction!

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: MySQL syntax error 1064

Mar 27th, 2008

i am no getting a different problem with error codes. cmsservdb is the database cms_core is the table name and editorial is the coloum name. my database sewtup looks like this

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<?php
$db = mysql_connect("xxxxxxxx","xxxxx","xxxx");
mysql_select_db("cmsservdb", $db);
 
// CREATE TABLE IN my_db database
mysql_select_db("cmsserdb");
$sql = "CREATE TABLE cme_core 
(
editroial longblob
)";
mysql_query($sql);
 
?>
<?php
$db = mysql_connect("xxxxxxxx","xxxxx","xxxx");
mysql_select_db("cmsservdb", $db);

// Create table in my_db database
mysql_select_db("cmsserdb");
$sql = "CREATE TABLE cme_core 
(
editroial longblob
)";
mysql_query($sql);

?>

and the error message i am getting now on the page that is recalling the data is

MySQL Error: 1146 // Table 'cmsservdb.editroial' doesn't exist

the code used to access this data is

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 $SQL = "SELECT * FROM editorial WHERE id= 1 ";
 $res = mysql_query( $SQL, $db )
 OR die( "<br><br><b>MySQL
 Error:</b> " . mysql_errno() . " // " .
 mysql_error() . "<br><br>" );
 
 if( $res !== "" ) {
 echo "Nothing in recordset.";
 } ELSE {
 echo "Something in recordset.";
 }
 $SQL = "SELECT * FROM editorial WHERE id= 1 ";
 $res = mysql_query( $SQL, $db )
 or die( "<br><br><b>MySQL
 Error:</b> " . mysql_errno() . " // " .
 mysql_error() . "<br><br>" );

 if( $res !== "" ) {
 echo "Nothing in recordset.";
 } else {
 echo "Something in recordset.";
 }

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: MySQL syntax error 1064

Mar 27th, 2008

i have just edited the code used to recall the data so it looks like this and the error has gone it now tells me there is nothing in the record set.

the code looks like this

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 $SQL = "SELECT editorial FROM cms_core WHERE id= 1 ";
 $res = mysql_query( $SQL, $db )
 OR die( "<br><br><b>MySQL
 Error:</b> " . mysql_errno() . " // " .
 mysql_error() . "<br><br>" );
 
 if( $res !== "" ) {
 echo "Nothing in recordset.";
 } ELSE {
 echo "Something in recordset.";
 }
 $SQL = "SELECT editorial FROM cms_core WHERE id= 1 ";
 $res = mysql_query( $SQL, $db )
 or die( "<br><br><b>MySQL
 Error:</b> " . mysql_errno() . " // " .
 mysql_error() . "<br><br>" );

 if( $res !== "" ) {
 echo "Nothing in recordset.";
 } else {
 echo "Something in recordset.";
 }

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: MySQL syntax error 1064

Mar 27th, 2008

$res will have the resource_id of the query you just executed. You can check if there are any records or not this way.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$res = mysql_query($SQL,$db);
if(mysql_num_rows($res) > 0){
echo "There is something!";
} else {
echo "Nothing !";
}
$res = mysql_query($SQL,$db);
if(mysql_num_rows($res) > 0){
echo "There is something!";
} else {
echo "Nothing !";
}

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: MySQL syntax error 1064

#10

Mar 27th, 2008

i echoed the $sql on both the pages and on the page where the data is being recall it gave the

Nothing in recordset.CREATE TABLE cms_core ( editroial longblob id int )

and when i echoed the $sql on the page where it is saving it gave me

UPDATE cms_core SET editorial='

then all the text that is being saved to the database with

WHERE id=$id

after the text.

it looks like the data is being saved to the database but why can i not recall the data on the other page.