$15.00 for quick PHP/mySQL job

I need someone experienced with PHP/mySQL to fix a sql error on a PHP script.

It's an error with PHPProBid.. if fixed, i'll re-upload a 100% working edition to the 'Download Section'.

Two errors.. one one the "category" page and the other on the "stores" page.

categories.php
--------

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10' at line 8
SQL Query: SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.creation_in_progress=0 AND a.closed=0 GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT , 10

stores.php:

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 20' at line 3
SQL Query: SELECT user_id, shop_name, shop_logo_path, shop_mainpage, username, shop_nb_items FROM probid_users WHERE active=1 AND shop_active=1 ORDER BY shop_nb_items DESC LIMIT , 20

___________________

Like I said..i'll re-upload this to the Download Section for anyone to download, once this is fixed. I do not mind paying the $15.00 to get this fixed for everyone else to use.

The starting number of "LIMIT" isn't there, thats the problem. Try to find the corresponding variable and inspect why the variable isn't set correct or just set the variable to 1.

If this helps buy yourself some drinks from me

Cheers.

SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.creation_in_progress=0 AND a.closed=0 GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT 1, 10

or

SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.creation_in_progress=0 AND -a.closed=0 GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT 1

//

SELECT user_id, shop_name, shop_logo_path, shop_mainpage, username, shop_nb_items FROM probid_users WHERE active=1 AND shop_active=1 ORDER BY shop_nb_items DESC LIMIT 1, 20

or

SELECT user_id, shop_name, shop_logo_path, shop_mainpage, username, shop_nb_items FROM probid_users WHERE active=1 AND shop_active=1 ORDER BY shop_nb_items DESC LIMIT 1

Thanks for the info... the problem is I can't find where the code is that is trying to access mySQL... heh

PM sent.

fixed

i am having the same issue. please send pm if anyone can help