In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Liz Bander) wrote:
I am getting a parse error for the return line every time I try and view
the page. Can anyone tell me why? The code is below.
$results = "select req, source, number from orders where req=" .
$GLOBALS["req"] . ", source=" . $GLOBALS["source"] . ",
number=" .$GLOBALS["req"] . "";
if (mysql_fetch_row($results) != 0) {
return "This has already been added.";
Is this inside a function? 'Cuz AFAIK a "return" would only make sense
inside a function.
FWIW, the comparison of the fetched row to zero strikes me as a bit
unusual. Are you just checking whether there was no rows were returned by
the query? If so, I suspect that checking mysql_num_rows() would be more
efficient.
Also (since this is part of the problem, I'm sure) how do I take the
$GLOBALS values and set them equal to the req and source values in the
select statement? Is this syntax correct?
Depends. MySQL needs string values quoted too, so if for example all of
those variables are strings you'd do something like:
$results = "select req, source, number from orders where req='" .
$GLOBALS["req"] . "', source='" . $GLOBALS["source"] . ", number='" .
$GLOBALS["req"] . "'";
--
CC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]