This is driving me nuts, please tell me is this a bug or a problem wiht my
jappz_guestbook(owner_cno, sent_datetime, is_secret, accepted)
jappz_guestbook's owner_cno and jappz_member_profile's cno are the same
what i need to do is select * from jappz_guestbook where owner_cno=x and
only select pic_name from jappz_member_profile where cno=jappz_guestbook.cno
This is my query:
pic1 FROM jappz_guestbook
INNER JOIN jappz_member_profile ON jappz_guestbook.owner_cno =
WHERE jappz_guestbook.owner_cno = jappz_member_profile.cno order by
from_cno DESC limit 0,30
I am getting 4 results:
from_cno from_usernam sent_datetime is_secret accepted
1 r 2005-05-01 00:03:14 0
1 r 2005-05-01 00:04:09 1
3 ryana3 2005-05-01 01:15:57 0 0
3 ryana3 2005-05-01 01:16:06 1 0
which is wrong because "pic1" for "from_cno" should be "r.jpg" but its
somehow "cacheing" the above.
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005
|• Bug or query problem?||Ryan A||1 May|