Hi everyone,

First post here.

I'm looking for a cgi script that looks like a classified ads script where someone can create an account, add an ad and then be able to come back a few days after, enter his userid and password, modify his ad and then see the ad go from the bottom of the screen to the top because the ad has been updated.

Anyone seen such a script and what if anyone here can build me one from scratch, how will you charge me?

Richt now I have one but it's very basic. It doesn't uses a solid db like MySql so it can crash at anytime and even if I can use the htaccess prompt to enter my password and get inside the ad and modify it, the ad won't be moved to the top of the page because the page is plain HTML and not PHP.

Basically, I guess I need some kind of php page that can access a MySql db, and a secured page to go to edit the fields. The php page would then see that the db has been modified and the record would then be brought back on top of the page.

Anyway, let me know what you think.


Mtlinfo

Thread moved.

Okay, I am confused. You title the thread "Help from PHP gods" yet you want a CGI script?

There is one at http://www.h-realms.com/classified.html which may interest you.

Contact me and I will sell it to you 50% off.

Yeah ok, sorry about that.

I am searching for a script that has all the features I want but after searching for one at pretty much all the script archive sites, I didn't find the one I was looking for.

Basically, all I want is a site where ads will listed using tables with 3 rows.

The first row will be the ad title (bright red), the 2nd row will be the description of the ad and the 3rd row of the ad will contain the contact info with links on it.

Now here's where the fun comes in...

I want these ads (tables) to be listed by date, in other words if the 5th ad gets updated it moves back to the #1 spot at the top of the page. I'm not a programmer here but I guess it has to do with the TIMESTAMP or ORDER BY code here...right?

The other tricky part is that I want the user to login and edit only his own ad (db record) and not see the entire database and modify the ads of others. Don't have a clue what code I need to enter in the page to isolate just 1 record of the MySQL db here so please help me out here.

Overall, If I'm not mistaking, I need 3 pages here.

1- A php page that will display the ads by date of entry or update.

2- A php page to subscribe and insert the ad (title, description, contact info, username and password).

3- A password protected (htaccess) php page to edit that specific ad (isolate a record in the db) anytime they want to.

If anyone can tell me where I can find such code to insert in these 3 pages, that would make my day :-)

Mtlinfo