Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Apr 2003
Posts: 30
User
User
Joined: Apr 2003
Posts: 30
I modified what you gave me initially to this:

Code
 SELECT t2.P_Name,t2.P_Title,t3.U_Number,t3.U_Username,t2.P_Option <br />FROM   w3t_PollData AS t1, <br />w3t_Polls AS t2, <br />w3t_Users AS t3 <br />WHERE  t1.P_Number = t2.P_Number <br />AND    t1.P_Name = t2.P_Name <br />AND    t2.P_Name  LIKE '%1093221487%' <br />AND    t1.P_IP = t3.U_Number <br />OR     t1.P_IP = t3.U_Username 


I knew the poll code for what I was looking for (started with 1093221487).

The MYSQL kept dieing. After a bit the server admin emailed and asked what the heck I was doing. I showed him this, and he said to do this instead:

Code
 SELECT t2.P_Name,t2.P_Title,t3.U_Number,t3.U_Username,t2.P_Option <br />FROM   w3t_PollData AS t1, <br />w3t_Polls AS t2, <br />w3t_Users AS t3 <br />WHERE  t1.P_Number = t2.P_Number <br />AND    t1.P_Name = t2.P_Name <br />AND    t2.P_Name  LIKE '%1093221487%' <br />AND    (t1.P_IP = t3.U_Number OR t1.P_IP = t3.U_Username); 


Which seems to work no problem.

He did also mention this:

"you can speed this query up by reducing size of the polls and pollsdata table"

Being that I think I already peeved him off because I was killing the server, what does that mean and what can I do?

Thanks again for the help.

Sponsored Links
Entire Thread
Subject Posted By Posted
Pulling Data from Polls with MYSQL query ... JasonStixBuckley 08/28/2004 3:45 PM
Re: Pulling Data from Polls with MYSQL query ... Twisty 08/28/2004 8:50 PM
Re: Pulling Data from Polls with MYSQL query ... JasonStixBuckley 08/28/2004 9:26 PM
Re: Pulling Data from Polls with MYSQL query ... JasonStixBuckley 08/28/2004 11:24 PM
Re: Pulling Data from Polls with MYSQL query ... Twisty 08/29/2004 5:05 AM
Re: Pulling Data from Polls with MYSQL query ... JasonStixBuckley 08/29/2004 5:31 AM
Re: Pulling Data from Polls with MYSQL query ... Twisty 08/29/2004 5:57 AM
Re: Pulling Data from Polls with MYSQL query ... Twisty 08/29/2004 11:30 AM
Re: Pulling Data from Polls with MYSQL query ... JasonStixBuckley 08/29/2004 8:32 PM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
• Shock Hosting
• Stable Host
• bluehost
• InterServer
Visit us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,834
Joined: January 2000
Forum Statistics
Forums63
Topics37,583
Posts293,957
Members13,826
Most Online151,614
Nov 14th, 2025
Today's Statistics
Currently Online 6013
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 14
Top Posters
AllenAyres 21,080
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,834
Greg Hard 4,625
Top Posters(30 Days)
isaac 2
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2026 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20261026)