a_gajic — Fri, 02 Aug 2002 23:19:54 +0000

damnit.. thanks Mark - I knew that I hate it when that happens lol.. thanks for the info about the query not retrieving a true/false value too

zollet — Fri, 02 Aug 2002 07:10:16 +0000

Mark, nice catch! I didn't even bother looking at the query when I saw the !$result part.

Cheers.

Mark Hensler — Fri, 02 Aug 2002 06:49:52 +0000

SET doesn't use the AND field seperator, it uses the coma.

$query = "UPDATE topics SET tsubject='$tsubject', tbody='$tbody' WHERE tid='$tid'";

zollet — Fri, 02 Aug 2002 02:18:24 +0000

a_gajic,

Try the following..

<?php
$query = \"UPDATE topics SET tsubject='$tsubject' AND tbody='$tbody' WHERE (tid=$tid)\";
$result = mysql_query($query);

if (mysql_errno())  {
   echo \"Error in query<br>\n\";
   echo mysql_errno() . \" - \" . mysql_error();
}
?>

The reason why I suggest this is because when you run an UPDATE query, it does not return a TRUE or FALSE value in $result.

ROB — Fri, 02 Aug 2002 00:05:57 +0000

are you sure $tid has a value and the record exists in the database?

a_gajic — Thu, 01 Aug 2002 21:04:06 +0000

Okay guys this is what happens...

When I echo the variables they are fine and they show up...

There is no mysql_error(); text either, any more ideas?

the script is for an edit page on my forums that I am creating the query is like this

$query = "UPDATE topics SET tsubject='$tsubject' AND tbody='$tbody' WHERE (tid=$tid)";
$result = mysql_query($query);

if (!$result)  {

   echo "Error in query<br>\n";
   echo mysql_error();

}

any ideas?

anti — Thu, 01 Aug 2002 11:22:35 +0000

and if that doesn't help, an
echo mysql_error( );

is your friend.

mairving — Thu, 01 Aug 2002 10:16:29 +0000

The best way to tell what is going on is to echo your query to the screen to see if it is passing values to the database.