When creating a query to select data from the Mysql database via
phpadmin this works...

-----------------------------
$paigntontb = 'SELECT * FROM ct_bok LEFT JOIN resmal ON
(resmal.resmalid=ct_bok.resmalvalid) LEFT JOIN buss_plats ON
(buss_plats.buss_req = ct_bok.bokbus) WHERE (resmalvalid IN (' .
implode(', ', $items) . ') && bok_adminkod < 2) ORDER BY
bokeft,bokfor,bokanmref';
$paigntontbd=mysql_query($paigntontb);
-----------------------------

However I'd like to make the 2 a variable. So I set $myvar to 2 as
follows....

I tried
-----------------------------
$myvar = 2;
$paigntontb = 'SELECT * FROM ct_bok LEFT JOIN resmal ON
(resmal.resmalid=ct_bok.resmalvalid) LEFT JOIN buss_plats ON
(buss_plats.buss_req = ct_bok.bokbus) WHERE (resmalvalid IN (' .
implode(', ', $items) . ') && bok_adminkod < $myvar) ORDER BY
bokeft,bokfor,bokanmref';
$paigntontbd=mysql_query($paigntontb);
-----------------------------
But it does not find any records. What am I missing in the syntax?

Any help greatly appreciated.

Garry Jones
Sweden

hi,

what if you echo the $paigntontb var ?
i think it should work.

what if you write instead:

$myvar = 2;
$paigntontb = 'SELECT * FROM ct_bok LEFT JOIN resmal ON
(resmal.resmalid=ct_bok.resmalvalid) LEFT JOIN buss_plats ON
(buss_plats.buss_req = ct_bok.bokbus) WHERE (resmalvalid IN (' .
implode(', ', $items) . ')&& bok_adminkod< '. $myvar.') ORDER BY
bokeft,bokfor,bokanmref';

regards,

f.


Le 12/01/2011 17:12, GarryJones a écrit :

GarryJones wrote:
a lot.

once inside the single tick, you are in string mode.

I am surprised the original query worked.

Use strings like this:

$query="select A from b where id='".$c."'"
$result=mysql_query($query);

since SQL likes single ticks, use double to demarcate the string or PHP.

Even better is sprintf

i.e. $query="select a from b where id='%d'",$c);

Sine %d will try and make $c an integer, even if it is a hackers string
or whatever, it won't do too much damage.

On 1/12/2011 11:12 AM, GarryJones wrote:
Is it not finding any rows, or do you have an error in your SQL? When
you issue the mysql_query(), do you get back a result set (even if it is
empty), or do you get false? If the latter, your query is bad-
mysql_error() will help you find the problem.

If you are getting back an empty result set, then your data isn't like
you think it is. Like fabrice suggested, echo the query before
executing it and see if it contains what you think it does. Chances are
you'll see your problem. If not, echo the original query and see what
it shows.

BTW - it will be much easier to read your query if you format it better,
i.e.

$paigntontb = 'SELECT * ' .
'FROM ct_bok ' .
'LEFT JOIN resmal ON (resmal.resmalid=ct_bok.resmalvalid) ' .
'LEFT JOIN buss_plats ON (buss_plats.buss_req = ct_bok.bokbus) ' .
'WHERE (resmalvalid IN (implode(', ', $items) . ') ' .
&& bok_adminkod < $myvar) ' .
'ORDER BY bokeft,bokfor,bokanmref';

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Am 12.01.2011 17:31, schrieb The Natural Philosopher:

And since it's an integer, why would you want to enclose it with ticks
in the query?

Helmut

Thanks for your help everyone.

This

bok_adminkod< '. $myvar .'

did it...

GarryJones wrote:

Helmut Chang wrote:

On Wed, 12 Jan 2011 08:12:38 -0800 (PST), GarryJones wrote:
Nothing. But you are missing how your particular application language
handles variable interpretation in single-quoted strings.

My guess is that you'll want to review
http://php.net/manual/en/language.types.string.php

--
59. I will never build a sentient computer smarter than I am.
--Peter Anspach's list of things to do as an Evil Overlord

I agree about formatting, but isn't this easier still...
I've centrally justified it too but I don't think this forum supports BBCode.

$items = implode(', ', $items);
$paigntontb = "
SELECT *
FROM ct_bok cb
LEFT
JOIN resmal r
ON r.resmalid=cb.resmalvalid
LEFT
JOIN buss_plats bp
ON bp.buss_req = cb.bokbus
WHERE cb.resmalvalid IN ($items)
AND cb.bok_adminkod < $myvar
ORDER
BY bokeft
, bokfor
, bokanmref"