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 On

Re: [PHP-DB] Tables and foreign keys

2011-12-26 Thread Amit Tandon
Dear KarlRefer 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 One-To-Many Rela

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 >wrote: On Dec 26, 2011, at 1:57 AM, Amit Tandon wrote: Dear Karl Foreign key is a good

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 wrote: > 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 >>

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

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 prob

Re: [PHP-DB] tables

2007-03-30 Thread bedul
u ask on this db not on win.. i think.. you mean how to call everypage with just one page??? > > > "; ?> > "; ?> > > >   > "; ?> > > - Original Message - From: "elk dolk" <[EMAIL PROTECTED]> To: Sent: Friday, March 30, 2007 3:42 PM Subject: [PHP-DB] tables

Re: [PHP-DB] tables

2007-03-30 Thread olavi
I think it should be something like this: > > > > "; > ?> > "; > ?> > > >   > "; > ?> > > how many pictures do you have in database? dont u want to use for/while ? Olavi Ivask > > - > TV dinner still cooling? > Check out "Tonight's Pick

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

2002-05-10 Thread Jeffrey_N_Dyke
(USA)" To: <[EMAIL PROTECTED]>

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

2002-05-10 Thread Ryan Jameson (USA)
[] is the correct notation for both tables and columns. I don't ever recommend using spaces in anything, file names, tablenames, or anything else that will bite you later. But that is the correct syntax, so there may be another problem. Maybe BUSINESS AREA is numeric? <>< Ryan -Original

Re: [PHP-DB] Tables in mysql always corrupted

2001-11-30 Thread Miles Thompson
At 10:32 AM 11/23/2001 +0800, ahakim wrote: >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