View Single Post
  #4 (permalink)  
Old 03-11-2004, 03:52 PM
mtlinfo mtlinfo is offline
Junior Member
 
Join Date: Mar 2004
Posts: 2
Default

Quote:
Originally Posted by Tommy
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
Reply With Quote