[PHP-DB] Bug in interbase.c (Ver. 5.2.6) INVALID BLOB ID

2008-11-27 Thread Benjamin Schwarze
Hi! Ay many other users recognized, there is a bug in the implementation of the function _php_ibase_quad_to_string. (imho since version 5.2.1) The line spprintf(result, BLOB_ID_LEN+1, 0x%0* LL_MASK x, 16, *(ISC_UINT64*)(void *) qd); doesnt work as estimated. The result stored inside qd isnt

[PHP-DB] re:database tables relations advice

2008-11-27 Thread mrfroasty
I am quite new to database designs, I have a problem in my design...I can actually feel it, but I am not quite sure if there is a feature in mysql or I have to solve it with programming. Example: CREATE TABLE A ( user_id int(16) NOT NULL auto_increment,

Re: [PHP-DB] re:database tables relations advice

2008-11-27 Thread danaketh
This is solved by using FOREIGN KEY but I'm not sure if MySQL have them present or just planned for some future release. mrfroasty napsal(a): I am quite new to database designs, I have a problem in my design...I can actually feel it, but I am not quite sure if there is a feature in mysql or I

Re: [PHP-DB] re:database tables relations advice

2008-11-27 Thread mrfroasty
maruti wrote: hey lemme knoe, how many columns are you planning for? y not put table B columns in table A?? if you are least bothered about data normalizations, simply go the way you want to. userId Name Age Age Sex Occupation Location all the data which has correspondence with userid can

Re: [PHP-DB] re:database tables relations advice {solved}

2008-11-27 Thread mrfroasty
danaketh wrote: This is solved by using FOREIGN KEY but I'm not sure if MySQL have them present or just planned for some future release. mrfroasty napsal(a): I am quite new to database designs, I have a problem in my design...I can actually feel it, but I am not quite sure if there is a

Re: [PHP-DB] MySQLi not closing connections

2008-11-27 Thread Jonathan Langevin
I was thinking the same bug, except that I'm not using real_connect (pass login params when initializing the class), and also the issue only occurs when logging is enabled. I'm really at a loss here :-\ -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Wed, Nov 26,

RE: [PHP-DB] re:database tables relations advice

2008-11-27 Thread Fortuno, Adam
Mr. Froasty, From your note, it sounds like you want to use foreign keys; as Daniel pointed out. I think an example would be helpful here. The subject of foreign keys is bigger than a bread box so I'll just touch on the pieces I think you'll find helpful. There is all sorts of literature

Re: [PHP-DB] re:database tables relations advice

2008-11-27 Thread Bastien Koert
On Thu, Nov 27, 2008 at 1:36 PM, Fortuno, Adam [EMAIL PROTECTED]wrote: Mr. Froasty, From your note, it sounds like you want to use foreign keys; as Daniel pointed out. I think an example would be helpful here. The subject of foreign keys is bigger than a bread box so I'll just touch on the

Re: [PHP-DB] Bug in interbase.c (Ver. 5.2.6) INVALID BLOB ID

2008-11-27 Thread Chris
Benjamin Schwarze wrote: Hi! Ay many other users recognized, there is a bug in the implementation of the function _php_ibase_quad_to_string. (imho since version 5.2.1) The line spprintf(result, BLOB_ID_LEN+1, 0x%0* LL_MASK x, 16, *(ISC_UINT64*)(void *) qd); doesnt work as estimated. The

[PHP-DB] Value of $_POST['submit']

2008-11-27 Thread Ron Piggott
I am working on the following web page tonight: http://www.actsministrieschristianevangelism.org/verseoftheday/ I am trying to program the Load Previous Issue Random Issue and Load Next Issue buttons. I am using Ajax to pass the date the user is requesting to the PHP script for processing. I

Re: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread Yves Sucaet
Hi Ron, What's your Javascript client-side code to invoke the PHP-script? You may need to switch to $_GET[] instead of $_POST... Yves - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Sent: Thursday, November 27, 2008 7:02 PM Subject: [PHP-DB]

RE: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread Martin, Steve (MAN-Corporate)
When I'm developing a number of pages and don't keep track of every variable or form name (etc), I plant a print_r($_POST); at the top of the page, so there's no guessing what gets sent to the page . . . If you have an empty $_POST array, then the form isn't using action=post, or you didn't code

RE: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread YVES SUCAET
Hi Steve, He's using Ajax, so some variant of the XMLHttpRequest Javascript object on the client. It may not be obvious which method is used when the data is sent. Now that I think of it, printing $_SERVER[REQUEST_METHOD] should let you know which one is being used. hth. Yves -- Original

Re: [PHP-DB] Bug in interbase.c (Ver. 5.2.6) INVALID BLOB ID

2008-11-27 Thread Benjamin Schwarze
Thank you for this hint. Chris schrieb: Benjamin Schwarze wrote: Hi! Ay many other users recognized, there is a bug in the implementation of the function _php_ibase_quad_to_string. (imho since version 5.2.1) The line spprintf(result, BLOB_ID_LEN+1, 0x%0* LL_MASK x, 16, *(ISC_UINT64*)(void

[PHP-DB] Re: Help to create multiple referrals using php and mysql

2008-11-27 Thread Mohan L
Dear All, I have one requirement to create multiple referral for my project .I found some information from php-db archive .I follow the same to design the database .here is the my data base information This the query used to create table: mysql create table customers ( cust_id int unsigned not

[PHP-DB] Fwd: Help to create multiple referrals using php and mysql

2008-11-27 Thread Mohan L
Dear All, I am new to this mailing list and new to LAMP .please correct me any thing wrong .And also tell me how to achive this effieient way with less query ,and less expansive . I have one requirement to create multiple referral for my project .I found some information from php-db archive .I