how to condense an update query

[dadamssg]

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));

[corbin]

Have you read the manual page on UPDATE queries?

 

 

 

UPDATE table1 SET col1 = 'val1', col2 = 'val2', ... WHERE ....