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 

> 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"] . "'";


PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to