insert 2 records why?

[coder9]

hello

 

what is wrong with this codes when i call the function store_cell_number()

it insert a record not 1 but 2. why is this?

 

here is the codes,

<?php
function store_cell_number($link){
#$query = "INSERT INTO jtablegrid (user_box" . $link . ") VALUES ('" . $link . "')"; 
#$query = "INSERT INTO jtablegrid (user_box" . $link . ") VALUES ('.$link.')"; 

//get status of jtablegrid get all column value.


//concatenate the name.
$tmp_name = 'user_box' . $link;

if($tmp_name != 'user_box') {
	$query = "INSERT INTO jtablegrid ($tmp_name) VALUES ('.$link.')"; 
	mysql_query($query) or die(mysql_error());
}
}
?> 

 

i call this function from another .php page.

 

thank you.

[scarhand]

try this

 

<?php

$query = "INSERT INTO jtablegrid ($tmp_name) VALUES ('$link')";

?>

 

you can use variables inside double quotes, thats the difference between single and double quotes.