Results 1 to 2 of 2

Thread: MySQL

  1. #1
    tomfrankus is offline Junior Member
    Join Date
    Feb 2008
    Posts
    2

    Default MySQL

    Hi Experts,

    i added some custom fields in contacts. These new fields are created in a new table contacts_cstm.
    now i want to get record of contacts including all fiends.
    can anyone help to tell me mysql query to get complete record of a user.

    Thanx.

    Tom

  2. #2
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: MySQL

    Quote Originally Posted by tomfrankus
    Hi Experts,

    i added some custom fields in contacts. These new fields are created in a new table contacts_cstm.
    now i want to get record of contacts including all fiends.
    can anyone help to tell me mysql query to get complete record of a user.

    Thanx.

    Tom
    select *
    from contacts, contacts_cstm
    where id = id_c

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Query Failed: AND users.id = '1'::MySQL error 1064:
    By artco001 in forum Installation and Upgrade Help
    Replies: 63
    Last Post: 2009-05-07, 05:56 AM
  2. Replies: 5
    Last Post: 2007-11-13, 02:51 PM
  3. MySQL Database Not Available
    By luisamato in forum Help
    Replies: 4
    Last Post: 2007-06-27, 05:58 AM
  4. Huge backups -- normal?
    By Liam in forum Help
    Replies: 5
    Last Post: 2007-05-02, 05:36 AM
  5. MySQL error/no workflow notifications
    By rlbyrd in forum Help
    Replies: 1
    Last Post: 2006-09-11, 09:14 PM

Bookmarks

Posting Permissions

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