Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Karl DeSaulniers
On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl Foreign key is a good option (provided you use InnoDB database) to automate the deletion/updation of cart details when you remove cart. Besides 1:1 cardinality is good or bad can only be decided on the semantics of your tables.

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Amit Tandon
regds amit The difference between fiction and reality? Fiction has to make sense. On Mon, Dec 26, 2011 at 1:55 PM, Karl DeSaulniers k...@designdrumm.comwrote: On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl Foreign key is a good option (provided you use InnoDB

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Karl DeSaulniers
On Dec 26, 2011, at 3:05 AM, Amit Tandon wrote: regds amit The difference between fiction and reality? Fiction has to make sense. On Mon, Dec 26, 2011 at 1:55 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Amit Tandon
Dear KarlRefer Wiki entryhttp://en.wikipedia.org/wiki/Entity-relationship_model. The last diagram shows one to many relationship in many ways. That may help you in clearing your doubts about the comma which is a way of representing the relationship Quoted from MS Access example One-To-Many

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Karl DeSaulniers
Thank you! On Dec 26, 2011, at 4:12 AM, Amit Tandon wrote: Dear Karl Refer Wiki entry. The last diagram shows one to many relationship in many ways. That may help you in clearing your doubts about the comma which is a way of representing the relationship Quoted from MS Access example

[PHP-DB] Tables and foreign keys

2011-12-25 Thread Karl DeSaulniers
Hello all, I have two database tables. Cart and a cartdetails. I want the information for the cartdetails to be based on/autofilled info from cart. I want the ability to delete from cart and cartdetails to automatically clear as well. Would a foreign key be best suited for this? What kind of

Re: [PHP-DB] Tables and foreign keys

2011-12-25 Thread Amit Tandon
Dear Karl Foreign key is a good option (provided you use InnoDB database) to automate the deletion/updation of cart details when you remove cart. Besides 1:1 cardinality is good or bad can only be decided on the semantics of your tables. As a an aside, if it is 1:1 cardinality, then you can

[PHP-DB] tables

2007-03-30 Thread elk dolk
I think it should be something like this: table width=50% border=0 cellspacing=3 cellpadding=0 tr td?php echo img src='/album/img/.$photoFileName[2].'/ ; ?/td td?php echo img src='/album/img/.$photoFileName[3].'/ ; ?/td /tr tr tdnbsp;/td td?php echo img

[PHP-DB] tables

2007-03-30 Thread elk dolk
Olavi Ivask wrote: how many pictures do you have in database? dont u want to use for/while ? this is my index.php and I don't want to use for/while because I'll have only 6 photos to show in it, which will be chosen randomly from the Database! - Finding

Re: [PHP-DB] tables

2007-03-30 Thread olavi
I think it should be something like this: table width=50% border=0 cellspacing=3 cellpadding=0 tr td?php echo img src='/album/img/.$photoFileName[2].'/ ; ?/td td?php echo img src='/album/img/.$photoFileName[3].'/ ; ?/td /tr tr tdnbsp;/td td?php echo img

Re: [PHP-DB] tables

2007-03-30 Thread bedul
tr tdnbsp;/td td?php echo img src='/album/img/.$photoFileName[0].'/ ; ?/td /tr /table - Original Message - From: elk dolk [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, March 30, 2007 3:42 PM Subject: [PHP-DB] tables I think it should be something like

[PHP-DB] tables

2007-03-29 Thread elk dolk
Hi list, How can you show some pictures in separate tables in one page with echo? - Don't pick lemons. See all the new 2007 cars at Yahoo! Autos.

[PHP-DB] Tables

2004-08-23 Thread Hafidz Abdullah
Hi everyone. I'm new to PHP. And so I'm so keen on finding people who are willing to share their knowledge with me. I've generated forms containing text boxes, check boxes, text areas, drop boxes, radio buttons hidden fields as an HTML table with two columns, the first for the desciption,

[PHP-DB] tables/columns with spaces

2002-05-10 Thread Jeffrey_N_Dyke
Someone, in their infinite wisdom, named some, not all of course, tables and columns with spaces, i.e. BUSINESS AREA in a SQL server database that i am working with. You can run lots of queries that return fine, but when I run a query such as select * from REQ where BUSINESS AREA = '$var', i

RE: [PHP-DB] tables/columns with spaces

2002-05-10 Thread Ryan Jameson (USA)
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 6:41 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] tables/columns with spaces Someone, in their infinite wisdom, named some, not all of course, tables and columns with spaces, i.e. BUSINESS AREA in a SQL server

RE: [PHP-DB] tables/columns with spaces

2002-05-10 Thread Jeffrey_N_Dyke
) To: [EMAIL PROTECTED] RJameson@usa. cc: ibs.org Subject: RE: [PHP-DB] tables/columns with spaces

[PHP-DB] Tables in mysql always corrupted

2001-11-29 Thread ahakim
hi world, i running php402 + mysql3.23.24beta on pc 800mhz win98. when pc hang was occured, then many tables in mysql was corrupted. i always use 'repair tables' command, but can't recover all record in that table. Anyone can help me to solve this problem. tq 4 ur attention. -- PHP