Hello,
In my app i use http job download2 to execute sql queries. For insert i use in my php code
works good.
But for update i cant update multiple coloumns . ( i want to update some of the coloumns )
this gives me 500 internal error.
I am not too much familiar with php and sql . Can you point out my error please . Thanks
In my app i use http job download2 to execute sql queries. For insert i use in my php code
B4X:
$q = mysql_query("INSERT INTO tbldoviz (usd, usd1, usd2, eur, eur1, eur2, chf, chf1, chf2,jpy,jpy1,jpy2,sar,sar1,sar2,gbp,gbp1,gbp2) VALUES ('$d1', '$d2', '$d3', '$d4', '$d5', '$d6', '$d7', '$d8', '$d9', '$d10', '$d11', '$d12', '$d13', '$d14', '$d15', '$d16', '$d17', '$d18')");works good.
But for update i cant update multiple coloumns . ( i want to update some of the coloumns )
B4X:
$q = mysql_query("UPDATE tbldoviz set usd='$d1', usd1='$d2', usd2='$d3', eur='$d4', eur1='$d5', eur2='$d6', chf='$d7', chf1='$d8', chf2='$d9', jpy='$d10');this gives me 500 internal error.
I am not too much familiar with php and sql . Can you point out my error please . Thanks