[SOLVED] mysql issue, GRRRRRR....

[ballhogjoni]

What is wrong with this code?

 

<?php
$index_page_title = $_POST['index_page_title'];

if (!empty($index_page_title)) {
include('config.php');

if (mysql_query('SELECT * FROM title WHERE ID=1')) {
	mysql_query('UPDATE title SET title = $index_page_title');
	echo 'you updated you title to $index_page_title';
} else { 
	mysql_query("INSERT INTO title (title) VALUES ('$index_page_title')");
}
} else {
?>

[morphboy23]

I think this line:

mysql_query('UPDATE title SET title = $index_page_title')

 

should be this:

mysql_query("UPDATE title SET title = '$index_page_title'")

[skali]

In a string with single quote you cannot use variables inline:

 

$str = '$abc this is abc'; //won't work

$str = $abc.' this is abc'; // will work

 

You will need to use string concatination to make this work, and when writing to database varchar, char, text types in db should be quoted with single quotes as described above.