Announcement

Collapse
No announcement yet.

Determing the post ID from the attachment table entry?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Determing the post ID from the attachment table entry?

    OK, this might seem like an odd question but I think I am missing something obvious...

    If I am looking at the attachment table directly, how do I determine which post table ID the attachment entry is associated to?

    (vB 4.0.6 table)

    Thanks
    [URL="http://coolscifi.com"]Cool Sci-Fi[/URL="http://coolscifi.com"] | [URL="http://awalkerbit.me"]Walking Dead[/URL="awalkerbit.me"]

  • #2
    attachment table - PostID's are in the column "contentid"

    Comment


    • #3
      Jinovich, thanks.

      I realized what was throwing me off finally... the IDs in the attachment table in the db I was looking were CMS article attachments and not post attachments. Made a big difference.

      Thanks,
      Kevin
      [URL="http://coolscifi.com"]Cool Sci-Fi[/URL="http://coolscifi.com"] | [URL="http://awalkerbit.me"]Walking Dead[/URL="awalkerbit.me"]

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X