[SOLVED] $column = mysql_fetch_row($stmt)[0]; why not?

[tivrfoa]

Hi folks!

 

This don't work: $column = mysql_fetch_row($stmt)[0];

I have to do this:

$row = mysql_fetch_row($stmt);

$column = $row[0];

 

:-\

Is there a way to do it in a less verbose way?

I think that the php guys should implement this in a new release. I'm using 5.2.5.

[Maq]

mysql_fetch_row returns an array, it isn't one.

 

I think that the php guys should implement this in a new release. I'm using 5.2.5.

 

Implement what?  Not sure what else there is to discuss here.

 

 

[haku]

$column = mysql_result($stmt, 0, 0);

 

That should do it for you.

[tivrfoa]

$column = mysql_result($stmt, 0, 0);

 

That should do it for you.

Thank you haku!

This is a very handy function!

mysql_fetch_row returns an array, it isn't one.

That's the problem, $column = mysql_fetch_row($stmt)[0]; should work.

[haku]

You're welcome.

 

That's the problem, $column = mysql_fetch_row($stmt)[0]; should work.

 

No, it shouldn't work at all. mysql_fetch_array() is not an array, it's a function. You can only call an index (ex: [0]) on an array. Functions don't have indexes. So you can't call an index on mysql_fetch_array(), as you are trying to call an index on a function.

 

The function returns an array. That means that the value it spits out is an array. The function itself isn't an array, only the value it produces. So you can call an index on $column, as it contains the value that mysql_fetch_array() gave it, but you cannot call an index on the function itself.

[tivrfoa]

you did'nt understand. here is a Java example.

 

public class MyArray {

public static String[] returnArray() {
	String[] newArray = {"Hello", "World"};
	return newArray;
}

public static void main(String[] args) {
	System.out.println(returnArray()[0]); // prints Hello. NO PROBLEM!!!
}
}

[Maq]

PHP is not Java.

[tivrfoa]

PHP is not Java.

Really ... I didn't know that.

 

Thats why I said that it will be good if this was implemented.

[Daniel0]

It's planned for PHP6.