Need help with php

Biter

I'm very new to php and know little or nothing about it, however, I have played with html and asp so I'm trying my best to figure it out.

Using Joomla, I have awards on my site. On my profiles, I have tabs that show the awards. Because my site is divided into different parts, I have different tabs for each part.

At the moment, I have the tabs working however ALL the awards are being displayed on all the tabs. (same awards on each tab) I'm trying to have the ability to put certain awards on certain tabs. I believe I'm am close to fixing this but I can't get it working.... "\n AND b.id IN (12, 13, 14)"; I was hoping that this line would help me.

I have included the section that deals with the awards.

$params = $this->params;
$return="";
$query = "SELECT *";
if ($ja_config['groupawards'])
$query .=", COUNT(a.id) AS count";
$query .= "\n FROM #jawards_awards AS a"
. "\n LEFT JOIN #jawards_medals AS b ON b.id = a.award"
. "\n WHERE a.userid=". $user->id
. "\AND b.id IN ('12','13','14')";

This is what I would like to happen. I select the award. The award is awarded to the member and 'put' on the tab of my choice, regardless of what award I pick.

Any suggestions at all would be greatly appreciated.

jeremyphphaven

the way I deal with the page thing is to re-build the URL (but that's because I'm a control freak).

not sure I understand the second part, got an example?

Biter

$return="";
$query = "SELECT *";
if ($ja_config['groupawards'])
$query .=", COUNT(a.id) AS count";
$query .= "\n FROM #jawards_awards AS a"
. "\n LEFT JOIN #jawards_medals AS b ON b.id = a.award"
. "\n WHERE a.userid=". $user->id
. "\AND b.id IN ('12','13','14')";

I found the error by trial and error in the last line.....over and over and over again.

this line should have read.....

. "\n AND b.id IN (12,13,14)";

It now works!.......thanks for your reply.