using like and where in a joined query.

[leelotis]

Hi im doing the following query

SELECT * FROM networkinfo JOIN tblimage WHERE networkinfo.network LIKE '$data' && networkinfo.network = tblimage.imgdata && networkinfo.category = '$category'

so I can get it to work untill I add the last

&& networkinfo.category = '$category'

this kills the whole query what am I doing wrong? I think it has to do with using the like and where in the same query because I havnt run into this issue before the query seems simple enough to me.

Thanks

[ssnaik84]

check for following conditions -
1) if you are using "JOIN", you should use "ON" keyword to map tables
2) if networkinfo.category is integer, then remove single quote (')
3) try using "AND" instead of "&&"

[ssnaik84]

try printing your SQL stmt variable. and run directly on Query Browser

[mwasif]

What do you mean by 'kills the whole query'?

Don't mix JOIN with WHERE clause. Try the following

SELECT * FROM networkinfo 
INNER JOIN tblimage 
 ON networkinfo.network = tblimage.imgdata
WHERE networkinfo.network LIKE '$data' AND networkinfo.category = '$category'

[nbiswas]

Try this

SELECT * FROM networkinfo
JOIN tblimage
ON networkinfo.network = tblimage.imgdata
WHERE networkinfo.network LIKE '%data'
AND networkinfo.category = 'category'

Like should be '%data' as far as I know.
and Join condition should be before the where condition

Hope this helps

[leelotis]

great that fixed everything......... : )