Results 1 to 9 of 9

Thread: [RESOLVED] Sorting from multiple tables

Threaded View

  1. Mar 9th, 2008, 08:15 AM #9
    visualAd
    visualAd is offline
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: [RESOLVED] Sorting from multiple tables

    Yeah positive and negative values are fine. My suggestion only referred to the transaction type as in how the deposit or withdrawal was made.

    It's perfectly okay to have more than one transaction with the same user ID. But your old set-up could have yielded a transaction with the same account, user ID, amount, date and ID thereby producing a duplicate record.

    I used normalization to demonstrate why it was a problem because it is usually a good idea to check that your database conforms to BC normal form and if not weather changing it so it does solves the problem.
    Last edited by visualAd; Mar 9th, 2008 at 08:18 AM.
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!

    Spread happiness and joy. Rate good posts.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width