SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Zealot cwebmedia's Avatar
    Join Date
    Nov 2002
    Location
    Calgary, Alberta, Canada
    Posts
    180
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Advanced Query Help

    Hello.

    I've got a database set up for a band's web page that looks like this:

    tbl_albums
    tbl_members
    tbl_labels
    tbl_tracks

    Then I've got 2 more tables to attach info:

    tbl_album2track
    tbl_album2member

    My problem being ... this is a more instense db than I've ever done and I'm having some issues cookin' up the right queries. What I like to do is build my db in access then link it up to my MySQL on my local machine. That way I can use access to build the queries with and transfer those over to PHP.

    So I've got a form that has the tbl_tracks infomation (track_id, track_name, track_lyrics) and want to have the tbl_album2track info (album2track_id, album_id, track_id) in there so that I can call a query that makes a nice drop down of of the album names. When I choose an album name, I want it to update the tbl_albums2tracks with the appropriate id numbers.

    Does that makes sense?

    This is all for the admin part of the db. The part where I call the info out on to the page I've got no problem but here I'm hitting some hurdles.

    Basically I want to be able to administer the tbl_album2track and tbl_album2member tables nice an easy with a form (to eventually be web based) as opposed to having to hand enter data.

    Keep smiling ...
    It makes people wonder what you're up to ...

  2. #2
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Don't mean to sound flippant, but what is the specific problem you are having? The thread title suggests the queries themselves (which should be easy enough to do with the Access Query Designer and is the main reason you're doing this in Access first), but then the last sentence of your post suggests that perhaps it's creating an Access and/or web form that's the problem.

    Please elucidate!
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  3. #3
    SitePoint Zealot cwebmedia's Avatar
    Join Date
    Nov 2002
    Location
    Calgary, Alberta, Canada
    Posts
    180
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    My appologies. My brain was pretty scrambled when I wrote that as you can see. I'd been working on that stuff for some time and not making any head way.

    I ended up downloading the 30 trial of Navicat and it's really helping me out in making (and learning) MySQL queries. What a slick tool. I think that when the 30 days is up, I'll be buying this one. It's much better than using Access (for the MySQL stuff) and works very similar to it but as a robust MySQL front end.

    Keep smiling ...
    It makes people wonder what you're up to ...

  4. #4
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, glad you've sorted your head out!! lol
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!


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
  •