Search found 15 matches

by jonthomas83
Fri Aug 24, 2007 12:49 pm
Forum: Databases
Topic: Need help merging tables
Replies: 15
Views: 1778

Ok I've tried looking but not really sure where you're pointing to. I have this worked out so far but it's very very wrong! lol. <?php echo "<h1>"$episodes['showFullTitle'];"</h1>" $episodes = mysql_query(" SELECT character_details.characterId , character_details.characterNa...
by jonthomas83
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...
by jonthomas83
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...
by jonthomas83
Tue Aug 14, 2007 6:43 pm
Forum: Databases
Topic: [SOLVED] Problem with SQL statement
Replies: 10
Views: 1337

Ok thanks, just checking I got the right place!
by jonthomas83
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...
by jonthomas83
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...
by jonthomas83
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...
by jonthomas83
Tue Aug 14, 2007 12:00 pm
Forum: Databases
Topic: [SOLVED] Problem with SQL statement
Replies: 10
Views: 1337

Stupid mistake really sorry!

I'm trying to retrieve the 'newsId' passed through the url to match both the 'news_links' and the 'latest_news' record to that Id , however it's giving me an error saying:

MySQL error #: 1052

Column 'newsId' in where clause is ambiguous
by jonthomas83
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...
by jonthomas83
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...
by jonthomas83
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...
by jonthomas83
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...
by jonthomas83
Mon Aug 13, 2007 12:02 pm
Forum: Databases
Topic: Need help merging tables
Replies: 15
Views: 1778

ok cheers for that, I'll take a look when I get back home and get back to you if I get any problems! (no doubt I will!)
by jonthomas83
Mon Aug 13, 2007 11:47 am
Forum: Databases
Topic: Need help merging tables
Replies: 15
Views: 1778

feyd | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] I just re...
by jonthomas83
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...