my_searches_left.php

<?php
/******************************************************************************
Etano
===============================================================================
File:                       my_searches_left.php
$Revision$
Software by:                DateMill (http://www.datemill.com)
Copyright by:               DateMill (http://www.datemill.com)
Support at:                 http://www.datemill.com/forum
*******************************************************************************
* See the "docs/licenses/etano.txt" file for license.                         *
******************************************************************************/

$my_searches=array();
if (!empty($_SESSION[_LICENSE_KEY_]['user']['user_id'])) {
	$query="SELECT `search_qs`,`title` FROM `{$dbtable_prefix}user_searches` WHERE `fk_user_id`='".$_SESSION[_LICENSE_KEY_]['user']['user_id']."' ORDER BY `search_id` DESC LIMIT 5";
	if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}

	while ($rsrow=mysql_fetch_assoc($res)) {
		$rsrow['title']=sanitize_and_format($rsrow['title'],TYPE_STRING,$__field2format[TEXT_DB2DISPLAY]);
		$my_searches[]=$rsrow;
	}
}

$tpl->set_file('left_content','my_searches_left.html');
$tpl->set_loop('my_searches',$my_searches);
$tpl->set_var('tplvars',$tplvars);
$tpl->process('left_content','left_content',TPL_LOOP | TPL_NOLOOP | TPL_OPTIONAL);
$tpl->drop_loop('my_searches');
unset($my_searches);