Jump to content

how to condense an update query


dadamssg

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.