Re: php variable in sql string

user wrote:
Jerry Stuckle wrote:

user wrote:

Jerry Stuckle wrote:

user wrote:

Jerry Stuckle wrote:

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.


Is $cccb_id a numeric value? If so, it shouldn't be in quotes. Removing the double quotes around it will solve your problem.

If it is not numeric, then you need single quotes around it, not double.

> Nope but thanks anyway.
>
> $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;";
>
> query4 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
> member;
>

(Top posting fixed)

Whoops - I missed one important thing. It looks like $cccb_id is empty.

Try echoing this to the screen before you build your select statement.

P.S. Please don't top post. Thanks.


>
> variable is not empty. As explained earlier this same sql script runs
> fine if placed inside the php program. It is just when it is located
> within the require "db.inc" file that the variable substitution does not
> work.
>
> Appreciate your top post request, but refuse to join the flat earth
> society.
>

(Top posting fixed - again)

As I said - did you actually try to echo the variable to the screen to see what's in it?

And if you don't follow normal usenet conventions, don't expect to get a lot of help from this newsgroup. You're the one asking for help. You should follow the established conventions.

So please don't top post. Or don't expect much for answers.

> Jerry,
>
> Read posts and reply or don't. That is your decision.
>
> P.S. For you and Inkster. THE EARTH IS NOT FLAT!!! REALLY!! Any you
> saying it is does not make it so!
>
> Have a nice day!
>
>
Top posting fixed - AGAIN!

No, but top posting in a group which uses bottom posting as a convention, then refusing to change when politely asked, shows the ultimate level of arrogance.

Considerate people follow the conventions of the culture (including newsgroups) in which they participate. Only losers and assholes refuse to do so and insist others follow whatever conventions THEY want to observe.

Which are you?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.