[SOLVED] eehhh ... What?!

[herghost]

Hi all,

 

I have a problem I cannot work out, it doesnt make sense!

 

here is the code I am trying to run:

 

<?php
$table = "last_month";
   	   $sql = "DELETE FROM `".$table."`";
       mysql_query($sql);

$month = "INSERT INTO last_month SELECT user_id,username,total,bank,user_total FROM users_details";
if (mysql_query($month))
{
      echo "Last Month Saved<br />\n";
  }
  else {
  die(mysql_error());
  }
?>

 

And here are the 2 tables in question:

 

last_month
Field 	Type 	Null 	Default 	Comments
user_id 	int(11) 	No  	  	 
username 	varchar(255) 	No  	  	 
total 	int(11) 	No  	  	 
bank 	int(11) 	No  	  	 
users_total 	int(11) 	No  	  	 
No index defined!

 

users_stocks:

 

user_id 	username 	total 	bank 	users_total
1 	admin 	200 	0 	200
2 	test 	200 	0 	200

 

and my error message:

 

Unknown column 'total' in 'field list'

 

I can quite clearly see 'total' in both tables?!

 

Any ideas?

[herghost]

Well I suppose it helps if you select the correct table

[Mchl]

Is it users_stocks or users_details?