artosousa

where should i put it than?

Hey guys, Im working on a hockey leagues site and i want to each day to be separated, instead i have each game separated...http://hockeywithballs.com/schedule.php you can see there is a break between each game and i want it organized by day...so having a break to divide each day not game like stated above... Here is the code... <?php require_once("Connections/connect.php"); $myshows = mysql_query("SELECT schedule_id, schedule_date, schedule_time, schedule_location, schedule_teamone, schedule_teamtwo FROM tbl_schedule WHERE schedule_date >= CURRENT_DATE ORDER BY schedule_id ASC "); while ($row=mysql_fetch_array($myshows)){ print " <tr bgcolor='#666666'><td width='150'>".date('l F jS', strtotime($row['schedule_date']))."</td><td width='100'>".$row['schedule_time']."</td><td width='200'>".$row['schedule_location']."</td><td width='150'>".$row['schedule_teamone']."</td><td width='111' align='center'>V.S</td><td width='150'>".$row['schedule_teamtwo']."</td></tr><tr><td><br /> </td></tr>"; } $none = mysql_query("SELECT schedule_id, schedule_date, schedule_time, schedule_location, schedule_teamone, schedule_teamtwo FROM tbl_schedule WHERE schedule_date >= CURRENT_DATE ORDER BY schedule_id ASC "); $gone=mysql_fetch_array($none); if ($gone==""){ echo "<tr><td align='center' colspan='3' rowspan='2'><span class='style3'>No Upcoming Shows</span></td></tr>"; } ?>

I am working on a small website change, they wanted a dropdown menu on one of their items in their navigation, i have got it but when you roll over the link and the dropdown appear all the content on the page will move to the right... i didn't code the page, it was used with tables which i don't like using... just wondering if there is a quick way to fix this.... http://canvasskateboards.ca/SKIN/about.html body { color: #421808; font-size: 10pt; font-family: Arial, Helvetica, SunSans-Regular, sans-serif, "Trebuchet MS", Geneva; } .aaquatext { color: #6fcee4; font-size: 13pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } #wrapper{ width:800px; position:relative; margin:0px auto; } #outside{ background:#523019; } #myname{ background-color:#6fcee4; color:#523019; border:none; } #myemail{ background-color:#6fcee4; color:#523019; border:none; } #mymessage{ background-color:#6fcee4; color:#523019; border:none; } #apDiv2 { position:absolute; left:466px; top:42px; width:150px; height:134px; z-index:1; background-color:#523019; visibility: visible; } #apDiv1 { position:absolute; left:480px; top:210px; width:312px; height:184px; z-index:1; } p { } td { } a:link { color: #6fcee4; font-size: 10pt; font-family: Arial, Helvetica, SunSans-Regular, sans-serif, "Trebuchet MS", Geneva; font-weight: normal; font-style: normal; text-decoration: underline; } .maintext { color: #421808; font-size: 10pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } .footertext { color: #421808; font-size: 9pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } .callustext { color: #421808; font-size: 10pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } .footergreytext { color: #999; font-size: 9pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; line-height: 8pt; } .browntext { color: #421808; font-size: 13pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } .aquatext { color: #6fcee4; font-size: 15pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } .pricetext { color: #6fcee4; font-size: 11pt; font-family: "Trebuchet MS", Geneva, Arial, Helvetica, SunSans-Regular, sans-serif; } dl, dt, dd, ul, li { margin: 0; padding: 0; list-style-type: none; } #menu { /* Menu position that can be changed at will */ top: 42px; left: 187px; z-index:100; width: 801px; /* precision for Opera */ height: 19px; } #menu dl { float: left; width: 7.5em; } #menu dt { cursor: pointer; text-align: center; font-weight: bold; margin: 1px; background-color:#523019 } #menu dd { display: none; } #menu li { text-align: center; background: #6DCDE3; } #menu li a, #menu dt a { color: #FFF; text-decoration: none; display: block; height: 100%; } #menu li a:hover, #menu li a:focus, #menu dt a:hover, #menu dt a:focus { background: #6DCDE3; } #site { position: absolute; z-index: 1; top : 70px; left : 10px; color: #6DCDE3; background-color: #6DCDE3; padding: 5px; } a:link { font-size: 8pt; } a:hover { font-size: 8pt; color:#6FCEE9; } a:visited { font-size: 8pt; } a:active { font-size: 8pt; }

