i want select name form one table and display in my page

Question

SELECT name from tbl_gallery, tbl_gallery_category where 'name' = 'gallery-cat-id';

I have two tables one for category and second for saving images with category name my query is here Then executing thien shows MySQL returned an empty result set (i.e. zero rows). (Query took 0.0007 seconds.)

reomve single quotes in name instead of 'name' – JYoThI Oct 25 '16 at 09:27 — JYoThI, Oct 25 '16 at 09:27
yes name contains gallery-cat-id – javis Oct 25 '16 at 09:30 — javis, Oct 25 '16 at 09:30
@javis then check answers bellow. – S.I. Oct 25 '16 at 09:31 — S.I., Oct 25 '16 at 09:31

score 2 · Answer 1 · edited May 23 '17 at 10:32

Remove single quotes in name instead of 'name' read when to use single quotes, double quotes, and backticks

If you put single quotes on table or column name, they are treated as string so don't put.

SELECT `name` 
FROM tbl_gallery 
JOIN tbl_gallery_category ON tbl_gallery.name = tbl_gallery_category.gallery-cat-id;

Note :

where 'name' = 'gallery-cat-id';

above where condition is always false only. Because your just comparing 'name' is equal to 'gallery-cat-id' so that it's false .

score 2 · Answer 2 · answered Oct 25 '16 at 09:28

2

Don't use quotes on table or column names.

SELECT name 
from tbl_gallery
join tbl_gallery_category on tbl_gallery.name = tbl_gallery_category.`gallery-cat-id`

If you need to escape a column name then use backticks.

answered Oct 25 '16 at 09:28

juergen d

201,996
37
293
362

i want select name form one table and display in my page

2 Answers2