Well I am using 2.0.7 right now. If I install a another application it will be version 2.2.3 Final. what are the benefits of an upgrade?

I am using XOOPS 2.0 and I am thinking about upgrading to the next stable version. Can anyone tell me the benefits of upgarding and how to go about this process with out losing to much uptime on the site. Mind you that the install will be through the hosting company.

That Did the trick Thanks

Ok guys and gals I have a code that works, and now I am looking for constructive comments.

++++++++++++++++here's the code++++++++++++++++++++++++++++

include("mainfile.php");
include(XOOPS_ROOT_PATH."/header.php");
?>

$maxRows_allevents = 5;
$pageNum_allevents = 0;
if (isset($_GET['pageNum_allevents'])) {
$pageNum_allevents = $_GET['pageNum_allevents'];
}
$startRow_allevents = $pageNum_allevents * $maxRows_allevents;

mysql_select_db($database_SkateEvents, $SkateEvents);
$query_allevents = "SELECT * FROM events ORDER BY `Date` ASC";
$query_limit_allevents = sprintf("%s LIMIT %d, %d", $query_allevents, $startRow_allevents, $maxRows_allevents);
$allevents = mysql_query($query_limit_allevents, $SkateEvents) or die(mysql_error());
$row_allevents = mysql_fetch_assoc($allevents);

if (isset($_GET['totalRows_allevents'])) {
$totalRows_allevents = $_GET['totalRows_allevents'];
} else {
$all_allevents = mysql_query($query_allevents);
$totalRows_allevents = mysql_num_rows($all_allevents);
}
$totalPages_allevents = ceil($totalRows_allevents/$maxRows_allevents)-1;
?>

Date	Events	Host	More info	Host id
			Click Here

mysql_free_result($allevents);
include(XOOPS_ROOT_PATH."/footer.php");

?>
+++++++++++++++++++++end code++++++++++++++++++++++++++++++

I had to load the page up in the directory xoops/html/show_records.php I will have to tweak the page and refer to the css file with in the theme but how will I like the page to the navigation to make it look all the same. I also need to fix the link so that each link will point to a flyer.

View results here

Thanks guys.

I am not sure what that means. However, This simple page works so why can't i just use the include statement?


$maxRows_allevents = 5;
$pageNum_allevents = 0;
if (isset($_GET['pageNum_allevents'])) {
$pageNum_allevents = $_GET['pageNum_allevents'];
}
$startRow_allevents = $pageNum_allevents * $maxRows_allevents;

mysql_select_db($database_SkateEvents, $SkateEvents);
$query_allevents = "SELECT * FROM events ORDER BY `Date` ASC";
$query_limit_allevents = sprintf("%s LIMIT %d, %d", $query_allevents, $startRow_allevents, $maxRows_allevents);
$allevents = mysql_query($query_limit_allevents, $SkateEvents) or die(mysql_error());
$row_allevents = mysql_fetch_assoc($allevents);

if (isset($_GET['totalRows_allevents'])) {
$totalRows_allevents = $_GET['totalRows_allevents'];
} else {
$all_allevents = mysql_query($query_allevents);
$totalRows_allevents = mysql_num_rows($all_allevents);
}
$totalPages_allevents = ceil($totalRows_allevents/$maxRows_allevents)-1;
?>

How about using an ftp program

I get a blank page wraped in Xoops.

Quote:

I tryied that but however, I guess I forgot to tell you that I made my database page using Dreamweaver and as you see it works fins as a standalone but i can't get XOOPS to wrap around this database page.

=========================My code=========================


$maxRows_allevents = 5;
$pageNum_allevents = 0;
if (isset($_GET['pageNum_allevents'])) {
$pageNum_allevents = $_GET['pageNum_allevents'];
}
$startRow_allevents = $pageNum_allevents * $maxRows_allevents;

mysql_select_db($database_SkateEvents, $SkateEvents);
$query_allevents = "SELECT * FROM events ORDER BY `Date` ASC";
$query_limit_allevents = sprintf("%s LIMIT %d, %d", $query_allevents, $startRow_allevents, $maxRows_allevents);
$allevents = mysql_query($query_limit_allevents, $SkateEvents) or die(mysql_error());
$row_allevents = mysql_fetch_assoc($allevents);

if (isset($_GET['totalRows_allevents'])) {
$totalRows_allevents = $_GET['totalRows_allevents'];
} else {
$all_allevents = mysql_query($query_allevents);
$totalRows_allevents = mysql_num_rows($all_allevents);
}
$totalPages_allevents = ceil($totalRows_allevents/$maxRows_allevents)-1;
?>

Date	Events	Host	More info	Host id
			Click Here

mysql_free_result($allevents);
?>
=========================end code======================

I am trying to create a method to display my events on http://www.sk8photos.com > events. I have created a database page http://www.sk8photos.com/show_records.php can I copy the code and paste it into a block to get it to work?

That sounds like a good idea to just call the script, but tell me more about blending db's