oh wait its a different page that the action is linked to <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>T&T JEWELLERS - Manufacturers of Fine Jewellery</title> <link href="untitled.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="wrapper"> <div id="title"><img src="images/image_01.png" width="840" height="146" /> <div id="login"> <form id="form1" name="form1" method="POST" action="<?php echo $loginFormAction; ?>"> <table width="291" border="0" bgcolor="#999999"> <tr> <td width="124" align="right">Username:</td> <td width="151"><label> <input type="text" name="textfield" id="textfield" /> </label></td> </tr> <tr> <td align="right">Password:</td> <td><label> <input type="password" name="textfield2" id="textfield2" /> </label></td> </tr> <tr> <td align="right"> </td> <td><label> <input type="submit" name="button" id="button" value="Submit" /> </label></td> </tr> </table> </form> </div> </div> <div id="nav"><a href="index.php"><img src="images/image_02.png" width="189" height="51" border="0" /></a><a href="aboutus.php"><img src="images/image_03.png" width="152" height="51" border="0" /></a><a href="collections.php"><img src="images/image_04.png" width="154" height="51" border="0" /></a><img src="images/image_05.png" width="152" height="51" /><a href="contact.php"><img src="images/image_06.png" alt="" width="193" height="51" border="0" /></a><br /> </div> <div id="contentbg"> <div id="category"> <form id="form3" name="catagoryform" method="get" action="itemslisttest.php"> <label> <select name="thiscatagory" id="thiscatagory" onchange="catagoryform.submit()"> <option><select a category></option> <option value="anniversary">Anniversary</option> <option value="eternity">Eternity</option> <option value="semi mount">Semi Mount</option> <option value="solitaire">Solitaire</option> <option value="trinity">Trinity</option> </select> </label> <label></label> </form></div> <div id="sort"> <form id="form2" name="form2" method="get" action="itemslisttest.php"> <select name="sorter" id="sorter" onchange="form2.submit()"> <option><sort by ...></option> <option value="items_number">Number</option> <option value="items_category">Category</option> <option value="items_available">Available</option> </select> </form> </div> <div id="listitems"> <table width="628" height="339" style="width: 100%; "> <?php require_once("connect.php"); $sorter = $_GET['sorter']; $mycatagory = $_GET['thiscatagory']; if($sorter==NULL) { $sorter = "items_category"; } if($mycatagory==NULL) { $mystuff = mysql_query("SELECT items_number, items_category,items_img,items_about,items_available FROM tbl_items ORDER BY ".$sorter." ASC"); }else{ $mystuff = mysql_query("SELECT items_number, items_category,items_img,items_about,items_available FROM tbl_items WHERE items_category = '".$mycatagory."' ORDER BY ".$sorter." ASC"); } while($row=mysql_fetch_array($mystuff)) { print "<tr><td width='50'><img src='".$row['items_img']."' width='50' height='50'/></td><td width='136'>".$row['items_category']."</td><td width='90'>".$row['items_number']."</td><td width='393'>".$row['items_about']."</td><td width='98'>".$row['items_available']."</td></tr>"; } ?> </table> </div> <div id="tabletitles"> <table width="651" height="22" border="0" align="center" style="width: 100%; "> <tr><td width="50"></td> <td width="136"><div align="center">Category</div></td> <td width="90"><div align="center">Item Number</div></td> <td width="393"><div align="center">About</div></td> <td width="98"><div align="center">Available</div></td> </tr> </table> </div> </div> <div id="footer"><br /> <a href="index.php">HOME</a> <a href="aboutus.php">ABOUT US</a> <a href="collections.php">COLLECTIONS</a> <a href="promotions.php"> PROMOTIONS</a> <a href="contact.php">CONTACT US</a> <a href="adminlogin.php">ADMIN LOGIN</a><br /> <br /> <br /> Copyright 2008 T&T Jewellers Inc. Design Plus. All Rights Reserved.<br /> Site design by Silhouette Design</div> <a href="contact.php"></a> </div> </body> </html>

