Update MySQL Database Table

[graemeduncan]

I have a php script that I wish to use to update a table. The script appears to run correctly but does not update the table,any ideas?

<?php
/ Connecting, selecting database /
$link = mysql_connect("localhost", "root", "password")
or die("Could not connect : " . mysql_error());
print "Connected successfully";
mysql_select_db("test") or die("Could not select database");
$sql= "INSERT INTO addressbook (Email,First_Name) values ('[e-mail]','Lester');";
/ Closing connection /
mysql_close($link);
?>

[Der_Fisch]

Hi,

the problem is, that you didn't execute your querry...

try this

<?php 
/* Connecting, selecting database */ 
$link = mysql_connect("localhost", "root", "password") 
or die("Could not connect : " . mysql_error()); 
print "Connected successfully"; 
mysql_select_db("test") or die("Could not select database"); 
$sql= "INSERT INTO addressbook (Email,First_Name) values ('[e-mail]','Lester');";

mysql_query($sql)
or die("Problem with query: " . mysql_error());

/* Closing connection */ 
mysql_close($link); 
?> 

 

if you try to select something you must do this:

$result = mysql_query($sql) or die("Invalid query: " . mysql_error());
while( $row = mysql_fetch_row( $result ) )
    echo $row;

[graemeduncan]

Thanks that worked a treat.🙂