2 Table Join, Ambiguous Columns, Aliasing, Active Record

[eluser]helmutbjorg[/eluser]
I've got into the habit of the following naming convention for my tables.

Instead of:

Code:

events (id, name, venue_id, day, description, price)
venues (id, name, day, street, city, state, zip)

I do:

Code:

tbl_events (event_id, event_name, venue_id, event_day, event_description, event_price)
tbl_venues (venue_id, venue_name, venue_day, venue_street, venue_city, venue_state, venue_zip)

It is bloated but you never have any conflicts or confusion about where your data is coming from.