ThinkDing  

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


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-21-2005, 09: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
  #2  
Old 11-23-2005, 10:17 PM
Winston Winston is offline
Administrator
 
Join Date: Jul 2005
Posts: 46
Default

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
Reply


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 01:09 PM.


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