MySQL Query Help
Posted by: shai perednik
Date: March 30, 2008 04:27PM

Hi Everyone. Thanks ahead of time for the help.

I'm running the following code:
include 'includes/config.php';
include 'includes/opendb.php';

mysql_select_db($dbname) or die(mysql_error());
mysql_connect($dbhost,$dbuser,$dbpass);
$result = mysql_query("
	SELECT
		lo.ID_MEMBER, lo.logTime, mem.realName, mem.memberName, mem.showOnline,
		mg.onlineColor, mg.ID_GROUP
	FROM log_online AS lo
		LEFT JOIN members AS mem ON (mem.ID_MEMBER = lo.ID_MEMBER)
		LEFT JOIN membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))", __FILE__, __LINE__);

	//Close the DB connection
	include 'includes/closedb.php';

When I run the php in the browser I get this error:
Warning: Wrong parameter count for mysql_query() in /home/shaiss/public_html/ocmotomobile/whosonline.php on line 30

Any ideas why I'm getting this error?
Thank you again for the help!

Options: ReplyQuote


Subject
Written By
Posted
MySQL Query Help
March 30, 2008 04:27PM
April 08, 2008 11:24AM
April 11, 2008 06:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.