Jump to content

Archived

This topic is now archived and is closed to further replies.

creeker

missing data

Recommended Posts

This is a newbie question.

I have two tables and perform this join:
SELECT c.name, c.description, d.caption, d.image FROM archfolio_category AS c INNER JOIN archfolio_detail AS d on c.ID=d.project AND d.project =12;

Everything works except that the c.description the cell entries show up as empty except for the heading.

If I use the code below the column heading and entries show:
SELECT * FROM archfolio_category; 

I don't understand where things might be going wrong. Any help is appreciated.

Share this post


Link to post
Share on other sites
It's only a waste if you don't post "how" you figured it out.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.