On 09 October 2003 16:57, Davy Campano wrote:
> 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
variables are not interpolated in single-quoted strings -- you need double quotes in
your assignment statement, too:
$sql = "UPDATE wo SET status = 1 WHERE ticket = $HTTP_POST_VARS[ticketed]";
or (my preference):
$sql = "UPDATE wo SET status = 1 WHERE ticket = {$HTTP_POST_VARS['ticketed']}";
(And, of course, if your PHP is 4.2.0 or later, you should probably prefer to use
$_POST rather than $HTTP_POST_VARS.)
Cheers!
Mike
---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
