Forum Moderators: coopster

Message Too Old, No Replies

managing my database

         

skynyrd

2:38 pm on Sep 8, 2005 (gmt 0)

10+ Year Member



I have 2 databases.
One where people can submit information to be looked over then (if it is acceptable) moved to the second database and deleted from the first.

I want a page with a form that loads the oldest record id #1 from database A into a form so it can be edited if need be and then a button that says Submit that will delete the record from database A and put the record into database B and a button that says Reject, which will just simply destory the record in database A

i know its complicated, but help with the PHP would be greatly appreciated

jatar_k

5:39 pm on Sep 8, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld skynyrd,

here are a couple of threads that might help with portions of your question from our PHP Forum Library [webmasterworld.com]

Basics of extracting data from MySQL using PHP [webmasterworld.com]
Help developing MySQL search query [webmasterworld.com]

I can also give you the basic logic of what you are trying to which might help

1. select last record from db A 
2. load those values into a page/form
3. if submit is clicked
a. take form values and insert into db B
b. delete record from db A
4. if reject is clicked
a. delete record from db A
5. forward to a 'process complete' page

that about covers it. I would start by selecting the record and displaying it, once that is complete then you can move on to the inserting and deleting.

skynyrd

9:00 pm on Sep 8, 2005 (gmt 0)

10+ Year Member



I was able to do it after some serious thinking. I was very impressed with myself because I do not know php.

jatar_k

9:04 pm on Sep 8, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



nice work

>> I do not know php

you do now ;)

skynyrd

10:19 pm on Sep 8, 2005 (gmt 0)

10+ Year Member



Yes, by doing all these things with databases it is helping me to learn php

and i thought staring at tutorials would be the best way to learn...

jatar_k

10:20 pm on Sep 8, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



nah, never is

best way is to dive right in on a project of some kind

skynyrd

10:29 pm on Sep 8, 2005 (gmt 0)

10+ Year Member



im working on a guitar tablature database which i plan to launch...
i plan to put banner ads on it, but i don't know which advertising company to use
any ideas?

jatar_k

10:34 pm on Sep 8, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Google AdSense [google.com] might be an option

We have an AdSense Forum [webmasterworld.com] here also