WHat is this PHP & MySQL mean?

[solidcodes]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's', 'the sacred palace', 'http://www.palace.net')' at line 1

this is the first time i encountered this error message, what do you think this mean?

SUPER advance thank you!

[r937]

you probably have a single quote just in front of the s

replace each single quote with two of them

e.g.

insert into ... values ( ... , 'O''Toole' , ... )

[foofoonet]

Mysql did not like something in your sql statement.

Echo it onto the page and see where is looks wrong, usually an unescaped ' .

Or post it here.

[themightystephen]

It is actually quite a common error - it just means that your query, insert or update has incorrect syntax somewhere along the line.

[foofoonet]

Off Topic:

Now that is MAD.... 3 answers in the same minute!

[solidcodes]

<?php
require_once ("opendb.php");
require_once ("error_messages.php");
$COerr_msgs = new error_messages; //instantiate object

//paging of search.php
$title_new = $_POST['topic'];

//get all record with related topics
$query = "SELECT * FROM topics";
$result = mysql_query($query) or die('Error, query failed');

//get related topic and display it into screen
if(preg_match("/^[ a-zA-Z0-9]+$/", $title_new)) {
if($title_new != '' && $title_new != ' ' && $title_new != ' '){
echo '<table border="1" width="700px">';
while(list($id, $title, $description, $url) = mysql_fetch_array($result))
{
if(preg_match("/\b$title_new\b/i", $title)) {
//fill array with related topic IDs.
$topic_rel[] = $id;
}
}
echo '</table>';
$total_rec = count($topic_rel);
echo "<br>Total record: <b>$total_rec <br>";
echo "Pls. wait, page is loading...</b>";

//Empty temporary table topics_tmp then fill again with contents from topic_rel[]
$query = "TRUNCATE TABLE `topics_tmp`";
mysql_query($query) or die(mysql_error());

$total_tmp = $total_rec-1;
for($x=0; $x<=$total_tmp; $x++){
//select records from table TOPICS first
$query = "SELECT * FROM topics WHERE id='$topic_rel[$x]'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$title_tmp = $row['title'];
$descrip_tmp = $row['description'];
$url_tmp = $row['url'];

//then insert selected data into TOPICS_TMP temporary table
$query = "INSERT INTO topics_tmp (title, description, url) VALUES ('$title_tmp', '$descrip_tmp', '$url_tmp')";
mysql_query($query) or die(mysql_error());
}
}

?>
<meta http-equiv="refresh" content="0;url=http://www.askjames01.com/search_box/ed_paging2.php">
<?php
} else {
echo "<b>You entered invalid character(s).<b><br>";
echo "<b>Valid characters are: space, a-z, A-Z and 0-9</b><br>";
}
?>

[solidcodes]

ok what do you think those codes?
where i was made mistakes?

thanks

[siteguru]

$title_tmp = mysql_real_escape_string ($row['title']);
$descrip_tmp = mysql_real_escape_string ($row['description']);
$url_tmp = mysql_real_escape_string ($row['url']); 

[solidcodes]

Thanks man it works