Additional Table

  • theref

    (@theref)


    14 years, 9 months ago

    The 8 attributes I have setup I now need to be included into a database table so they can have their one unique ID and also to stop me having to constantly typing the same names over and over ago which will reduce the risk of typos – in other words I need a duplication of the location table.

    If it’s not possible to add a table to EM could I add one into WP an then link from EM to this new table?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    14 years, 9 months ago

    not sure i get what you mean here, 8 attributes?

    Thread Starter theref

    (@theref)

    14 years, 9 months ago

    Sorry to explain….

    I have created 8 attributes in the events table (one for each character in the show). In an individual event I can populate the actors name against the character but as the text is free text, ie not coming from a table, there is no way for me to do unique queries based on the actor – ie show me all roles that he has played, how many times have I seen him etc – whereas if the role and character were in a table I could do that.

    In other words where I can add a location and reference it by location_id I need a table called cast and do the same. I am not using the booking table at all so I wonder if I could amend that.

    Hope that makes more sense

    Perry

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    14 years, 9 months ago

    I’d use the em_meta tables for that. There’s no easy way though, you’d have to code this all yourself.

    I’d use custom posts for your other info though, becasue events will soon be posts (weeks/months)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Additional Table’ is closed to new replies.