Dynadot Aftermarket: discover domain gems worth investing in. Visit our aftermarket.

MySql Update problem?

SpaceshipSpaceship
SpaceshipSpaceship
NamecheapNamecheap
Watch

iNod

Eating PieVIP Member
Impact
66
Hello,

PHP:
        $getorder = "SELECT * FROM form_fields WHERE fid='".$fid."'";
        $go = $db->fetch($db->query($getorder));
        $neworder = $go['order']-1;

		$update_query = "UPDATE form_fields SET order='".$neworder."' WHERE fid='".$fid."'";
		$data = $db->query($update_query);
		print '<p>Field has been successfully moved.</p><br />';

That is the code and I get

Code:
UPDATE form_fields SET order='9' WHERE fid='270'
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 'order='9' WHERE fid='270'' at line 1

What could be the problem?

Thanks,
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
PHP:
$update_query = "UPDATE form_fields SET order = '$neworder' WHERE fid = '$fid'";
 
0
Close
Nice try Axilant but it doesn't work :(

I have tried everything..
 
0
Close
0
Close
DomainEasy: white label portfolios are live. Enable yours.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

Filters for activity feeds
Your news feed, Latest activity, and the activity tab on profiles now have filter buttons: All, Posts, Quick replies, and Other. Your...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back