Re: Error with MySQL Table Join

Article View: adobe.golive.windows

Article #37708

Back to adobe.golive.windows Previous Next

#37708

From: LenHewitt
Date: Fri, 10 May 2002 23:28

5 lines
1091 bytes

Julian, 

When MySQL errors show, it is often useful to put in a PRINT("$my_query"); line before the query is executed then you can clearly see exactly what query string is being passed to the database.  

This will clearly show if you are passing an empty argument somewhere in the query which is about the most common cause for queries failing.

Technical Details

Message-ID: <ef87669.0@WebX.aaQKaf7vad4>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!WebX

References: <ef87669.-1@WebX.aaQKaf7vad4>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101ba1,daa11345f2a1ce7a
X-Google-Attributes: gid101ba1,public
X-Google-ArrivalTime: 2002-05-10 16:37:33 PST
From: LenHewitt <anon@anon.co.uk>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.golive.windows
Subject: Re: Error with MySQL Table Join
Message-ID: <ef87669.0@WebX.aaQKaf7vad4>
Date: Fri, 10 May 2002 16:28:39 -0700
References: <ef87669.-1@WebX.aaQKaf7vad4>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message