How can I simplify this?

[Arenlor]

PHP Code:

$sar = "UPDATE posts SET post_data = '$data' where post_num =$num";
$sar2 = "UPDATE posts SET post_title = '$title' where post_num =$num";
$ras = mysql_query($sar);
$ras2 = mysql_query($sar2); 


It works, but I know that there HAS to be a way to make it simpler, it's a mysql DB of course. But I'm not sure how to do that any simpler. Thanks for any help.

[brealmz]

Originally Posted by Arenlor

PHP Code:

$sar = "UPDATE posts SET post_data = '$data' where post_num =$num";
$sar2 = "UPDATE posts SET post_title = '$title' where post_num =$num";
$ras = mysql_query($sar);
$ras2 = mysql_query($sar2); 


It works, but I know that there HAS to be a way to make it simpler, it's a mysql DB of course. But I'm not sure how to do that any simpler. Thanks for any help.

UPDATE posts 
  SET 
  post_title = '$title',
  post_data= '$data'
WHERE 
  post_num = '$num'

[Arenlor]

Thanks for that, knew it was simple and I was just looking over it.