function returns an array

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
davidrowlinson
Forum Newbie
Posts: 1
Joined: Mon Nov 24, 2003 7:01 pm

function returns an array

Post by davidrowlinson »

New to PHP, but what is wrong with this syntax...

$some_column = mysql_fetch_array($sql)['a_column'];

or, more explicitly

$some_column = (mysql_fetch_array($sql))['a_column'];


David
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

Post by DuFF »

It should be more like this:

Code: Select all

$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "SELECT * FROM table";
$result = mysql_query($query);
while ($r = mysql_fetch_array($result))
{
$some_column = $r['a_column'];
}
mysql_close();
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

Function return value doesn't gets dereferenced in php4. So you have to use intemediate variable to store return value and then use it:

Code: Select all

$some_column = mysql_fetch_array($sql);
$some_column = $some_column['a_column'];
Briefly, this:

Code: Select all

$some_column = mysql_fetch_array($sql)['a_column'];
syntax isn't allowed in php4.
Post Reply