Hello, i am having an issue and this was one of the first places i thought to try posting. I have a table in one database named minerva, the table called minerva_users that has the fields of username, user_password, and user_email....i want to write to a different table named accounts and with the fields name, password, email, and an additional field names state with a default of 0 what i want it to do, is copy the username to name, minerva_password to password, and minerva_email to email, and then set the state to 1.... here is my attempt at the query: [code]SELECT username, user_password, user_email FROM `minerva_users`; while($row = mysql_fetch_assoc($query)){ echo $row['name'].'<br />'; echo $row['`password`'].'<br />'; echo $row['email'].'<br />'; SET state='1' }[/code] when i enter this query, i get this error: [code]#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'while($row = mysql_fetch_assoc($query)){ echo $row['name'].'<br />'' at line 1 [/code] and is there a way to have it do this periodically or anything? any help would be appreciated....i am needing a seperate table for a script im running, and don't want to cause damage to the table that this info is comming from