Table Error

$10 USD

Cancelled

Posted

over 10 years ago

$10 USD

Paid on delivery

Showing this error on the table,,this are very eazy to fix,tell me where to make the change and if it works you got $10.00 payment..Max bid is $10.00 by Freelancer.com. It says right therewhere the problem is in the error I just want to make sure..On my Sell page when I save it shows that error below..Will do a Milestone Payment No C/panel or FTP logins will be given.. 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 \'AND media_type=1 AND upload_in_progress=0 ORDER BY media_id ASC\' at line 1 •SQL Query: SELECT media_url FROM probid_auction_media WHERE auction_id= AND media_type=1 AND upload_in_progress=0 ORDER BY media_id ASC

HTML

MySQL

PHP

Project ID: 5022900

About the project

20 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

20 freelancers are bidding on average $11 USD for this job

@Reflexlogic

Hello, I know the issue. It is due to dynamically passing value to query. lets discuss. I know the issue. It is due to dynamically passing value to query. lets discuss. Thanks

$13 USD in 1 day

5.0

(187 reviews)

8.6

@DreamOne

Hello I checked the query and found what is the problem Please msg me I will tell you the problem in a second. Thanks.

$10 USD in 1 day

5.0

(182 reviews)

7.8

@VikashThecoder

There is an error in sql syntax The error is at this place where auction_id = AND Please specify the valid auction_id value and it will work Thanks

$10 USD in 0 day

4.9

(378 reviews)

7.4

@PhungTran

Hi, may i please ! Thanks. .

$10 USD in 0 day

4.9

(509 reviews)

6.9

@miennh

Hello, ------------------------------------------------------------------------------------------------- I can fix in a few mins and am ready to start right now. Thanks

$10 USD in 0 day

5.0

(253 reviews)

6.9

@xyzrkt

Hi, may I help you ? I will fix it. Have experience in SQL, mysql, php, java etc. I assure you that I will fix it within an hour. I HAVE CHECKED THE QUERY AND WILL FIX THIS IN SECONDS. Thanks.

$10 USD in 1 day

5.0

(126 reviews)

6.4

@kishanlalyadav

experts here, ready to start right now. Fluent English and always available on Skyp to discuss project specs. Why waste your time with anyone else? Hello sir, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

$14 USD in 2 days

4.7

(285 reviews)

6.9

@harsh170890

Hello There I have seen the query in the description. I can give you the solution for this. Let me know if you need my help

$13 USD in 0 day

4.6

(44 reviews)

5.9

@slimmiz

I can tell u there the error is, it is very easy. u must give the value of auction_id it can not be empty in query. if u dont pass the argument dont include this auction_id in query, just dont leave it like auction_id=

$10 USD in 0 day

4.9

(40 reviews)

5.1

@JNetwork

Hi Your issue is : SQL Query: SELECT media_url FROM probid_auction_media WHERE auction_id= AND media_type=1 AND upload_in_progress=0 ORDER BY media_id ASC ** Missing auction_id ** You should add null value or "remove auction_id= AND" Kind regards, Jnetwork

$10 USD in 1 day

4.9

(5 reviews)

4.8

@arp19690

Hello we will solve your problem quickly. we can solve by using teamviewer and we assure you that we will be quick.. we have agreed to your 10 USD payment..we are looking forward for your work.. lets start now. thanks

$10 USD in 0 day

4.6

(30 reviews)

4.2

@lakelet

Hi, I have checked the SQL syntax and found the error. If you award me, I tell you the error now. Thanks!

$10 USD in 0 day

5.0

(12 reviews)

3.4

@ErwanMas

DONE IMPORTANT DONE Your problem is after auction_id= , you need a value SELECT media_url FROM probid_auction_media WHERE auction_id= AND media_type=1 AND upload_in_progress=0 ORDER BY media_id ASC

$10 USD in 0 day

4.4

(9 reviews)

3.9

@choks1991

Hi..i can handel this..i can resolve in 1 to 2 hours only.i have exp on that we can discuss . Thank you

$10 USD in 0 day

4.0

(8 reviews)

3.1

@doveinfo

SELECT media_url FROM probid_auction_media WHERE (auction_id= AND media_type=1 AND upload_in_progress=0) ORDER BY media_id ASC Please use the ( and there Auction_is is not getting value.. Please fix that... for this it is now working.. If you need any help, please don't mind to contact with me..

$10 USD in 3 days

5.0

(7 reviews)

2.3

@shailesh123sl

I know about MYSql, I have worked on it. I studied your query carefully and I have found the errors. I will fix it. Let me know how to contact you.

$15 USD in 0 day

0.0

(0 reviews)

0.0

@TheWebWorld

Hi There is a problem in your query SELECT media_url FROM probid_auction_media WHERE auction_id= AND media_type=1 AND upload_in_progress=0 ORDER BY media_id ASC auction_id is blank so given error .Add auction_is there and you will get proper response

$10 USD in 1 day

0.0

(0 reviews)

0.0

@raghavdeepm

i'm a web developer, with more than 1 year experience. I have the knowledge about HTML, AJAX, CSS, PHP, JavaScript, J query, Zend Framework, WordPress, E-Commerce. i'm competent, quick and honest. i've build website compatible to all browsers and all mobiles

$15 USD in 0 day

0.0

(1 review)

0.0

@maikelblesin

It could be done in few minutes but why dont you attach the file so I can just make the fix but check out auction_id=$ cant be AND so check on fixing that

$10 USD in 0 day