Forums
This topic is locked
filter after login
Posted 18 Jun 2006 01:15:02
1
has voted
18 Jun 2006 01:15:02 Simon Wilson posted:
I have dreamweaver 8.01 all I want to display, is user login details here my code
$colname_AccountDetails = "-1";
if (isset($_SESSION['username'])) {
$colname_AccountDetails = (get_magic_quotes_gpc()) ? $_SESSION['username'] : addslashes($_SESSION['username']);
}
mysql_select_db($database_LoginBox, $LoginBox);
$query_AccountDetails = sprintf("SELECT username, Firstname, Surname, Address, PostCode, EmailAddress, bids, Start_Date, Start_End, Costs, JPost, Jaccept, Jreject FROM users WHERE username = '%s'", $colname_AccountDetails);
$AccountDetails = mysql_query($query_AccountDetails, $LoginBox) or die(mysql_error());
$row_AccountDetails = mysql_fetch_assoc($AccountDetails);
$totalRows_AccountDetails = mysql_num_rows($AccountDetails);
$maxRows_Main = 3;
$pageNum_Main = 0;
if (isset($_GET['pageNum_Main'])) {
$pageNum_Main = $_GET['pageNum_Main'];
}
$startRow_Main = $pageNum_Main * $maxRows_Main;
mysql_select_db($database_LoginBox, $LoginBox);
$query_Main = "SELECT jobs.Jobname, jobs.Details, jobs.Bids, jobs.Cost, jobs.Start_Date, jobs.End_Date FROM jobs";
$query_limit_Main = sprintf("%s LIMIT %d, %d", $query_Main, $startRow_Main, $maxRows_Main);
$Main = mysql_query($query_limit_Main, $LoginBox) or die(mysql_error());
$row_Main = mysql_fetch_assoc($Main);
if (isset($_GET['totalRows_Main'])) {
$totalRows_Main = $_GET['totalRows_Main'];
} else {
$all_Main = mysql_query($query_Main);
$totalRows_Main = mysql_num_rows($all_Main);
}
$totalPages_Main = ceil($totalRows_Main/$maxRows_Main)-1;