Jump to content

Archived

This topic is now archived and is closed to further replies.

Gappa

making this code MySQL 4.0.13 compliant

Recommended Posts

Can some one help me make this code MySQL 4.0.13 compliant...

 

 

 

[php:1:adb89efbc6]

 

<?php

$db = mysql_connect(\"localhost\", \"Gappa\", \" \");

mysql_select_db(\"Gappa\",$db);

 

 

$query = \'SELECT topic_title, topic_id, FROM_UNIXTIME(topic_time,\"%W the %D %M @ %r\") AS Topic_Date, post_text, username FROM phpbb_topics RIGHT JOIN phpbb_posts_text ON topic_first_post_id=post_id RIGHT JOIN phpbb_users ON topic_poster=user_id WHERE forum_id=6 ORDER BY topic_time DESC\';

$result = mysql_query($query, $db) or die ($query .\': \'.mysql_error());

 

 

while($row = mysql_fetch_assoc($result))

{

echo \"<br/><b><FONT FACE=Arial SIZE=-1 COLOR=#6699FF>\";

echo \"$row[topic_title]:</FONT></b><br/>\";

echo \"<FONT FACE=Arail SIZE=-2 COLOR=#999999>posted by: <b>$row[username]</b>\";

echo \" on: \";

echo \"$row[Topic_Date]</FONT><br/><hr><br/>\";

echo \"<FONT FACE=Arail SIZE=-1 COLOR=#FFFFFF> $row[post_text]</FONT>\";

echo \"<br/><br/>\";

echo \"<FONT FACE=Arial SIZE=-2>\";

echo \"<a href=\"http://www.hostultra.com/~Gappa/phpBB2/viewtopic.php?t=$row[topic_id]\"><b><FONT COLOR=#6699FF>Read comments</FONT></b></a></FONT>\";

echo \"<br/><br/>\";

}

 

 

 

?>

[/php:1:adb89efbc6]

 

 

 

This code works with earlier version of MySQL, but now with 4.0.13 its giving me the following error

 

Cross dependency found in OUTER JOIN. Examine your ON conditions

 

I believe the solution lays some where here: http://www.mysql.com/doc/en/JOIN.html

 

Not really sure what to do... thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.