Error on script

[Worldwide]

I'm using this online user script but i get an error which i tired everything to fix and nothing works.  :'(

 

<?php

//first you need to define db info

  define('mySQL_hostname', '127.0.0.1');  //database IP

  define('mySQL_database', '');  //database name

  define('mySQL_username', '');  //database user

  define('mySQL_password', '');  //database password

 

//connects to mysql

  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )

    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

 

//connects to Database

  $db_select = mysql_select_db( mySQL_database, $db_link )

    or die( 'Error connecting to Database<br><br>'.mysql_error() );

 

//selects desired table

  $chars=mysql_query("SELECT * FROM characters");

 

//tells how much rows are there (will come helpfull with while loops)

    $rows =mysql_numrows($characters);

 

  $i=0;

  $x=0;

 

//while $i is smaller than number of rows repeat the code

  while ($i < $rows) {

    $online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i

    if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x

    $i++; //increase $i

    }

  print 'Online players: <em>'.$x.'<em>'; //prints out the $x number of players online

?>

 

 

 

 

ERROR:

[frenchpl]

Hi there

The line that reads :-  $rows =mysql_numrows($characters);

Should read $rows = mysql_numrow($chars);

 

This is returning a count of the number of rows found in your search.

You are trying to use the table name here instead of the variable.

[Worldwide]

I tired that an my error was this : Fatal error: Call to undefined function mysql_numrow() in C:\xampp\htdocs\server.php  on line 20

[frenchpl]

Sorry, my fault, finger trouble there. I missed the 's' off of the end of the function name.

 

mysql_numrows($chars);

 

[Worldwide]

Thanks so much. =)