:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 8:37 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Can someone help me out?
eval($recss[sql1]).. variables inside a string have to be expanded
manually, since you're storing the variable names inside the DB, you
have to manually pull them out
= $div group by a.name order by Results desc
limit '$display'
As you can see the variables aren't being changed, any ideas?
Thanks
-Rich
-Original Message-
From: Jason Walker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 6:54 PM
To: 'ReClMaples'
Subject: RE: [PHP-DB] Can someone
Is your query wrapped in single quotes, instead of double quotes?
Variable expansion, of course, doesn't occur under single quotes. :)
ReClMaples wrote:
I am having a problem getting a sql statement to run.
I have this in a table called stat_categories, in a field called sql2
select
can you show the code around it? are you using single quotes in defining the
sql statement? or double quotes?
Bastien
From: ReClMaples [EMAIL PROTECTED]
To: Jason Walker [EMAIL PROTECTED]
CC: PHP php-db@lists.php.net
Subject: RE: [PHP-DB] Can someone help me out?
Date: Tue, 7 Jun 2005 19:00
: Tuesday, June 07, 2005 7:21 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: RE: [PHP-DB] Can someone help me out?
can you show the code around it? are you using single quotes in defining the
sql statement? or double quotes?
Bastien
From: ReClMaples [EMAIL PROTECTED
] Can someone help me out?
error is in $limit !!!
you need to limit by two variables, starting and how many entities you want
to get, for exampe
LIMIT '$beggining', '$howmany'
Best regards
Isidor stankov
- Original Message -
From: ReClMaples [EMAIL PROTECTED]
To: PHP php-db@lists.php.net
, 2005 7:21 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: RE: [PHP-DB] Can someone help me out?
can you show the code around it? are you using single quotes in defining the
sql statement? or double quotes?
Bastien
From: ReClMaples [EMAIL PROTECTED]
To: Jason
:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 8:37 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Can someone help me out?
eval($recss[sql1]).. variables inside a string have to be expanded
manually, since you're storing the variable names inside the DB, you
have to manually pull them out
in
the variables sql1 and sql2.
Thanks
-Rich
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 7:21 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: RE: [PHP-DB] Can someone help me out?
can you show the code around