running multiple queries

[searls03]

hi there.  i am trying to run a query that will select values from two tables.  I would like to run a query to select an event name and an id from table1, and then select subevent from table2 where the event_id is equal to the id from table1 query.  i know how to do this via a couple of loops, but I only want one loop.  can anyone help me get started?  thanks

[trq]

It has nothing to do with loops. This can be achieved in a single query.

SELECT a.something, b.somethingelse

FROM table_a a

LEFT JOIN table_b b USING(table_a_id)

If you need more help take a look at some tutorials on using a "MySql JOIN" or post your table structure so we can give you a more concrete example.

[searls03]

ok, so table one is called card.  I want to be able to get the event_id from it.  I then want to run a query on table "events" where id=the event_id cart.  basically that is what it looks like and how I need it to funcion.

[searls03]

I gues that isn't all, I also want to then grab all the columns from table one, event_id, qty, event.  and then also spots, name from "events"

[Jessica]

 

It has nothing to do with loops. This can be achieved in a single query.

SELECT a.something, b.somethingelse
FROM table_a a
LEFT JOIN table_b b USING(table_a_id)

If you need more help take a look at some tutorials on using a "MySql JOIN" or post your table structure so we can give you a more concrete example.

[Psycho]

You want to run ONE query. Not two queries. Not multiple queries in loops. One Query.

 

 

SELECT card.event_id, card.qty, card.event,
       events.spots, events.name
FROM card
JOIN events
  ON events.id = card.event_id

 

Did I mention that you only need to run ONE query?