MySQL Query Problem Please i need your help...

[gunesahmet]

Senseis,

 

I give nothing error. But mysql query dont put in to the table. I am using variables...

 

$ara = '/Public Game - /'; 
$degistir = '';
$seo_var=preg_replace( $ara, $degistir, $yeni_title );
$ara2 = '/\s+/'; 
$degistir2 = '';
$seo_var2=preg_replace( $ara2, $degistir2, $seo_var );
$seo_link = tr_converter($seo_var);
$makalequery = "INSERT INTO `jos_content` (`id`, `title`) VALUES (NULL, '$seo_link')";
$makaleekle = mysql_query($makalequery) or die("Problem with the query: $q<br>" . mysql_error());

 

Thank you for help...

 

Note: I'm dealing with this problem for three days..

Best Regards...

[karimali831]

You can try:

$makalequery = "INSERT INTO `jos_content` (`title`) VALUES ('$seo_link')";

If col `id` is the auto_increment there is no need to insert it.

[gunesahmet]

when i run from console dont give any error and put in to table. But i dont run with php...

[mikosiko]

- check if you are really connected to the DB.

- check the value of $seo_link before the query

- what is $q... the one that you are using in your die() call?

[DWilliams]

In any sane database setup you

 

a. shouldn't be allowed to have a NULL id (assuming ID is your PK, that's the name most people use for every table's PK)

 

and

 

b. shouldn't need to specify an ID with auto increment on

 

So check your database design and see if it even allows a null value in the id field. If not, give it a value. Actually, give it a value anyway

[kickstart]

Hi

 

I would suggest you echo out $makalequery to check it is what you are expecting. There is nothing apparent with the SQL or the PHP.

 

If Id is an auto increment then I would do the same as you and specify NULL for it. Works fine in MySql and triggers the auto increment, but in some flavours of SQL it is essential to do it this way.

 

All the best

 

Keith