I have a SQL statement that runs just fine when I echo the statement itself to the page and run it directly through PHPMyAdmin.
Here is the code I am using to run the SQL statement:
$result = mysql_query($sql);
$row = mysql_fetch_row($sql);
I've never had this problem before. The SQL statement is pretty complex. It pulls from 5 or 6 different tables so I've considered the possibility that it is timing out. I tried to add the set_time_limit() function to increase the timeout to 300 seconds. Didn't work.
So is there something that I have missed? What else should I look for?