Devam Ediyor

Seller Items Are Limited To Set Amount

Seller Items Are Limited To Set Amount

OVERVIEW:

Our website features an online marketplace for buyers and sellers. Sellers are given an opportunity to sell up to 100 products when they signup. As a business relationship develops, I want to be able to change the limit to 300, 500 or 1000 products. At this present time, there is no script in the SQL statement setting the limitations of products created. I have a field in the accounts table called sellerlimit, which has a default of 100. This data will dictate the product count restrictions.

GETTING THERE:

When a seller signs in, he is redirects to the sellers account page.

[url removed, login to view]

To sell an item, the seller would click the "sell item" link and arrive at:

[url removed, login to view]

GOAL:

I need a script added to the SQL statement sellitem page that would stop the page from inserting a new record when the SUM of the seller's products go above 100 records in the products table.

Each seller has a unique account number in the accounts table called accountnumber. When a new product (record) is inserted into the products table, the accountnumber is also inserted into the [url removed, login to view] field. Products table also includes a column called products.one. It has a default of 1, when a record is created. I'm unclear whether it's needed to count the records in the products table but have it included just in case.

Scripting Language/Database: PHP MySQL

THIS IS THE CURRENT STATEMENT:

$query_rsSellitem = sprintf("SELECT [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] FROM accounts, products WHERE [url removed, login to view] = %s AND accesslevel = 2", GetSQLValueString($colname_rsSellitem, "text"));

-----------------------------------------------------------------------------

Send me a private message regarding your approach to making this work and the results of the work in completing this project here.

INFORMATION PROVIDED:

Above, I have provided what I believe is all the information regarding this project with exception to login information to the FTP & database. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.

Beceriler: Adobe Dreamweaver, MySQL, PHP, Alışveriş Sepetleri, SQL

Daha fazlasını görün: zones, this seller, the limited, set data, seller number, php scripting business, personal development online, pending amount, online shopping script php, online marketplace work, online exchange account, online buyers sellers, want set website, want marketplace, immediate opportunity, language overview, buyers need seller, base exception, a seller, approach, 3 seller, website seller, seller, completing case, click exchange

İşveren Hakkında:
( 31 değerlendirme ) Antioch, United States

Proje NO: #739145

Seçilen:

brycep

Hi Marty,As discussed.Thanks,Bryce

2 gün içinde 75$ USD
(234 Değerlendirme)
7.9

7 freelancer bu iş için ortalamada 41$ teklif veriyor

satoewarna

Ready to start. Please check PM for the explanation.

in 0 gün içinde50$ USD
(42 Değerlendirme)
5.6
eagle2k13

Please see the PMB. Thanks!

in 2 gün içinde30$ USD
(27 Değerlendirme)
5.2
softwarehandyman

Straightforward. See PMB.

1 gün içinde 30$ USD
(52 Değerlendirme)
5.1
sidrabs

I can add limit, and panel for editing limit in notime

1 gün içinde 30$ USD
(20 Değerlendirme)
4.6
hamm

I can start immediately.

1 gün içinde 40$ USD
(24 Değerlendirme)
4.5
KonstantinSt

Please check PMB. Regards.

in 0 gün içinde30$ USD
(4 Değerlendirme)
3.2