Posted by iulian.ilea on 01/17/07 07:55

user wrote:
> Tried those already.....
>
> '$cccb_id' cccb.cccb_id = ('') order by memberError 1064
> .'$cccb_id'. gets cccb.cccb_id = (.''.) order by memberError 1064
> and $cccb_id and [cccb_id] and ........
>
>
>
> ZeldorBlat wrote:
>
> > user wrote:
> >
> >>Have require file with several query stings in it.
> >>
> >>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 string.
> >>
> >>$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.
> >
> >
> > Count your double quotes:
> >
> > $query4 = "select cccb.cccb ... and cccb.cccb_id = "$cccb_id" order by
> > member";
> >
> > So your $cccb_id isn't inside the quotes. You probably want to either
> > remove those quotes so the variable is inserted into the string
> > automatically or add .'s on both sides of $cccb_id.
> >

You can try this also:
$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";

or, I think this shoul work too:

$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";

[Back to original message]