A
A
Andrey Angelovich Stock2018-06-08 12:01:56
MySQL
Andrey Angelovich Stock, 2018-06-08 12:01:56

What is wrong with mysql query?

Hello! There is a request to a DB and it does not work. What's wrong with him?

mysqli_query($link, "UPDATE analyz_data_comm_prop SET object='$object', date='$date', txtarea1='$txtarea1',link1='$link1',filename1='$filename1'link2='$link2',filename2='$filename2',selectQuery='$selectQuery', warning='$warning', recommendation='$recommendation',opportunity='$opportunity', block2opp='$block2opp',block2rec='$block2rec',block2site='$block2site',block2ton='$block2ton',moreOpp='$moreOpp',moreOppSite='$moreOppSite',req='$req',req2='$req2',block3rec='$block3rec',feedback='$feedback',scenario='$scenario',likes='$likes',comments='$comments',priceR='$priceR',removeNeg='$removeNeg',siteNeg='$siteNeg',priceNeg='$priceNeg' WHERE client_url = '$client_url'");

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Artem, 2018-06-08
@your_uncle

To find out what exactly is wrong, print this line to the screen, then execute it in the database. So you will see the answer, what is wrong with the request.

V
Valery, 2018-06-08
@Tur2

There is no comma after filename1='$filename1'.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question