[SOLVED] Multiple use of the same code

[everlifefree]

OK, here the working code I have now:

// COUNT ALL VIDEO POSTS ///////////////////////////////////////////////////////////
$selectCount = myQ("SELECT SQL_CALC_FOUND_ROWS * 
FROM `[x]video` 
WHERE `user`='".me('id')."' ");
$countRowsSelectCount = myQ("SELECT FOUND_ROWS()");
$countRowsResultCount = mysql_fetch_row($countRowsSelectCount);
$totalRowsCount = $countRowsResultCount[0];

$tpl -> AssignArray(array(
	"video.total" => $totalRowsCount,
));

 

But I would like to make it so I can count 7 different things and I believe the array and everything will get mixed up unless I change each one a little bit. Please Help Let Me Know What I Need To change sorta like: $totalRowsCount = $countRowsResultCount[0]; is changed to $totalRowsCountG = $countRowsResultCountG[0]; or something like that...

 

One example of the 7 different things you could use this one to show me what I need to change and all

 

// COUNT ALL GALLERY POSTS ///////////////////////////////////////////////////////////
$selectCount = myQ("SELECT SQL_CALC_FOUND_ROWS * 
FROM `[x]gallery` 
WHERE `user`='".me('id')."' ");
$countRowsSelectCount = myQ("SELECT FOUND_ROWS()");
$countRowsResultCount = mysql_fetch_row($countRowsSelectCount);
$totalRowsCount = $countRowsResultCount[0];

$tpl -> AssignArray(array(
	"gallery.total" => $totalRowsCount,
));