Fetch array question

Blackbrain · 12-02-2007, 03:41 PM

Suppose if there are two row match the following statement. Will fetch array syntax return the exact value or will decrease the value by 1 because they start from 0

$result = mysql_query("SELECT COUNT(*) AS numrows FROM MEMBERS WHERE interest = '$inte' AND age < $age") or mysql_error();
$row = mysql_fetch_array($result);

$number = $row[noofrows];

WILL IT BE 2 OR 1.

Wildhoney · 12-02-2007, 04:02 PM

It will be 2 because it is counting - and thus it needs to return a value that can be understood by humans. Although array indexes begin with a 0, if you were to call the count then it would return 2.

I can't think of any intellectual way to put this, maybe someone else can put it better than me. But array indexes start at 0, counting starts at 1.

If it were to return 0 for 1 item, what would no items return?

maZtah · 12-02-2007, 10:47 PM

You make it an associative array, so you don't need to have any numbers involved. Instead, you're using the name of the result (numrows). Hope that makes any sense!

Let me clearify with an example..

First we try it with a numeric array:

PHP Code:


			
$pResult = mysql_query("SELECT COUNT(*) AS NumberOfResults FROM MEMBERS WHERE interest = '$inte' AND age < $age") or mysql_error();

$aRow = mysql_fetch_array($pResult, MYSQL_NUM);



$iNumber = $aRow[0];

echo $iNumber;

// Would echo 2 in this case

Now make it an associative array:

PHP Code:


			
$pResult = mysql_query("SELECT COUNT(*) AS NumberOfResults FROM MEMBERS WHERE interest = '$inte' AND age < $age") or mysql_error();

$aRow = mysql_fetch_array($pResult, MYSQL_ASSOC);



$iNumber = $aRow['NumberOfResults'];

echo $iNumber;

// Would also echo out 2

Hope this helps you out :)

Haris · 12-03-2007, 02:02 AM

The array indexes starts from 0. The values don't.

A value of 0 should be logically "no rows returned".

Blackbrain · 12-03-2007, 08:59 AM

Thank you for your help. Since i was quite away from php certain basic things are bugging me. One of the top is:

--> When we define a query like $result = mysql_query("Query") or die();

Do we need to initialize it by the if function or will php automatically initiliazes the $result query.

Haris · 12-03-2007, 09:13 AM

Quote:

Originally Posted by Blackbrain

Thank you for your help. Since i was quite away from php certain basic things are bugging me. One of the top is:

--> When we define a query like $result = mysql_query("Query") or die();

Do we need to initialize it by the if function or will php automatically initiliazes the $result query.

PHP automatically executes the query as soon as you want it to.

SOCK · 12-04-2007, 07:23 AM

Haris is correct, but I think everyone is overlooking a crucial detail; you're only retrieving one row, the value of the COUNT. Regardless of how many records match that SQL statement, there will only ever be one row. Therefore the value will always be accessed at the first index, '0'.

It's wasteful to use fetch_array on a statement like this anyway - use mysql_result() instead.