newbie needing help

[Colin Harris]

Guys, I've been learning for two weeks now, so bear with me :-)

I'd like to know how to echo a formatted table using the results from three
different tables - I can join2 using join or left join (and 'using'
the -id), but how do I do three? Maybe my tables aren't normalised properly?
I'll try to explain:

My testing database is on Formula 1 results: I have three tables, one
called tracks (track, track_id), one called drivers (driver, driver_id), and
one called results, where I have (track_id, driver_id, laps_run, laps_led,
points) and stuff like that. Using $result=mysql_query, and then moving the
data to, say, $driver, $points etc, I can get driver and points (using
driver_id), or any similar combination, but how can I get
TRACK - DRIVER - POINTS? Track to points uses an id, driver to points uses
an id, but track to driver doesn't.

Hope I've explained myself, and please, apologies for just jumping in - I
may well be back for more questions, too :-)

Thanks,

Colin

"Colin Harris" <c_harris01@getridofthisbit.blueyonder.co.uk> wrote in
message news:TleUb.1595$%i5.1430@news-binary.blueyonder.co.uk...

> Guys, I've been learning for two weeks now, so bear with me :-)
>
> I'd like to know how to echo a formatted table using the results from

three

> different tables - I can join2 using join or left join (and 'using'
> the -id), but how do I do three? Maybe my tables aren't normalised

properly?

> I'll try to explain:
>
> My testing database is on Formula 1 results: I have three tables, one
> called tracks (track, track_id), one called drivers (driver, driver_id),

and

> one called results, where I have (track_id, driver_id, laps_run, laps_led,
> points) and stuff like that. Using $result=mysql_query, and then moving

the

> data to, say, $driver, $points etc, I can get driver and points (using
> driver_id), or any similar combination, but how can I get
> TRACK - DRIVER - POINTS? Track to points uses an id, driver to points

uses

> an id, but track to driver doesn't.
>
> Hope I've explained myself, and please, apologies for just jumping in - I
> may well be back for more questions, too :-)
>
> Thanks,
>
> Colin
>
>

select * from results, tracks, drivers
where
results.track_id *= tracks.track_id
and results.driver_id *= drivers.driver_id
and (what ever other clause you want)

[Colin Harris]

<xyzzy> wrote in message news:2a2dnR-wiOFz5bzdRVn-ug@comcast.com...

>
> "Colin Harris" <c_harris01@getridofthisbit.blueyonder.co.uk> wrote in
> message news:TleUb.1595$%i5.1430@news-binary.blueyonder.co.uk...

> > Guys, I've been learning for two weeks now, so bear with me :-)
> >
> > I'd like to know how to echo a formatted table using the results from

> three

> > different tables - I can join2 using join or left join (and 'using'
> > the -id), but how do I do three? Maybe my tables aren't normalised

> properly?

> > I'll try to explain:
> >
> > My testing database is on Formula 1 results: I have three tables, one
> > called tracks (track, track_id), one called drivers (driver, driver_id),

> and

> > one called results, where I have (track_id, driver_id, laps_run,

laps_led,

> > points) and stuff like that. Using $result=mysql_query, and then moving

> the

> > data to, say, $driver, $points etc, I can get driver and points (using
> > driver_id), or any similar combination, but how can I get
> > TRACK - DRIVER - POINTS? Track to points uses an id, driver to points

> uses

> > an id, but track to driver doesn't.
> >
> > Hope I've explained myself, and please, apologies for just jumping in -

I

> > may well be back for more questions, too :-)
> >
> > Thanks,
> >
> > Colin
> >
> >

>
> select * from results, tracks, drivers
> where
> results.track_id *= tracks.track_id
> and results.driver_id *= drivers.driver_id
> and (what ever other clause you want)
>

Thank you! Didn't know that!

[jrmaier]

I am a newbie to Dreamweaver and website building all together. I am trying to
build a form, which I ave done in the design view, but need to know how to get
to form to be sent to (2) email addresses simultaneously and how to direct the
user to a page that says something like "thank you we will contact you in 24
hours". Any detailed info would be greatly appreciated! Thanks in advance!

Justin

[Paul Whitham TMM]

Justin

The code depends upon whether you are deploying on a server with an
application server installed such as ASP, CF or PHP. If is a plain html site
then check with your host as they may have scripts already for you to use

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"jrmaier" <webforumsuser@macromedia.com> wrote in message
news:d70bk5$a07$1@forums.macromedia.com...

> I am a newbie to Dreamweaver and website building all together. I am

trying to

> build a form, which I ave done in the design view, but need to know how to

get

> to form to be sent to (2) email addresses simultaneously and how to direct

the

> user to a page that says something like "thank you we will contact you in

24

> hours". Any detailed info would be greatly appreciated! Thanks in advance!
>
> Justin
>