Jump to content

Pyro-Tech

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Pyro-Tech's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. ok...i thought the echo part is where it was writing the info it got from the first section how do i copy the info into a new table then with different field names? and in all honesty i don't know any MySQL so all the questions asking if i knew something...answer is prolly no  :-[
  2. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.