Case

Databases
1

Based on http://dev.mysql.com/doc/refman/5.0/en/case-statement.html, I think I have to store my query before I run it. How do I store and then execute it?

My code so far produces and error:


$query = "UPDATE plan SET curacc = case when curacc + 1 >= ddecpt 
                       then 0
                       else curacc + 1
                  end,
       curwipprice =    case when curacc + 1 >= ddecpt
                       then curwipprice + 1
                       else curwipprice
                  end
   WHERE id = 'LAMS-ZV90'";
   
   include "connect_to_mysql.php";
 echo $query . '<br/>'; 
mysql_query(" . $query . ") or die(mysql_error());
2

the query looks okay

what was the error?

3

Here’s the error I received: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. UPDATE plan SET curacc = case when curacc + 1 >= ddecpt ’ at line 1

I would’ve posted it earlier, but I didn’t think I was close enough for it to matter.

4

your query would be fine if you can track down where that period in front of UPDATE came from, and remove it

i don’t do php but my guess is, it came from here –

mysql_query(" . $query . ") or die(mysql_error());
5

Good guess r937! That did the trick.

That was a nice surprise after mowing the lawn.