Skip navigation links

MySQL Forums :: Database Design & Data Modelling :: MySQL Query Help


Advanced Search

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 shai perednik 03/30/2008 04:27PM
Re: MySQL Query Help Peter Brawley 04/08/2008 11:24AM
Re: MySQL Query Help patrick ladislav 04/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.