By Pirch on

I bet this will be easily resolved but I did the following db_qerry just to see if I can get one field from my database:

$content_youtube_video_field=db_query("SELECT field_play_youtube_value FROM {content_type_drigg} WHERE nid= %d", 16);
   db_query("INSERT INTO {debug} (cck_embed_video,flashvars_init,flashvars_end) VALUES ('%s','%s','%s')",'toto','tata', $content_youtube_video_field);

I am trying to get what is stuck in the column field_play_youtube . The problem is that this column is said of type "longtext". I use the '%s' in my request but I bet it is something else for a longtext type right?

I hope this si the reason why I have nothing but a blank in the colum flashvars_end (in my debug table) where I should have a copy of the field_play_youtube column (content_type_drigg table) :D

I searched on forums but could not find anything!

Thank you!

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

The line

$content_youtube_video_field=db_query("SELECT field_play_youtube_value FROM {content_type_drigg} WHERE nid= %d", 16);

is incorrect and should read

$content_youtube_video_field = db_result(db_query("SELECT field_play_youtube_value FROM {content_type_drigg} WHERE nid= %d", 16));
Pirch’s picture

Pirch commented

You are right! Thank you ! That helps a lot :)