I modified what you gave me initially to this:
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:
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.