select * from #tb_pre#_streams where stream_public = 1 and stream_preview = 1 order by stream_author, stream_title select * from #tb_pre#_streams where stream_public = 1 and stream_preview = 0 order by stream_author, stream_title select m10_basket_stream from #tb_pre#_basket where m10_basket_cftoken = '#cftoken#' select stream_bw_slide_isdn, stream_pdf_info from #tb_pre#_streams where stream_uuid = 'rstp_uuid' select m10_basket_stream from #tb_pre#_basket where m10_basket_cftoken = '#cftoken#' and m10_basket_stream = '#streamadd#' insert into #tb_pre#_basket (m10_basket_cftoken, m10_basket_stream, m10_basket_ip) values ('#cftoken#', '#streamadd#', '#remote_addr#')  

Streaming Media Education Portal

By clicking on the lecture title you add this to your basket
Currently you have #q_get_basketcount.recordcount# streaming lectures in you basket 		To view this lectures you have to
download the Real Player
 
#streamadd_msg#
Title:   Free preview !!!
#stream_title#
Syllabus.pdf 
Author:   #stream_author#
Description/length:   40 min
Posting date:   #stream_event# / #stream_year#
 
Title:   #stream_title#Syllabus.pdf 
Author:   #stream_author#
Description/length:   40 min
Posting date:   #stream_event# / #stream_year#
Cost   #stream_cur# #DecimalFormat(stream_cost)# incl. VAT for bandwidth provision
 

Goto basket