alright so i linked the one image anniversary but it just goes to the collection page which still lists all of the items

So i am working on a website for a client... and i want it so when they click on a specific category it only calls out the category in the table... THIS IS HOW IT IS DISPLAYED NOW, everything in the table listed. http://tandtjewellers.ca/collections.php and i want to be able to use this page http://tandtjewellers.ca/collelctions.php and when they click on a category it goes to a list and just calls out the specific category... right now in the long list i have the drop down menu where you can only select a category i was wondering if its along those lines?.....

do i put a specific id there?

i am not getting and errors, it just keeps just calling in the first record in the database, instead of calling the id which is related to the login used to log in... does that make sense? <?php require_once('Connections/eib.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } mysql_select_db($database_eib, $eib); $query_Recordset1 = "SELECT * FROM tbl_users"; $Recordset1 = mysql_query($query_Recordset1, $eib) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?><?php // *** Validate request to login to this site. if (!isset($_SESSION)) { session_start(); } $loginFormAction = $_SERVER['PHP_SELF']; if (isset($_GET['accesscheck'])) { $_SESSION['PrevUrl'] = $_GET['accesscheck']; } if (isset($_POST['user'])) { $loginUsername=$_POST['user']; $password=$_POST['passcode']; $MM_fldUserAuthorization = "users_level"; $MM_redirectLoginSuccess = "http://207.45.186.74/~arto/www/EIB/profile.php?users_id=".$row_Recordset1['users_id'].""; $MM_redirectLoginFailed = "error.html"; $MM_redirecttoReferrer = false; mysql_select_db($database_eib, $eib); $LoginRS__query=sprintf("SELECT users_login, users_password, users_level FROM tbl_users WHERE users_login=%s AND users_password=%s", GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); $LoginRS = mysql_query($LoginRS__query, $eib) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = mysql_result($LoginRS,0,'users_level'); //declare two session variables and assign them $_SESSION['MM_Username'] = $loginUsername; $_SESSION['MM_UserGroup'] = $loginStrGroup; if (isset($_SESSION['PrevUrl']) && false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location: " . $MM_redirectLoginSuccess ); } else { header("Location: ". $MM_redirectLoginFailed ); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> <link href="untitled.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="title"></div><br /> <div id="nav"></div><br /> <div class="content" id="content"> <form ACTION="<?php echo $loginFormAction; ?>" id="form1" name="form1" method="POST"> <table width="417" border="1"> <tr> <td align="right" valign="top">User Name:</td> <td><label> <input type="text" name="user" id="user" /> </label></td> </tr> <tr> <td align="right">Password:</td> <td><label> <input type="password" name="passcode" id="passcode" /> </label></td> </tr> <tr> <td align="right"> </td> <td><label> <input type="submit" name="button" id="button" value="Submit" /> </label></td> </tr> </table> </form></div> </body> </html> <?php mysql_free_result($Recordset1); ?>

Okay well i have created a registreation form for a client, and now i want the user to be able to login with the user name and password they chose. but i want the long in to be specific to their id so they can view their info once they login on a little profile page. i can't seem to get it work. when i was running on the local server on my computer is was fine but once i uploaded the files i can't get it to work. Here is the link to the login page code, http://pastie.org/343572 if any one could help me witht his problem it would be greatly apreciated.