[PHP-DB] Odd behavior

2004-04-03 Thread Michael Lewis
Okay, problem solved. I've been looking at the code for so long that it was too obvious to see. The "or die" was the culprit. Just a reminder that one should watch cutting and pasting. Thanks to anyone who used any brain time on this. Michael -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] odd behavior

2004-04-03 Thread Michael Lewis
I am having a very odd problem trying to encapsulate a library that isolates the underlying backend DB (I have to support both mssql and mysql with the same front end). I have isolated the offending code as follows: $resb=sql_QUERY($sql); $recds=num_ROWS($resb); When the num_ROWS rout

Re: [PHP-DB] Re: Tree structure - how to show only current branch ??

2004-04-03 Thread -{ Rene Brehmer }-
At 20:03 30-03-2004, you wrote: Well, I did a similar system for my CMS sollution. If I understand you correct you want to sort the main branch, keeping the subs. Not really ... I want to be able to expand the current sub to the current sub's level, list the subfolders contained within the curren

[PHP-DB] Re: Overhead on mylsam type mysql database

2004-04-03 Thread Piet from South Africa
Yes i have an autoincrement, but it only stands at 461 at this stage. "Piet From South Africa" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all > > I get a "overhead" in my mysql database, records are not getting inserted, > and it looks like, if i delete one another can be in

Re: [PHP-DB] Overhead on mylsam type mysql database

2004-04-03 Thread -{ Rene Brehmer }-
Do you have an auto-increment key field that's used up ??? ... As in no more free numbers in its positive range ??? Rene At 10:35 03-04-2004, you wrote: Hi all I get a "overhead" in my mysql database, records are not getting inserted, and it looks like, if i delete one another can be inserted.

[PHP-DB] Overhead on mylsam type mysql database

2004-04-03 Thread Piet from South Africa
Hi all I get a "overhead" in my mysql database, records are not getting inserted, and it looks like, if i delete one another can be inserted. This is what i see.Data 362,692 Bytes Index 5,120 Bytes Overhead 22,568 Bytes Effective 345,244 Bytes Total 367,812 Bytes Your he