Resource id #17

[Decode]

When i do

$sql = "SELECT COUNT(username) FROM user_sys";
$registered = mysql_query("$sql");
echo $registered; 

Its ment to cound the number of records in the username row in the user_sys table, but it just displays "Resource id #17". Ive never used SQL before so i dont know how to fix it

+rep for help

[Agnostic Bear]

When i do

$sql = "SELECT COUNT(username) FROM user_sys";
$registered = mysql_query("$sql");
echo $registered; 

Its ment to cound the number of records in the username row in the user_sys table, but it just displays "Resource id #17". Ive never used SQL before so i dont know how to fix it

+rep for help

$sql = mysql_query( "SELECT COUNT(`username`) FROM `user_sys`" );
$fetch = mysql_fetch_array( $sql );
echo( $fetch[0] );

should do it not used count() much so I don't know what it returns as

[Decode]

$sql = mysql_query( "SELECT COUNT(`username`) FROM `user_sys`" );
$fetch = mysql_fetch_array( $sql );
echo( $fetch[0] );

should do it not used count() much so I don't know what it returns as

It works Thanks +rep.

[Independent]

That seems pretty complex, there's a pre-made function for that already

mysql_list_fields.. This is what I did (After the database was connected)

$user = mysql_list_fields("nivade_core", "peepz"); // Database then Table. 

and the same for comments

[Agnostic Bear]

That seems pretty complex, there's a pre-made function for that already

mysql_list_fields.. This is what I did (After the database was connected)

$user = mysql_list_fields("nivade_core", "peepz"); // Database then Table. 

and the same for comments

That would list fields, not count.

[Independent]

That would list fields, not count.

Oh, I thought that he was counting fields.

[Agnostic Bear]

Oh, I thought that he was counting fields.

He is, listing fields gives the field names, not the count of them.