February 17th, 2004, 11:26 PM
|
|
|
|
Join Date: Apr 2007
Location: Montreal, Quebec, Canada
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Query jamming mySQL
Hello,
I've been trying to optimise some parts of my site by combining sql calls with join statements. However, I've been having problem with one.
mySQL returns no errors when I try to run it. On my web page, it simply return null for all the fields in the members table. When I try to run the statement with phpmyadmin, the server locks up and doesn't answer anymore.
Here's the sql call :
php Code:
 Original
- php Code |
|
|
|
SELECT post1.ReplyCount, post1.Hits, post1.Sujet, post1.Texte, post1.CheckComment, post1.CheckVote, post1.CheckMature, post1.Author, post1.PostDate, post1.ModifiedBy, post1.ModifiedDate, members.ppcheck AS ppcheck, members.ppfl AS ppfl, members.ppurl AS ppurl, members.FavSaying AS FavSaying, members.ICQ AS ICQ, members.WWW AS WWW, members.UserName AS UserName, members.signature AS signature, members.AccountType AS AccountType, members.PoemCount AS PoemCount, members.CommentCount AS CommentCount, members.Level AS niveau, loggedin.IP AS IP FROM post1 RIGHT JOIN members ON members.ID = post1.Author RIGHT JOIN loggedin ON loggedin.username = post1.Author WHERE post1.ID = 9797 LIMIT 0 , 1
Any help greatly apreciated.
Thanks,
Francois.
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
