|
|
Posted by user on 01/19/07 14:07
Nope. Have tried that and all kinds of other possibilities without
success. Think is has something to do with original sql statement being
in file and brought into current script with require function.
Thanks for the try.
Giannis Vrentzos wrote:
> user wrote:
>
>> 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";
>>
>
> You have to escape double quotes or replace them with single quotes. eg.
> cccb.cccb_id = \"$cccb_id\" or cccb.cccb_id = '$cccb_id'
>
> [snip]
>
>>
>> as you can see, "$cccb_id" is not in query string.
>>
>> any help will be appreciated.
>
>
> Gvre
Navigation:
[Reply to this message]
|