Thread

I have found a strange situation in the weblog_data table.

In my site there is a custom field(relational type) which holds relationship between two weblogs.

In the drop down where that field exists shows values as the “entry_id” of the weblog and level as the “title” of the weblog.

But while entering the data against the corresponding field in the table “exp_weblog_data” table, it always stores different values for the same “title” ie “label”. More so, the values are always incremented when I save the data of the particular weblog.

Is there any other table which stores the values for the relational field? if so what is the relation between the exp_weblog_data and exp_weblog_title ?

Hi Sougat,

Try and think of the exp_weblog_titles and exp_weblog_data table being a single table. An ‘entry’ is only split across both for performance reasons. The table which holds relationships is exp_relationships. The incremental value you are seeing is the rel_id value from that table.

Hi,,
Thanks for your reply.
It helps me a lot…

Can you plz tell me whether we can use nested query module..I mean to say can we do
like,

{exp:query sql="select….."}

ENTRY ID=={entry_id}<br>

  {exp:query sql="select * from exp_weblog_data where entry_id = '{entry_id}’”}

  Field ID={field_id_34}<br>

  {/exp:query}

{/exp:query}

I was trying this..Though the “entry_id” are listed properly…the inner queries does not work properly..

It always gives the same out put, though those should have been different.

ENTRY ID==109
Field ID=31
ENTRY ID==111
Field ID=31
ENTRY ID==112
Field ID=31

Is there any solution?

Can you simplify your problem? I understand your question, but I do not understand why you want to nest queries… there is almost always an easier solution 😊