How can I decode article_image in DB?

[lcf]

Hi,

how can I decode article_image in DB?

I want to extend the NEW-RT by a picture preview.

This is the SQL-query:

Code: Select all

$sql  =	"SELECT article_id, article_title, article_cid, article_sort, article_summary, article_subtitle, article_image ";
	$sql .=	"FROM ".DB_PREPEND."phpwcms_article WHERE ".$cat;
	// VISIBLE_MODE: 0 = frontend (all) mode, 1 = article user mode, 2 = admin user mode
	switch(VISIBLE_MODE) {
		case 0: $sql .=	"article_public=1 AND article_aktiv=1 AND ";
				break;
		case 1: $sql .= "article_uid=".$_SESSION["wcs_user_id"]." AND ";
				break;
		//case 2: admin mode no additional neccessary
	}
	$sql .= "article_deleted=0 AND article_begin < NOW() AND article_end > NOW() ";
	$sql .= "ORDER BY article_sort".$limit;

How can I extract the information from >article_image< ($row[6]) and produce from it a thumb preview?

Thanks for help!
lcf