Re: [PHP-DB] recursion in php and mysql

2007-03-03 Thread Haydar TUNA
Hello, You can use class like the following code .:) Execute(); $query2 = new MySQLCommand ($sql2, $conn); $query2->Execute(); .. ?> "Micah Stevens" <[EMAIL PROTECTED]>, haber iletisinde sunlari yazdi:[EMAIL PROTECTED] > Classes are overrated. :) > > Bastien Koe

Re: [PHP-DB] recursion in php and mysql

2007-03-02 Thread Ron Croonenberg
I agree there. >>> Micah Stevens <[EMAIL PROTECTED]> 03/02/07 12:46 PM >>> Classes are overrated. :) Bastien Koert wrote: > you could make the connection variable global, but the best bet here > is to use a class and create a db object that your functions could call > > Bastien > > >> From: Ron

Re: [PHP-DB] recursion in php and mysql

2007-03-02 Thread Micah Stevens
Classes are overrated. :) Bastien Koert wrote: you could make the connection variable global, but the best bet here is to use a class and create a db object that your functions could call Bastien From: Ron Croonenberg <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] recursion

Re: [PHP-DB] recursion in php and mysql

2007-03-02 Thread Micah Stevens
It will complain if your query isn't returning any results. Check for that too. -Micah On 03/01/2007 09:36 PM, Ron Croonenberg wrote: 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; $

RE: [PHP-DB] recursion in php and mysql

2007-03-02 Thread Bastien Koert
you could make the connection variable global, but the best bet here is to use a class and create a db object that your functions could call Bastien From: Ron Croonenberg <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] recursion in php and mysql Date: Thu, 01 Mar 2007 23:52:54

Re: [PHP-DB] recursion in php and mysql

2007-03-01 Thread bedul
source result [, int result_type] ) - Original Message - From: "Ron Croonenberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Friday, March 02, 2007 12:36 PM Subject: Re: [PHP-DB] recursion in php and mysql Hi Micah, thanks I have a bunch of things working

Re: [PHP-DB] recursion in php and mysql

2007-03-01 Thread Ron Croonenberg
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:

Re: [PHP-DB] recursion in php and mysql

2007-03-01 Thread bedul
hmm.. i think there something going on on this func mysql_select_db($database) read more below == - Original Message - From: "Ron Croonenberg" <[EMAIL PROTECTED]> To: Sent: Friday, March 02, 2007 11:52 AM Subject: [PHP-DB] recursion in php

Re: [PHP-DB] recursion in php and mysql

2007-03-01 Thread Micah Stevens
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, $