Jump to content

Archived

This topic is now archived and is closed to further replies.

xyn

SQL Query issues!

Recommended Posts

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]

Share this post


Link to post
Share on other sites
[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]

Share this post


Link to post
Share on other sites
did it work if not look at your query see whats wrong ok.


print_r($query);

Share this post


Link to post
Share on other sites
What are you trying to do with this query??

Orio.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.