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.