yogibear Posted September 17, 2007 Share Posted September 17, 2007 Hi can anyone see whats wrong with this code when I remove clientref and ourref it works. I dont get any errors and the records dont update. $customer = $_POST[customer]; $clientref = $_POST[clientref]; $ourref = $_POST[ourref]; mysql_query ("UPDATE salesledger SET customer = '$customer', clientref = '$clientref', ourref = '$ourref' WHERE ourref = '$_POST[ourref]'"); echo "1 record updated"; Thanks for help yogi Quote Link to comment https://forums.phpfreaks.com/topic/69644-update/ Share on other sites More sharing options...
emc Posted September 17, 2007 Share Posted September 17, 2007 WHERE ourref = '$_POST[ourref]'"); should be WHERE ourref = '$ourref'"); have fun Quote Link to comment https://forums.phpfreaks.com/topic/69644-update/#findComment-349940 Share on other sites More sharing options...
yogibear Posted September 17, 2007 Author Share Posted September 17, 2007 Hi Didnt solve it, thanks for your fast reply any other ideas yogi Quote Link to comment https://forums.phpfreaks.com/topic/69644-update/#findComment-349946 Share on other sites More sharing options...
yogibear Posted September 17, 2007 Author Share Posted September 17, 2007 Hi all I think I have solved it thanks for your help anyway Quote Link to comment https://forums.phpfreaks.com/topic/69644-update/#findComment-349986 Share on other sites More sharing options...
fenway Posted September 18, 2007 Share Posted September 18, 2007 Hi all I think I have solved it thanks for your help anyway How? Quote Link to comment https://forums.phpfreaks.com/topic/69644-update/#findComment-350523 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.