[SOLVED] inserting data into MySQL

[black_box]

I am having a problem inserting data into MySQL what can be the problem ??

 

$SQL_insert = "INSERT into borrow VALUES ('','$bok_id','$bok_nam','$stu_id','$stu_nam','$DOI','$due_dat','','')";
mysql_query($SQL_insert)or die("Couldnot insert");

 

Database structure:

 

The first column is auto increament and last two columns can be null.

 

Date is also in : m/d/y format so MySQL should accept tht as it is.

 

So what can be the problem please help me i m stuck for 4 hrs

[Silverado_NL]

try removing the quotes around the id's , if im not mistaken mysql will treat '1' as a string and not an integer.

so something like this would be my guess.

<?php
$SQL_insert = "INSERT into borrow VALUES ('',$bok_id,'$bok_nam',$stu_id,'$stu_nam','$DOI','$due_dat','','')";
?>

 

hope this helps

[black_box]

Nope Same thing i tried this b4 bt no change i dnt knw wht can be the problem with it 

[revraz]

Remove the empty ' ' for the ID and the last two empy ' '.  If they can be null, then don't even send it.  May want to specify the columns too.

[revraz]

See here

http://www.phpfreaks.com/forums/index.php/topic,169634.msg748788.html#msg748788

[black_box]

even though i remove the null ' ' ..its same and cnnot insert

[Wolphie]

Try

 

$SQL_insert = mysql_query(sprintf("INSERT INTO `borrow` ( `table_name`, `table_name`, `table_name`, `table_name`, `table_name`, `table_name`, `table_name`, `table_name`, `table_name` ) 
VALUES ( '', '%d', '%s', '%d', '%s', '%s', '', '', '')", $bok_id, $bok_name, $stu_id, $stu_nam, $DOI, $due_date)) 
or die('Error: ' . mysql_error());

 

The table_name's are for you to enter the table names for each table where you want to insert the data.

 

e.g.

 

`bok_name` for the variable $bok_name // `bok_name` being the table name, and $bok_name being the variable.

 

I'm assuming that $bok_id and $stu_id are integer's therefore i've used %d for them rather than %s for strings.

 

Alternitavely

 

$SQL_insert = mysql_query(sprintf("INSERT INTO `borrow` ( `table_name`, `table_name`, `table_name`, `table_name`, `table_name` ) 
VALUES ( '%d', '%s', '%d', '%s', '%s' )", $bok_id, $bok_name, $stu_id, $stu_nam, $DOI, $due_date)) 
or die('Error: ' . mysql_error());

 

I have removed the all of the ('')'s which contain no data

[black_box]

Yap thts the thing i forget to put those column names .now its working perfectly ..thanx all of u guys ...

 

I love this forum too much cuz u make me feel happy thanx again

[Wolphie]

Most welcome.