Small Hack

How Do I List Diff Users Count On Main Page

Platinum Members: ?
Platinum+ Members: ?
Moderators: ?
Super Moderator: ?
Administrators: ?

How Do I Fill In The "?"'s

i know it's a templat edit, but what coding is required for it to work?

[Logitech-2004]

Parse error: parse error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /var/www/html/platinum/index.php on line 25

code
$3M1=$DB_site->query_first("SELECT * FROM '3MStatus' WHERE '3M1'");
$3M2=$DB_site->query_first("SELECT * FROM '3MStatus' WHERE '3M2'");
$3M3=$DB_site->query_first("SELECT * FROM '3MStatus' WHERE '3M3'");
$3M4=$DB_site->query_first("SELECT * FROM '3MStatus' WHERE '3M4'");

[Logitech-2004]

any one????

[Logitech-2004]

$M1=$DB_site->query_first("SELECT * FROM 3MStatus WHERE Index = 3M1");
$M2=$DB_site->query_first("SELECT * FROM 3MStatus WHERE Index = 3M2");
$M3=$DB_site->query_first("SELECT * FROM 3MStatus WHERE Index = 3M3");
$M4=$DB_site->query_first("SELECT * FROM 3MStatus WHERE Index = 3M4");

Still Get Errors
Database error in vBulletin 2.3.3:

Invalid SQL: SELECT * FROM 3MStatus WHERE Index = 3M1
mysql error: You have an error in your SQL syntax near 'Index = 3M1' at line 1

mysql error number: 1064

[Logitech-2004]

$M1=$DB_site->query_first("SELECT * FROM 3MStatus WHERE 3M1 = '3M1'");
$M2=$DB_site->query_first("SELECT * FROM 3MStatus WHERE 3M2 = '3M2'");
$M3=$DB_site->query_first("SELECT * FROM 3MStatus WHERE 3M3 = '3M3'");
$M4=$DB_site->query_first("SELECT * FROM 3MStatus WHERE 3M4 = '3M4'");

This Dosen't Cause erros! But It Dosn't READ The Text Stored in the col's

[Logitech-2004]

hummm i stumped them

[Darkwaltz4]

$saved_array = $DB_site->query_first("SELECT col1,col2,col3 FROM table_name WHERE col1='value'");

firstly, this will grab the data in 'col1', 'col2', and 'col3' from the table called 'table_name'
where the col1 has the data 'value' in it. (wow, you can just read the query and get the same sentence as above ~_~)

however, the $saved_array contains the information similar to the query itself. it saves the data grabbed from each column, where col='value', and the keys of the var, are named based on the requested columns.

so, $saved_array[col1] would have the data that col1 had at col1='value'

~_~ okay, im starting to confuse myself(its a million times easier to do it yourself then explain how :-p), and i hope you arent further confused. maybe if you gave me all that your working with, i still dont know what it is your trying to do...