Posted by Siebie on 01/21/07 16:19

user <someone@someplace.org> wrote in
news:uIfrh.739360$QZ1.470012@bgtnsc04-news.ops.worldnet.att.net:

> Have "require" file containing several query stings.
>
> Depending on user input one of strings is selected. Everything going
> along smoothly until I wanted to also input a variable in string. If I
> put string in program works ok, but, if I use string from require file
> I can not seem to insert variable.
>
> $cccb_id is sting..... to be inserted into $query4 and changes
> depending on user input.
>
> $query4 = "select cccb.cccb_name as 'cccb', CONCAT(member_fname,'
> ',member_lname) as 'member' from member_cccb_lnk join member on
> (member.member_no = member_cccb_lnk.member_no) join cccb on
> member_cccb_lnk.cccb_id = cccb.cccb_id and cccb.cccb_id = "$cccb_id"
> order by member";
>
> output is: select cccb.cccb_name as 'cccb', CONCAT(member_fname,'
> ',member_lname) as 'member' from member_cccb_lnk join member on
> (member.member_no = member_cccb_lnk.member_no) join cccb on
> member_cccb_lnk.cccb_id = cccb.cccb_id and cccb.cccb_id = order by
> memberError 1064
>
> as you can see, "$cccb_id" is not in query string.
>
> any help will be appreciated.

Try this:
$query4 = "select cccb.cccb_name as '_cccb', CONCAT(member_fname,'
',member_lname) as 'member' from member_cccb_lnk join member on
(member.member_no = member_cccb_lnk.member_no) join cccb on
member_cccb_lnk.cccb_id = cccb.cccb_id WHERE cccb.cccb_id = "$cccb_id"
order by member";

The selection you want to use (cccb.cccb_id = "$cccb_id") has nothing to
do with the join, so narrow your selection using the WHERE-clause. There
could also be a little confusion with the "AS 'cccb'", because cccb is
both a table as a fieldname. Try another fieldname instead (like
'_cccb').
--
Siebie

[Back to original message]