Query screwyness

[irbk]

Have the following code....

$query = "UPDATE tablename SET title='$title', content='$cont' WHERE contentid='$cid'";
$result = mssql_query ($query);
if ($result){
  echo '<p>Database updated</p>';
} else {
  echo $query;
}

Here is the screwy thing. It updates the database correctly, however, $result for some reason is still coming back false so the $query is printed to the screen. Any ideas why?

Thanks in advance.

 

[cLFlaVA]

possibly a type comparison problem?

does this bode any better for you?

if ($result === false){
  echo $query;
} else {
  echo '<p>Database updated</p>';
}

*cLFlaVA
----------------------------
[tt]( <P> <B>)¹³ * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[cLFlaVA]

... are you using 5.0.3? there's apparently a known bug.



*cLFlaVA
----------------------------
[tt]( <P> <B>)¹³ * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[irbk]

PHP version is 4.3... though I guess the bug could have existed in 4.3 as well.

I get the same results if I try the different comparision. $result still returns as false even though the database is updated.

 

[KarveR]

I'd use mysql_affected_rows() instead, $query will always execute and never show that its failed.

manual:

http://www.php.net/manual/en/function.mysql-affected-rows.php

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[sleipnir214]

Unfortunately, the MSSQL family of functions that irbk is using does not include an equivalent.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[KarveR]

must buy glasses, apologies.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[KarveR]

http://uk.php.net/manual/en/function.mssql-rows-affected.php

unless of course that page is of any use ...

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[sleipnir214]

There it is. I didn't see it.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[irbk]

KarveR,
It's not that $query isn't saying that it failed, it's saying it always fails even though it does run sucessfully. I'll look into the mssql_rows_affected() function. I suppose as long as it returns 1 row, I can assume that it ran $query sucessfully.

Thanks all for your posts.

 

[KarveR]

To keep your existing code, I'd check in that case:

if ($result =='0'){
echo '<p>Database updated</p>';
} else {
echo $query;
}

as Im pretty sure it will return 0 on success (which meets the fail criteria in your if statement) and anything other for fail.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[irbk]

KarveR -
That seemed to do the trick. Altho, I didn't try to input a bad query to see if it dies correctly..... But it at least seems to return the correct info if it runs correctly.... Thanks.