Posted by Matt Madrid on 08/06/07 17:00

Bob Bedford wrote:
> Hi all,
>
> I've a problem and can't resolve it.
>
> I've a include.inc.php file with only line is a huge query. to make it
> simple, the query is $query = "select * from xxx where mode = ".$mode
>
> Now, this file is included in an other PHP form. Here is the code:
>
> $mode = 1;
> mysql_query($query...
> $mode = 2;
> mysql_query($query
>
> the first is OK, but the second isn't ok, it still uses the $mode = 1.
>
> Why ? how to fix it ?
> Bob
>
>

$query will have the value of $mode as it was when you first included the file.
Changing $mode later won't change what's in $query.

The easiest way to do what you want is to use sprintf()

$query = "select * from xxx where mode = %d";

$mode = 1;
mysql_query(sprintf($query,$mode));


$mode = 2;
mysql_query(sprintf($query,$mode));


HTH..
Matt M.

• Next in forum: Re: pgp trash troll delete Guy Macon guymacon Guy Macon guymacon Guy Macon
• Prev in forum: Re: How to parse Xml?
• Thread view: Re: include file and variable

[Reply to this message]