Search found 15 matches
- Fri Aug 24, 2007 12:49 pm
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
- Fri Aug 17, 2007 2:44 am
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
This is the code I'm using for repeating the episodes until the EoF <?php do { ?> <h2><?php echo $row_MyRS['productionCode']; ?> <?php echo $row_MyRS['seriesNo']; ?>/<?php echo $row_MyRS['epNo']; ?>: <?php echo $row_MyRS['epTitle']; ?></h2> <h4>Original Air Date: <?php echo $row_MyRS['originalAirDat...
- Wed Aug 15, 2007 4:29 am
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
http://www.satellitecitytv.net/sc_episodes.html#sc_tv_series1_episode1 If you check this link out, it shows exactly what I'm trying to achieve, I've put all that information into a table and the sub table on each episode (the pink table) holds information on the characters which is held in one tabl...
- Tue Aug 14, 2007 6:43 pm
- Forum: Databases
- Topic: [SOLVED] Problem with SQL statement
- Replies: 10
- Views: 1337
- Tue Aug 14, 2007 6:38 pm
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
I've taken a look at some of the stuff in there, managed to find a few ansers to other things I had to sort out but I couldn't find a way of solving this little issue. The query as it stands at the moment is: SELECT character_details.characterId , character_details.characterName , actor_details.acto...
- Tue Aug 14, 2007 6:27 pm
- Forum: Databases
- Topic: [SOLVED] Problem with SQL statement
- Replies: 10
- Views: 1337
Many thanks I got there in the end and it's all working for me now. SELECT latest_news.newsId , latest_news.newsDate , latest_news.newsHeadline , latest_news.newsStory , news_links.linkId , news_links.newsId , news_links.newsLink FROM latest_news LEFT JOIN news_links ON latest_news.newsId = news_lin...
- Tue Aug 14, 2007 12:15 pm
- Forum: Databases
- Topic: [SOLVED] Problem with SQL statement
- Replies: 10
- Views: 1337
Ok so I'm on the right lines, I knew there was something wrong with the statment but I'm not too sure how to implement a table reference to the statement. The WHERE statment needs to change, I think! But not sure how, I've googled table references in sql but nothing relevant came up. Do I need to do...
- Tue Aug 14, 2007 12:00 pm
- Forum: Databases
- Topic: [SOLVED] Problem with SQL statement
- Replies: 10
- Views: 1337
- Tue Aug 14, 2007 11:51 am
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
All sorted thank you, the only problem is, I would like to list all of the episode Details one after the other using a repeat region, however, it won't let me do a repeat region on the table that lists all the characters for each episode, which is a seperate table within the table that holds the epi...
- Tue Aug 14, 2007 11:03 am
- Forum: Databases
- Topic: [SOLVED] Problem with SQL statement
- Replies: 10
- Views: 1337
the exact error I'm getting in Dreamweaver when I attempt to test the SQL is: MySQL error #: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN latest_news, news_links ON latest_news.newsId = news_link...
- Tue Aug 14, 2007 10:58 am
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
SELECT character_details.characterId , character_details.characterName , actor_details.actorId , actor_details.actorFirst , actor_details.actorLast , episode_characters.productionCode , episode_characters.characterId , episode_guide.productionCode , episode_guide.tvShow , episode_guide.epTitle , ep...
- Tue Aug 14, 2007 10:37 am
- Forum: Databases
- Topic: [SOLVED] Problem with SQL statement
- Replies: 10
- Views: 1337
[SOLVED] Problem with SQL statement
Hi guys, can anyone spot what's up with this SQL statement? SELECT latest_news.newsId, latest_news.newsDate, latest_news.newsHeadline, latest_news.newsStory, news_links.linkId, news_links.newsId, news_links.newsLink LEFT JOIN latest_news, news_links ON latest_news.newsId = news_links.newsId WHERE ne...
- Mon Aug 13, 2007 12:02 pm
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
- Mon Aug 13, 2007 11:47 am
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
- Sun Aug 12, 2007 6:34 pm
- Forum: Databases
- Topic: Need help merging tables
- Replies: 15
- Views: 1778
Need help merging tables
Hi guys, Don't know if this is the right place to be posting, if not, please move it and let me know where it's gone! lol! I was wondering if you can help me with a little problem. I have two tables 1. 'episode_details ' - stores everything about an episode of a TV series with the primary field bein...