Go Back   ThinkDing > Member Forums > "How Do I..." Questions
Acceptance Mark
User Name

Thread Tools Search this Thread
Old 11-21-2005, 10:51 PM
aoneill aoneill is offline
Junior Member
Join Date: Nov 2005
Posts: 4
Default Echo SQL Query

Hi Winston,

Is there an easy way to print the SQL query that is being sent to the server? It appears that the query is derived both within index.php and functions.php.

For your info - I'm now using your script successfully (with LIKE queries switched off) on a 270Mb table with 90,000 records. It's returning results in < 0.3 secs.

Many thanks for your help.
Reply With Quote
Old 11-23-2005, 11:17 PM
Winston Winston is offline
Join Date: Jul 2005
Posts: 46

Hi, in tdSearch.php find $numresults = null; and afterwards echo out $sql_query (this doesn't have on the ORDER BY / LIMIT parts of the query). If you want the latter, you'll need to COPY $results = mysql_query("THE STUFF IN HERE",$connect); and set it in its own variable to echo onscreen.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT. The time now is 10:07 AM.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.