Login |
|
include "$SERVERPATH/rssi/register_upgrade_homepg_new.php";
flush();
?> |
|
|
| Events |
$sql = "";
// the month variable
if(!$month) $month = date("Ym", time());
if($month!="null") $sql .= " AND (substring(startdate,1,6)=$month OR substring(enddate,1,6)=$month)";
// the country variable
if($country) $sql .=" AND (country='".d_($country)."') ";
// the keywords variable
$eachkeyword = explode(" ",$keywords);
$keywordcount = count($eachkeyword);
if($keywords)
{
for($i=0;$i<$keywordcount;$i++)
{
if($eachkeyword[$i])
{
$sql .= " AND (title like '".d_($eachkeyword[$i])."%' OR title like '% ".d_($eachkeyword[$i])."%' OR ";
$sql .= " about like '".d_($eachkeyword[$i])."%' OR about like '% ".d_($eachkeyword[$i])."%' OR ";
$sql .= " location like '".d_($eachkeyword[$i])."%' OR location like '% ".d_($eachkeyword[$i])."%')";
}
}
}
// finalizing the sql
if($sql) $sql = "WHERE ".substr($sql,4). " ORDER BY startdate desc LIMIT 1";
else $sql = "ORDER BY startdate desc LIMIT 1";
$sqlfinal = "SELECT * FROM industryevent $sql";
$result=mysql_db_query($DATABASE, $sqlfinal);
$count=mysql_num_rows($result);
if($count!=0)
{
while($row=mysql_fetch_row($result))
{
$startdate = date("d M Y", mysqltime_to_mktime(stripslashes($row[1])));
$enddate = date("d M Y", mysqltime_to_mktime(stripslashes($row[2])));
$title = h_(strtoupper(stripslashes($row[3])));
$about = nl2br(h_(stripslashes($row[4])));
if($about=="null") $about="";
$location = h_(stripslashes($row[5]));
if($location=="null") $location="";
$country = h_(stripslashes($row[6]));
$url = h_(stripslashes($row[7]));
if($url=="null") $url="";
$image = h_(stripslashes($row[8]));
if($image!="null") $image=" ";
else $image="";
$displayeventnow .=" | ";
$displayeventnow .="| $title | ";
$displayeventnow .=" ";
$displayeventnow .=" | | ";
//$displayeventnow .=" | $newabout... ";
if($url) $displayeventnow .="| Details | : | http://$url | ";
if($location) $displayeventnow .="| Location | : | $location | ";
$displayeventnow .="| Country | : | $country | | Date | : | $startdate - $enddate | ";
$displayeventnow .=" | ";
}
}
else
{
$displayeventnow .=" | No Events found !! | ";
}
?>
|
| Blogs |
YnFx Blogs is a Web Blog specially designed for the Textile Industry. |
| Latest Blogs |
global $DATABASE;
$query = "select title, postid from blog_header where parent = 0 and visible = '0' order by postid desc limit 0,4";
$result = mysql_db_query($DATABASE, $query) or die(mysql_error());
if(mysql_error()) echo "Unexpected error";
$num = @mysql_num_rows($result);
for($i=0; $i<$num; $i++)
{
$id = mysql_result($result,$i,'postid');
$title = mysql_result($result,$i,'title');
if($num >= 0 )
{
$sanjay=substr($title,0,42);
echo " | $sanjay... | ";
}
}
?>
|
|
| Trade
Associations |
| American Fiber Manufactures Association |
| Contact Person |
Paul T. O'Day |
| Tel | 1-703-875-0432 |
| Fax | 1-703-875-0907 |
| Website | www.fibersource.com |
|
| Forums |
| Active Discussions |
$sql = "SELECT v2_bbs.id,v2_bbs.theme,sum(v2_bbstopic.replies),count(v2_bbstopic.replies), max(v2_bbstopic.lastpost) FROM v2_bbs LEFT JOIN v2_bbstopic ON v2_bbs.id=v2_bbstopic.bbsid GROUP BY v2_bbs.id ORDER BY v2_bbs.theme limit 3";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!".mysql_error());
$bbslist = "";
while($row=mysql_fetch_row($result)){
$bbsid = stripslashes($row[0]);
$theme = stripslashes($row[1]);
$sumreplies = stripslashes($row[2]);
$countreplies= stripslashes($row[3]);
$posts = $sumreplies+$countreplies;
$lastpost = stripslashes($row[4]);
if($lastpost && $lastpost!=0){
$lastpost = mysqltime_to_mktime($lastpost);
$date = date("F d, Y",$lastpost);
$time = date("H:i",$lastpost);
}
else{
$date = "New";
$time = "";
}
$bbslist .= "".h_($theme)." (Responses : $posts)
";
}
echo $bbslist;
?> |
|
|