dadamssg Posted August 15, 2009 Share Posted August 15, 2009 how would i condense this into ONE query? i know its simple but i just don't know how <?php $sql = "UPDATE test SET start = '$store' WHERE eventid={$postid}"; $result = mysqli_query($cxn,$sql) or die (mysqli_error($cxn)); $sqe = "UPDATE test SET end = '$erl' WHERE eventid={$postid}"; $reslt = mysqli_query($cxn,$sqe) or die (mysqli_error($cxn)); $tql = "UPDATE test SET title = '$title' WHERE eventid={$postid}"; $teslt = mysqli_query($cxn,$tql) or die (mysqli_error($cxn)); $rql = "UPDATE test SET description = '$description' WHERE eventid={$postid}"; $reslt = mysqli_query($cxn,$rql) or die (mysqli_error($cxn)); $vql = "UPDATE test SET location = '$location' WHERE eventid={$postid}"; $veslt = mysqli_query($cxn,$vql) or die (mysqli_error($cxn)); $cql = "UPDATE test SET event = '$event' WHERE eventid={$postid}"; $veslt = mysqli_query($cxn,$cql) or die (mysqli_error($cxn)); Link to comment https://forums.phpfreaks.com/topic/170350-how-to-condense-an-update-query/ Share on other sites More sharing options...
corbin Posted August 15, 2009 Share Posted August 15, 2009 Have you read the manual page on UPDATE queries? UPDATE table1 SET col1 = 'val1', col2 = 'val2', ... WHERE .... Link to comment https://forums.phpfreaks.com/topic/170350-how-to-condense-an-update-query/#findComment-898648 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.