List:General Discussion« Previous MessageNext Message »
From:Ryan A Date:April 30 2005 11:50pm
Subject:Bug or query problem?
View as plain text  
Hi,
This is driving me nuts, please tell me is this a bug or a problem wiht my
query:

jappz_guestbook(owner_cno,  sent_datetime,  is_secret,  accepted)
jappz_member_profile(cno, pic_name)




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:
SELECT
from_cno,from_usernam,sent_datetime,is_secret,accepted,jappz_member_profile.
pic1 FROM jappz_guestbook
INNER JOIN jappz_member_profile ON jappz_guestbook.owner_cno =
jappz_member_profile.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
pic1
1                 r                     2005-05-01 00:03:14     0
0             s.jpg
1                 r                     2005-05-01 00:04:09     1
0             s.jpg
3                 ryana3            2005-05-01 01:15:57     0             0
s.jpg
3                 ryana3             2005-05-01 01:16:06    1             0
s.jpg


which is wrong because "pic1" for "from_cno" should be "r.jpg" but its
somehow "cacheing" the above.

Please advise.

Thanks,
Ryan A




-- 
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

Thread
Bug or query problem?Ryan A1 May