Using php/mysql, how do I allow users to insert a listing into my website and it shows up the accoun

[RMB]

I am trying to make a domain name reselling website to compete with sedo, tdnam, etc. I already know about user registration, login, and recordsets.<br />
<br />
But, I want my users to be able to fill out a form and it shows up in a table on the domain names for sale page (I know how to do this). But, then, I want it to show up in their account page like craigslist. And, how can I limit it to 10 free listings per account?<br />
<br />
Please help. I am using dreamweaver CS3, and I have phpmyadmin. So, how can I create the databases/tables that will be able to do this?<br />
<br />
Thank you very much.<br />

 

[BlueBoden]

It is actually just a question about selecting 10 enteries from the same database, IF the user has a free account.

The LIMIT command may be used on a mysql_query to select a limited number of enteries, see also
http//dev.mysql.com/doc/refman/6.0/en/limit-optimization.html - LIMIT Optimization
http//php.about.com/od/mysqlcommands/g/Limit_sql.htm - Limit - MySQL Command

There are easy-to-setup "Instant Payment Notification", which can be used to notify a php script hosted on your side, that a given user just payed for something on your website, and of cause what that something was.

The php script (which is yours to make) would then select the user in the database, and simply change the value of one of the columns to I.E. "AccountStats" to "active", (or something similier).

Now having this value set to active, you would want to check this value on their account page, this can be done using a simple if statement in php. If the value wasn't active, the user has a limited account, and will only be displayed the 10 enteries.

It may be easiest to use something like paypal to handle your payments, see also https//www.paypal.com/ipn - Instant Payment Notification

If you still cant get it to work, i suggest you continiue your inquiries at http//www.phpfreaks.com/forums/index.php?board=3.0 which may be of better assistance with specific coding problems.