phpMyAdmin

[Rob]

Quick question. In my database I have 2 tables. 1)initial_users and
2)registered_us ers. This is what i want to accomplish. When someone
signs up with my site the info goes into initial_users which is
working. Once I have verified there information I want to drop there
row of information into registered_user s, can I do this with
phpMyAdmin if so I cant figure it out. And as well is there any other
way that people would suggest how to accomplish this.

[Geoff Berrow]

Re: phpMyAdmin

I noticed that Message-ID:
<15b2d909.04121 61020.455492a7@ posting.google. com> from Rob contained the
following:
[color=blue]
>Quick question. In my database I have 2 tables. 1)initial_users and
>2)registered_u sers. This is what i want to accomplish. When someone
>signs up with my site the info goes into initial_users which is
>working. Once I have verified there information I want to drop there
>row of information into registered_user s, can I do this with
>phpMyAdmin if so I cant figure it out. And as well is there any other
>way that people would suggest how to accomplish this.[/color]

Why two tables? Why not just have a field that simply records whether
they are verified or not?

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Pedro Graca]

Re: phpMyAdmin

Rob wrote:[color=blue]
> Quick question. In my database I have 2 tables. 1)initial_users and
> 2)registered_us ers. This is what i want to accomplish. When someone
> signs up with my site the info goes into initial_users which is
> working.[/color]

That was a "INSERT INTO initial_users ..." sql command.
[color=blue]
> Once I have verified there information I want to drop there[/color]
*their* *their*[color=blue]
> row of information into registered_user s,[/color]

I know no way to do that in one instruction.
You can do it in two:

a) INSERT INTO registered_user s
SELECT <col1>, <col2>, ...
FROM initial_users
WHERE ...

b) DELETE FROM inital_users
WHERE ...
[color=blue]
> can I do this with phpMyAdmin if so I cant figure it out.[/color]

Don't know phpMyAdmin, but I guess you can type the sql commands
somewhere in its interface and execute them.

--
Mail to my "From:" address is readable by all at http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!