[Axe]

Okies, so here's the basic idea..

PHP Code:

function myfunc() {

  $sql = 'select * from table where field1="1"';

  $result = mysql_query($sql);

  $row = mysql_fetch_assoc($result);

  return $row;

}



$somevar = myfunc(); 

Now, you can guess what I want to do... I want the results of that row stored in $somevar, so that I can call $somevar['fieldname1'], $somevar['fieldname2'], etc..

But it's telling me...

Code:

Fatal error: Call to undefined function: array() in /home/blah/blah/blah/blah/whatever.php on line 9

Line 9 being $somevar = myfunc();

I've not tried doing this before, so I'm not sure quite how to go about it, or exactly what to hit google with to find the results I desire.

Does anybody know how to write this so I can have a function pull a row from a MySQL table, then have that function pass it back to a $variable, so that I can just call the values by $variable['whatever'] ?

Thanks.

[blaw]

Hi there,

I've found this:

http://www.phpbuilder.com/lists/php-...99911/0889.php

Also when you get this fatal error, the first thing you want to do is to check if you've mistyped the function's name upon calling/defining.

Hope this helps.

[Axe]

Thanks, this is running on a Linux box.

Apache 1.3.28/PHP 4.3.3

[NeverMind]

are you naming your function array ?
you can't override a reserved function name that the core php use .. try renaming it to another name like array_ for example ..

[Axe]

Never mind, I'm an idiot

The example there isn't EXACTLY like my live-script, and the problem isn't with the function. The function works flawlessly, the problem was with the way my script calls it...

My real function has a parameter that is passed to the MySQL statement, no problem. I was incorrectly passing the session variable to the function so that's why it was messing up...

I was calling $_SESSION('whatever') instead of $_SESSION['whatever']

Fixed that and all is working

[jv2222]

Hi,

It may help you to tie up a number of sql functions into a class.. kinda like ezSQL.

Cheers,
Justin

[axelmangr]

Originally Posted by Axe

Okies, so here's the basic idea..

PHP Code:

function myfunc() {

  $sql = 'select * from table where field1="1"';

  $result = mysql_query($sql);

  $row = mysql_fetch_assoc($result);

  return $row;

}



$somevar = myfunc(); 

Now, you can guess what I want to do... I want the results of that row stored in $somevar, so that I can call $somevar['fieldname1'], $somevar['fieldname2'], etc..

But it's telling me...

Code:

Fatal error: Call to undefined function: array() in /home/blah/blah/blah/blah/whatever.php on line 9

Line 9 being $somevar = myfunc();

I've not tried doing this before, so I'm not sure quite how to go about it, or exactly what to hit google with to find the results I desire.

Does anybody know how to write this so I can have a function pull a row from a MySQL table, then have that function pass it back to a $variable, so that I can just call the values by $variable['whatever'] ?

Thanks.

Hi!

I am trying to do something similar to what you where trying to do. I wouldlike to create a procedure that takes as input a table name and returns the data contained on this table. It seems that I cannot do that. I've tried almost everything.... I could use some help from how you solved your problem!
I would appreciate any help you could provide me with

thanx a lot
axelmangr