[snip] I am having a problem with a form. I am trying to have a form pass a variable so that I can update an item. I think the problem is that the variable (ticketed) is being read as text instead of a number. These are the tests I have run. This statement works: $sql = 'UPDATE wo SET status = 1 WHERE ticket = 1' This statement does not: $sql = 'UPDATE wo SET status = 1 WHERE ticket = $HTTP_POST_VARS[ticketed]' Any suggestions... If I do "echo "$HTTP_POST_VARS[ticketed]"; It returns a 1 [/snip]
There is your clue....double quotes in your last example, but single quotes in your query. To be verbose... $sql = "UPDATE wo SET status = 1 WHERE ticket = '" . $HTTP_POST_VARS['ticketed'] . "' "; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
