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

[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 c

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 PRO

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

[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

[PHP-DB] tables

2007-03-30 Thread elk dolk
I think it should be something like this: "; ?> "; ?>   "; ?> - TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV.

[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, th

[PHP-DB] Tables locked a bit too tight

2002-08-16 Thread Michael Hendsbee
I want to lock a table so that other pages can not access the table in between the data pull and date update. But it would seem it locks the *same* page from updating (but not from reading thankfully). PHP: mysql_q

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)
-Original 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

[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 ge

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

[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 Data