help with update query

[dadamssg]

how do i make this correct?

 

$sql = "UPDATE test SET title={$title}, description={$description}, location={$location}, event={$_POST['event']}, start={$ss}, end={$ee} WHERE eventid={$postid}";

 

i use these same values when i enter them in my db in the first place...so i know they are all acceptable into my db, i just dont think i have the query right. some help would be awesome

[dadamssg]

this works, but i KNOW there has to be a more efficient way to do this, any know the CORRECT way???

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

[fenway]

how do i make this correct?

 

$sql = "UPDATE test SET title={$title}, description={$description}, location={$location}, event={$_POST['event']}, start={$ss}, end={$ee} WHERE eventid={$postid}";

 

i use these same values when i enter them in my db in the first place...so i know they are all acceptable into my db, i just dont think i have the query right. some help would be awesome

How about some string literal quoting???

[dadamssg]

not sure i know what you're asking for...?

[xtopolis]

fenway means:

$sql = "UPDATE test SET title={$title}, description={$description}, location={$location}, event={$_POST['event']}, start={$ss}, end={$ee} WHERE eventid={$postid}";

to something like this

$event = $_POST['event'];
$sql = "UPDATE test SET title='$title', description='$description', location='$location', event='$event', start='$ss', end='$ee' WHERE eventid='$postid'";

I'm not sure how to use the {$_POST['event']} type as I never use that form.