robaiken Posted June 18, 2009 Share Posted June 18, 2009 print "<form methord='post'>"; $insql = "UPDATE `pubpartners`.`statements` SET `print_status` = '0' WHERE `statements`.`id` ={$r['id']} LIMIT 1"; if( is_readable('../statements_invoices/statement/'.$r['FileName']) ) echo '<input type="submit" value="Print">'; mysql_query ($insql); print "</form>"; this is my code when ever the button is clicked it updates all the print_statuses, which is really annoying becasue i only what to update one of id in the database. Thanks for any help EDITED BY akitchin: please use code tags. Quote Link to comment https://forums.phpfreaks.com/topic/162756-id-query-problem/ Share on other sites More sharing options...
robaiken Posted June 18, 2009 Author Share Posted June 18, 2009 can anyone help me? Quote Link to comment https://forums.phpfreaks.com/topic/162756-id-query-problem/#findComment-858877 Share on other sites More sharing options...
robaiken Posted June 18, 2009 Author Share Posted June 18, 2009 any one? Quote Link to comment https://forums.phpfreaks.com/topic/162756-id-query-problem/#findComment-858919 Share on other sites More sharing options...
Maq Posted June 18, 2009 Share Posted June 18, 2009 Relax. Bitching every 10 minutes will not increase the speed of help, in fact, it does quite the opposite. Echo $insql and see what's actually being passed. Seems impossible to update every row when you have LIMIT 1, there's something else going on. Where is $r['id'] coming from? And why is your SQL in your form? Quote Link to comment https://forums.phpfreaks.com/topic/162756-id-query-problem/#findComment-859005 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.