[PHP-DB] Updating SQLite on php 5

2005-03-09 Thread Pacp
Greetings all. I am running PHP 5 on FreeBSD and would like to replace the embeded SQLite (2.8...) by an upgraded version (3.12). I have no clue of how this can be done. On windows one apparently only need to replace the dll (or am I wrong ?). How can that be done on FreeBSD ? Thanks for any

[PHP-DB] Upgrading SQLite exec in PHP 5

2005-03-09 Thread franp
Greetings all. I am running PHP 5 on FreeBSD and would like to replace the embeded SQLite (2.8...) by an upgraded version (3.12). I have no clue of how this can be done. On windows one apparently only need to replace the dll (or am I wrong ?). How can that be done on FreeBSD ? Thanks for

[PHP-DB] Forms...

2005-03-09 Thread Mark Benson
Does anyone know if it is possible to have 'checkbox' elements in a form appear 'checked' or 'unchecked' when a page loads data from a MySQL data source? Can I use an attribute in the input tag to switch that? -- Mark Benson AIM - SilValleyPirate MSN - [EMAIL PROTECTED] Visit FlatPackMacs

RE: [PHP-DB] Forms...

2005-03-09 Thread Bastien Koert
I use this format input name=right_eye type=checkbox value=1 ? if ($rows['right_eye']==1) { echo CHECKED ; } ?nbsp;Right Eye(s) Bastien From: Mark Benson [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Forms... Date: Wed, 9 Mar 2005 19:12:31 + Does anyone know if it is

Re: [PHP-DB] Forms...

2005-03-09 Thread Jochem Maas
Bastien Koert wrote: I use this format input name=right_eye type=checkbox value=1 ? if ($rows['right_eye']==1) { echo CHECKED ; } ?nbsp;Right Eye(s) if your into XHTML: input name=right_eye type=checkbox value=1 checked=checked value=1 / (Bastien already showed how to dynamically determine

[PHP-DB] big data base

2005-03-09 Thread luis medrano
Hi All, I need you help. I need to design a very big data base, around 900GB or more of information but I never had design or manage this magnitude of information before. I really appreciate if you can point me to documentation to how can do this properly or you can help me with some experiance

RE: [PHP-DB] big data base

2005-03-09 Thread Bastien Koert
www.highperformancemysql.com if mysql what is the db? and application load? You may want to be looking at Oracle / DB2 Bastien From: luis medrano [EMAIL PROTECTED] Reply-To: luis medrano [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] big data base Date: Wed, 9 Mar 2005 11:54:08

RE: [PHP-DB] big data base

2005-03-09 Thread Bastien Koert
Sorry, just to further my other message. At this size, the iron it runs on is as important as the size of the db. You are likely gonna need some big machines and NAS / SAN to manage the storage. http://www.dmreview.com/article_sub.cfm?articleId=447

Re: [PHP-DB] big data base

2005-03-09 Thread Robby Russell
On Wed, 2005-03-09 at 11:54 -0800, luis medrano wrote: Hi All, I need you help. I need to design a very big data base, around 900GB or more of information but I never had design or manage this magnitude of information before. I really appreciate if you can point me to documentation to how

Re: [PHP-DB] big data base

2005-03-09 Thread Martin Norland
luis medrano wrote: Hi All, I need you help. I need to design a very big data base, around 900GB or more of information but I never had design or manage this magnitude of information before. I really appreciate if you can point me to documentation to how can do this properly or you can help me

[PHP-DB] Merge result set of query?

2005-03-09 Thread ioannes
My first attempt was to use $result=array_merge($result1,$result2) - doesn't work. 'not a valid resource' I have two databases with different connections, so MySQL UNION query would not work. How do I merge the result set of the queries in that case? John -- PHP Database Mailing List

Re: [PHP-DB] Merge result set of query?

2005-03-09 Thread Martin Norland
ioannes wrote: My first attempt was to use $result=array_merge($result1,$result2) - doesn't work. 'not a valid resource' I have two databases with different connections, so MySQL UNION query would not work. How do I merge the result set of the queries in that case? You're going to have to

Re: [PHP-DB] Merge result set of query?

2005-03-09 Thread Jochem Maas
Martin Norland wrote: ioannes wrote: My first attempt was to use $result=array_merge($result1,$result2) - doesn't work. 'not a valid resource' I have two databases with different connections, so MySQL UNION query would not work. How do I merge the result set of the queries in that case?

Re: [PHP-DB] Merge result set of query?

2005-03-09 Thread Martin Norland
Jochem Maas wrote: Martin Norland wrote: ioannes wrote: My first attempt was to use $result=array_merge($result1,$result2) - doesn't work. 'not a valid resource' I have two databases with different connections, so MySQL UNION query would not work. How do I merge the result set of the queries

[PHP-DB] Insertion problem

2005-03-09 Thread sultan Ibraheem
I'm sure that I typed the insertion query corrctly, but it still not committed. I mean that there is no record actually inserted. Is there any possible error, such as configuration error. I am using PHP 5 and MySQL Database Version 4.0.20. Sultan.

Re: [PHP-DB] Insertion problem

2005-03-09 Thread Stephen Johnson
Did I miss the actual insert statement? Can you please show me your insert statement? ?php /* Stephen Johnson c | eh The Lone Coder http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against bad code */ ? From: sultan

[PHP-DB] insertion problem (2)

2005-03-09 Thread sultan Ibraheem
Thanks for your time,, This is the code: $uu=mysql_query(insert into voters2 ('id','username','constnum','name','fname','gname','lname')values('$T10','$T1','$T11','$T4,'$T5','$T6','$T7')); $uu2=mysql_query(insert into voters2 ('sex','birth_day','email','password')

Re: [PHP-DB] insertion problem (2)

2005-03-09 Thread Stephen Johnson
Do you receive any errors or anything that might indicate a problem other then the date not appearing the db ? Be wordy -- hold nothing back -- give me as much as you can. ?php /* Stephen Johnson c | eh The Lone Coder http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office)

Re: [PHP-DB] insertion problem (2)

2005-03-09 Thread Stephen Johnson
This may not necessarily be the problem. But I am not sure that you should be capitalizing the first character of your variable. That is a special type of PHP variable - which I do not use normally - so I can not remember what it is called. However, put all your variables to lower case except

[PHP-DB] Re: insertion problem (2)

2005-03-09 Thread Nadim Attari
$uu=mysql_query(insert into voters2 ('id','username','constnum','name','fname','gname','lname')values('$T10','$T 1','$T11','$T4,'$T5','$T6','$T7')); $sql = insert into voters2 (id,username,constnum,name,fname,gname,lname)values('$T10','$T1','$T11','$T4 ,'$T5','$T6','$T7'); $uu=mysql_query($sql);

Re: [PHP-DB] insertion problem (2)

2005-03-09 Thread Jochem Maas
Stephen Johnson wrote: This may not necessarily be the problem. But I am not sure that you should be capitalizing the first character of your variable. That is a special type of PHP variable - which I do not use normally - so I can not remember what it is called. However, put all your variables

Re: [PHP-DB] Merge result set of query?

2005-03-09 Thread Jochem Maas
Martin Norland wrote: Jochem Maas wrote: Martin Norland wrote: while (($row = mysql_fetch_row($result)) || ($row = mysql_fetch_row($result2))) { // just do it. } .. work (due to shortcircuiting)? and how ugly is it? // foo } That would work if you just wanted to iterate over both