complex function in php for ticker

hi
i am fetching values from the database previously i have fetched single values which works perfectly fine but now i want to fetch multiple columns of the same row once fetched i need to put this in the ticker
as with the below function i can fetch username but i also want to fetch sum(category) and display next to fetched user name i don't understand how to put the 2nd column next to the username .$get['username'].  which is sum(category)


function ticker_user_trivia ()
{
 
 
	
	$query = mysql_query("SELECT distinct quiz, sum(category),username   FROM codes WHERE timestamp > unix_timestamp(now()) - 300 ");
	$trivia= '';
	while($get = mysql_fetch_array($query)) {
		if(_SEOMOD == 1) 
			$caturl = _URL."/browse-".$get['tag']."-videos-1-date.html";
		else
			$caturl = _URL."/category.php?cat=".$get['tag'];
 
		if($get['id'] == $selected){
		$trivia.= "<li class=\"selectedcat\"><a href=\"".$caturl."\">user scored \n".$get['username']. "\nlogged \n in</a></li>"; //seo links
		} else {
			
		$trivia.= "<li><a href=\"".$caturl."\">".$get['username']. "</a></li>"; 
		echo "logged in";
		//seo links
		}
	}

Open in new window

LVL 11
mattibuttAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
LinuxNubbConnect With a Mentor Commented:
OK.  Now if you give your sum(category a name in the query, like ... SUM(category) as category, that array will show that field as category.

Then, you should be able to place the . $get['category'] in your output statement.
0
 
LinuxNubbCommented:
$trivia.= "<li><a href=\"".$caturl."\">".$get['username']. " " . $get['category'] . "</a></li>";
0
 
mattibuttAuthor Commented:
hi LinuxNubb
i have tried that it doesnt work plus i need to the subtotal of category field
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
LinuxNubbCommented:
define your sum as a value then:

$query = mysql_query("SELECT distinct quiz, sum(category) as category ,username   FROM codes WHERE timestamp > unix_timestamp(now()) - 300 ");

If you're trying to create a sum of a bunch of rows, and also get the values of individuals rows, it's not going to work.
0
 
mattibuttAuthor Commented:
hi LinuxNubb
i only want to fetch two cloumn fetch the username based the query and next to it the sum of category field when i run this query from the mysql it does work but problem is in the above php function
0
 
LinuxNubbCommented:
You can test the output of the query by placing a line in the loop:

print_r($get);

This will show you exactly what the $get array is populated with.
0
 
mattibuttAuthor Commented:
hi
it doesnt print anything
0
 
LinuxNubbCommented:
Where did you place it?  Put it right under:

while($get = mysql_fetch_array($query)) {
   print_r($get);
0
 
mattibuttAuthor Commented:
ok sorry done that the following is shown
Array ( [0] => 040309185100 [quiz] => 040309185100 [1] => 902 [sum(category)] => 902 [2] => nows [username] => nows )
0
 
mattibuttAuthor Commented:
thanks buddy its done
0
 
mattibuttAuthor Commented:
thanks
0
 
LinuxNubbCommented:
Very good!  Good luck with the rest!
0
All Courses

From novice to tech pro — start learning today.