mysql question

[Cyto]

Hi, wye does $link return a empty row in mysql?

$link = $m[1];
$ssql = "INSERT INTO site (id, link) VALUES ('', '$link');";			
mysql_query($ssql);

 

Thx,

[QuickOldCar]

You should use auto increment for the id values on insert

http://dev.mysql.com/doc/refman/5.6/en/example-auto-increment.html

 

If were to update into a certain id, then you should specify the id, but not leave it blank.

[Psycho]

How are we supposed to know? What is the value of $link? Did you verify it has the value you expect? Does the variable contain a value that is consistent with the database field (i.e. are you trying to store text into a numeric field)? Although, that last problem would likely create an error rather than inserting an empty field.

 

Also, there is no need to include the 'id' in the insert query if it is an auto-increment field. Try the following

 

$link = $m[1];
$ssql = "INSERT INTO `site` (`link`) VALUES ('$link');";
$result = mysql_query($ssql);

//Debugging code
echo "The value of the link: '{$link}'<br>\n";
echo "Insert Query: {$ssql}<br>\n";
if(!$result) { echo "Query failed: " . mysql_error();