Luth

Both Kickstart and Roopurt's first select statements worked peachy. Thanks much.

Wow. Okay, I could follow the first one, but that second one throws me for a loop. :-) At any rate, I'll try them and get back to you. Cheers.

That is what I've done, and done an array merge in PHP to combine the results. If there is no way to do them in one operation, then I guess that's as good as it gets, hm? Thank you.

Is there any more information that I could provided that would assist you in assisting me with this hang-up? I'm afraid I haven't yet found a solution elsewhere, either. Kind regards.

I'm making a heavy duty mod to PHPBB, and it's pushing my limited knowledge of MySQL (5.0). What I want is to select: 1) everything from phpbb_topics [phpbb_topics.*], 2) the user email associated with the first poster [phpbb_users.user_email as first_poster_email], 3) the user email associated with the last poster [phpbb_users.user_email as last_poster_email]. The closest thing I've got is: SELECT t.*, phpbb_users.user_email as first_poster_email FROM ( phpbb_topics t ) LEFT JOIN phpbb_users ON t.topic_poster=phpbb_users.user_id Obviously it's lacking, as there's not even a bit for selecting the last poster email. The user id's are stored in phpbb_topics as 'topic_poster' and 'topic_last_poster_id'. I'm not sure how to proceed with this. Any help would be nice, or even just pointers in the right direction. Cheers.

$host = "66.90.103.76"; $port = "8236"; $fp=fsockopen($host,$port,&$errno,&$errstr,10); if (!$fp) { echo "Can't connect: ($errno) $errstr"; exit; } Always fails: Warning: fsockopen(): unable to connect to 66.90.103.76:8236 in [yadda yadda yadda] Can't connect: (110) Connection timed out as seen here: http://www.almostinteractive.com/GVR/stats.php But if you put that address "66.90.103.76:8236" into your browser, it'll connect just fine, as seen here: http://66.90.103.76:8236 Why cant fsockopen connect, do you think? I've been able to open connections to other sites from this script by changing the host/port parameters, yet this one seems most uncooperative.

I have a PHP script that does various mysql queries, and at the very end, echos a return message to the browser: echo($ret); return; Most of the time, that works fine. But sometimes, for some return messages, it just hangs up and wont echo anything. So I put: echo($ret); flush(); return; And it worked, but now there's an extra "\n\n0\n\n\n" (newline chars, zero, newline chars) thats echo'd out. Whats causing it, and how do I fix this problem?

Yeah, I went to bed, slept 8 hours, got back up, same result. :-/ 'The Forest' causes it to hang, but simply write ' Scary' after "The" (making it 'The Scary Forest'), and do NOTHING ELSE, and its fine. No hangups, no freezing, all A-OK. :-/ SQL just doesnt like The Forest.

No one's ever had a case where INSERTing into a table caused a freeze up? I cant imagine that I'm the only one to ever encounter this would-be bug. [img src=\"style_emoticons/[#EMO_DIR#]/unsure.gif\" style=\"vertical-align:middle\" emoid=\":unsure:\" border=\"0\" alt=\"unsure.gif\" /]

I've got a head scratcher for you. I was adding values into my rooms table from a php script that read a Rooms.txt file, created the query statement, and called mysql_query. The final room in Rooms.txt was "The Forest". When it got to INSERTing that room, it would freeze forever. If I did the SQL query by hand (via phpmyadmin), it would accept it, but not if I called it from the PHP script. Here's the statement that would hang forever: INSERT INTO `rooms` ( `ID` , `Name` , `Description`, `Exit_1` ) VALUES ( 5, 'The Forest', 'Its dangerous to be out here alone. Who knows what could be lurking to eat up a small child like you.', 0 ) So here's the confusing part: If I change "The Forest" to ANYTHING else (such as "Forest" or "The Scary Forest"), it works. IE, this worked: INSERT INTO `rooms` ( `ID` , `Name` , `Description`, `Exit_1` ) VALUES ( 5, 'The Scary Forest', 'Its dangerous to be out here alone. Who knows what could be lurking to eat up a small child like you.', 0 ) This worked too: INSERT INTO `rooms` ( `ID` , `Name` , `Description`, `Exit_1` ) VALUES ( 5, 'The Scary Forest', 'Its dangerous to be out here alone. Who knows what could be lurking to eat up a small child like you.', 0 ) Why on earth would, specifically, 'The Forest' cause the query to hang up indefinately, do you think?