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 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 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 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 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? Link to comment https://forums.phpfreaks.com/topic/69644-update/#findComment-350523 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.