rockinaway Posted February 19, 2008 Share Posted February 19, 2008 I want to check if something exists within the query.. So I use: isset($var) ? $var : '' However, when I use this is my query, and the value is correctly returned for $var, I get an error with my SQL syntax for that area.. But if I do $var2 = isset($var) ? $var : '' And then just use $var2 in the MySQL query.. it works without errors.. What is wrong with the isset? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 19, 2008 Share Posted February 19, 2008 Did you wrap your first code snippet in parens? Sounds like an order of precedence issue. BTW, that means it's a PHP issue, not mysql related. Quote Link to comment Share on other sites More sharing options...
rockinaway Posted February 19, 2008 Author Share Posted February 19, 2008 Sorted Quote Link to comment Share on other sites More sharing options...
davestewart Posted February 20, 2008 Share Posted February 20, 2008 isset($var) ? $var : '' You're just executing the expression without assigning its result to a variable. $result = isset($var) ? $var : '' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.