[SOLVED] PHP/MYSQL...WHERE Syntax...

[alexander007]

Im having an error with this and cant find what its the correct syntax...

 

<?php 
$nombre = $_SESSION['nombre'];
$visited = $_SESSION['visited'];
echo $nombre, $visited;
include"config.php";
$tbl_name="visitantes"; 

mysql_query("INSERT INTO ".$tbl_name." (visited) VALUES('','".$visited."') WHERE nombre = $nombre ") or die(mysql_error());
?>

[shocker-z]

you putting 2 values but only specified 1 column

 

 

mysql_query("INSERT INTO ".$tbl_name." (visited) VALUES('".$visited."') WHERE nombre = $nombre ") or die(mysql_error());

 

try that

 

I removed '',

 

Liam

[teng84]

i dont know if insert needs a where clause ?

 

i hanvent seen anything like that where is not for insert !

[AndyB]

INSERT adds a record, therefore needs no WHERE; UPDATE updates a record and therefore needs a WHERE.

[shocker-z]

ohh yeah i missed the obvious but saw the less obvious can tell it's sunday

[alexander007]

Thanks for your help...

But Im still getting the error

[alexander007]

So to do that I need to use UPDATE?

[shocker-z]

Try this

 

mysql_query("UPDATE ".$tbl_name." SET visited = '".$visited."' WHERE nombre = '$nombre'") or die(mysql_error());

 

Is that better?

[AndyB]

So to do that I need to use UPDATE?

 

Use UPDATE to change an existing record

 

Use INSERT to add a new record.

 

Which you want depends on what you're trying to do.

[alexander007]

That do te trick!!!

 

Thanks to all!!!