Jump to content


Photo

missing data


  • Please log in to reply
2 replies to this topic

#1 creeker

creeker
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 15 September 2006 - 06:26 PM

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.



#2 creeker

creeker
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 15 September 2006 - 06:31 PM

I figured it out and it works. Sorry to waste your time

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 September 2006 - 07:33 PM

It's only a waste if you don't post "how" you figured it out.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users