SQL Query issues!

[xyn]

Hey,
I've got a small problem with my sql query, the problem is
when I try editing something the query does not update the
database. I've checked the fields and they have info in them :/

my code:
[code=php:0]$db = mysql_connect("localhost", $login, $pwd) or die("Connection Error: ".mysql_error())."";
mysql_select_db("".$INFO['CP_NAME']."".$INFO['DB_NAME']."") or die("DB Error: ".mysql_error())."";
$query = "UPDATE news SET news_head='".$_POST['heading']."',
news_mini='".$_POST['mini']."',
news_more='".$_POST['more']."' AND
news_edit='{$_SESSION['username']['usr_user']}' WHERE news_id='.$pg.'";
mysql_query($query, $db) or die("Query Connection Error: ".mysql_error())."";[/code]

[redarrow]

[code]
$db = mysql_connect("localhost", $login, $pwd) or die("Connection Error: ".mysql_error())."";
mysql_select_db("".$INFO['CP_NAME']."".$INFO['DB_NAME']."") or die("DB Error: ".mysql_error())."";
$query = "UPDATE news SET news_head='".$_POST['heading']."',
news_mini='".$_POST['mini']."',
news_more='".$_POST['more']."' AND
news_edit='{$_SESSION['username']['usr_user']}' WHERE news_id='$pg'";
mysql_query($query, $db) or die("Query Connection Error: ".mysql_error())."";
[/code]

[xyn]

:/

[redarrow]

did it work if not look at your query see whats wrong ok.


print_r($query);

[Orio]

What are you trying to do with this query??

Orio.

[redarrow]

Is session_start at the top of the page?