[SOLVED] MYSQL Update Syntax Help

[nightcrawler]

Not sure how the syntax is supposed to work for Update Queries with POST data.  Help Please.

 

$q = "UPDATE articles SET sub=$_POST['c'], 
title=$_POST['t'], 
name=$_POST['n'], 
email=$_POST['e'], 
date=$_POST['d'], 
description=$_POST['d'] WHERE id=$_POST['articleid'] LIMIT 1";

[vbnullchar]

Not sure how the syntax is supposed to work for Update Queries with POST data.  Help Please.

 

$q = "UPDATE articles SET sub=$_POST['c'], 
title=$_POST['t'], 
name=$_POST['n'], 
email=$_POST['e'], 
date=$_POST['d'], 
description=$_POST['d'] WHERE id=$_POST['articleid'] LIMIT 1";

 

<?php
$q = "UPDATE articles SET sub='$_POST[c]', 
title='$_POST[t]', 
name='$_POST[n]', 
email='$_POST[e]', 
date='$_POST[d]', 
description='$_POST[d]' WHERE id='$_POST[articleid]' LIMIT 1";

?>

[nightcrawler]

cool, thanks, marking as resolved