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

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 r

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

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 to

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

> $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($s

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

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 th

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

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. http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against

[PHP-DB] insertion problem (2)

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') values('$D1','$T9','$T8'

Re: [PHP-DB] Insertion problem

Did I miss the actual insert statement? Can you please show me your insert statement? http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against bad code */ ?> > From: sultan Ibraheem <[EMAIL PROTECTED]> > Date: Wed, 9 Mar 2005 1

[PHP-DB] Insertion problem

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] Merge result set of query?

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 i

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

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? You'r

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

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 merg

[PHP-DB] Merge result set of query?

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 (http:/

Re: [PHP-DB] big data base

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 wit

Re: [PHP-DB] big data base

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

RE: [PHP-DB] big data base

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 http://www.oracle.com/technology/tech/java/arch

RE: [PHP-DB] big data base

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

[PHP-DB] big data base

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 y

Re: [PHP-DB] Forms...

Bastien Koert wrote: I use this format > Right Eye(s) if your into XHTML: (Bastien already showed how to dynamically determine whether the chkbox is checked :-) ... all attribs in lower case, and every one must have a value set, in the case of the 'checked' attrib the value is 'checked'. I have

RE: [PHP-DB] Forms...

I use this format > 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 possible to have 'checkbox' elements in a form appear 'checked' or 'unchecked' when a page loads data

[PHP-DB] Forms...

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 tag to switch that? -- Mark Benson AIM - SilValleyPirate MSN - [EMAIL PROTECTED] Visit FlatPackMacs online:

[PHP-DB] Upgrading SQLite exec in PHP 5

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] Updating SQLite on php 5

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 tip.