what's wrong with this code??

[squawell]

hey could somebody tell me what's wrong with this code

PHP Code:

$hackviews = $DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread WHERE forumid=19');
$totalhackviews=number_format($hackviews[threadviews]); 


i want it like totalhackviews,but i can't write code so it not work

so what can i do make it work??

[FWC]

It looks like you're missing a ' in front of 19 and a " after 19'. I'm not sure if that will fix it or not, but it should.

[squawell]

Originally posted by FWC
It looks like you're missing a ' in front of 19 and a " after 19'. I'm not sure if that will fix it or not, but it should.

yes~~ur right!!

thankz man~~u give me a big help~~~

[FWC]

Glad to help.

[squawell]

now i have new problem

see this code

PHP Code:

$today = mktime(0,0,0,date("m"), date("d"), date("y"));
$getmembertoday=$DB_site->query_first("SELECT count(*) AS userid FROM user WHERE userid='$today'");
$todaymembers=number_format($getmembertoday[userid]); 


i want to count today registed member

so i do that code but no any error message~~

and it's not work too~~

which part is wrong??hope somebody help me~plz!!

[Admin]

$getmembertoday=$DB_site->query_first("SELECT count(*) AS userid FROM user WHERE joindate='$today'");

IIRC

[squawell]

thankz FireFly~~~

u also give me a big help too~~~

FireFly i find ur code have a little error

PHP Code:

$getmembertoday=$DB_site->query_first("SELECT count(*) AS userid FROM user WHERE joindate='$today'"); 


should be

$getmembertoday=$DB_site->query_first("SELECT count(*) AS userid FROM user WHERE joindate>='$today'");


and it will be work~~