>>$row = mysql_fetch_array($result, $connection);
this is the problem
you should type
$row = mysql_fetch_array($result, MYSQL_NUM);
there not such things as $connection on the mysql_fetch_array
in mysql_query.. u use that connection.. but not in fetch array
array mysql_fetch_array ( resource result [, int result_type] )
----- Original Message -----
From: "Ron Croonenberg" <ronc@xxxxxxxxxx>
To: <micah@xxxxxxxxxxxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Friday, March 02, 2007 12:36 PM
Subject: Re: recursion in php and mysql
Hi Micah,
thanks I have a bunch of things working now.
mysql_fetch_array() is complaining.
I use it like this:
function recursive() {
global $connection;
$result = mysql_query("SELECT * FROM $table WHERE bthb4='$bthb4'",
$connection);
$row = mysql_fetch_array($result);
}
the error I got was:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in recursion.php on line 93
I tried: $row = mysql_fetch_array($result, $connection);
But I have the impression that $result now isn't correct anymore ?
the mysql_fetch_array() is the only function (so far) that complains ?
thanks for your earlier very quick response,
Ron
>>> Micah Stevens <micah@xxxxxxxxxxxxxxxxxx> 03/02/07 12:04 AM >>>
Yep, just put the connect function outside your recursive loop. You can
then access the connection that is returned by the connect function by
making it global, or passing it by reference by the recursive function.
In other words:
$connection = mysql_connect(....);
mysql_select_db($database, $connection);
recursive_function($value);
function recursive_function($value)
{
global $connection;
$data = mysql_query($sql, $connection);
recursive_function($data);
}
... or something.. you get the picture.
-Micah
On 03/01/2007 08:52 PM, Ron Croonenberg wrote:
> Hello all,
>
> I wrote an app in php and it uses recursion.
>
> Problem I have is that when I connect to a database using
> mysql_connect($dbhost, $username, $password); and select a table with
> mysql_select_db($database) I cannot access the table anymore from some
> function.
>
> Now I can connect and select a database in that php function but that
> means that process happens A LOT and connecting and selecting everytime
> probably slows down the app quite a bit
>
> Is there a way to connect to a database and select a table "globally"
> so that I have access to it in ever php function I write ?
>
> thanks,
>
> Ron
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
