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