MYSQL Update

[cdoggg94]

Is there something seriously wrong with this code that im missing ?

 

I have written it at least 10-12 different ways and it will NOT update my db..

 

<?php 
mysql_connect('localhost','root','');
mysql_select_db('myDB');

$dates = $_POST['date']; 
$store = $_POST['store'];  // these actually display the correct information

mysql_query = ("UPDATE Agency Stores - Table 1 SET date = '".$date."' WHERE F3 = '".$store."' ");

?>

 

 

there are several other columns in the table.  I have tried to put them in as the value they already have and it still didnt work...

 

any ideas ?

[Winstons]

"Agency Stores - Table 1" - is there name of your table ?

Also not initialized variables $dates and $store will cause Notice with error_reporting(E_ALL)

You must initialize their

mysql_connect('localhost','root','');
mysql_select_db('myDB');

$dates = isset($_POST['date']) ? $_POST['date'] : NULL; 
$store = isset($_POST['store']) ? $_POST['sotore'] : NULL;  // these actually display the correct information

mysql_query("UPDATE `Agency Stores - Table 1` SET `date` = '".$date."' WHERE `F3` = '".$store."' ") or die(mysql_error());

[PFMaBiSmAd]

Your code isn't actually calling the mysql_query function. The light blue mysql_query is a link to the php.net manual page that shows several examples of how to form a query statement and call the mysql_query function.

[cdoggg94]

Yes that was the name of the table...it was pre-made from an excel sheet and i haven't changed it...

 

Thanks

[Winstons]

Sorry. I've corrected my code.

[PFMaBiSmAd]

The original code contains that problem as well.