Ch0cu3r

This most probably happened due to poor validation. You are not checking to make sure that the category is valid before inserting your record into to the database.

Try removing the 123 text Remove , $col from </article>', $col; That could be causing the mis-alignment.

have you look at the example code for SQLite3 query fuction. Quoted from the manual

sqlite_* functions are for SQLite2.x only if you want to use SQLite3.x then you need to use PDO with the SQLite driver or use the SQLite3 class

Change <img src="http://www.kingofthespring.co.uk/' $rows[image], '"style="border: 0px solid" class="index_image" /> to <img src="http://www.kingofthespring.co.uk/', $rows[image], '"style="border: 0px solid" class="index_image" /> Also remove echo '<table align="left "border="0" cellpadding="0" cellspacing="0">'; echo '<tr>'; // start first row and echo '</tr>'; // end last row echo "</table>"; I forgot to mention that in my last post.

Change elseif(strpos($_POST['firstname'], '/') to elseif(strpos($_POST['firstname'], '/'))

You shouldnt be using html tables. Your site uses CSS grids. You need to create a new <div class="wrapper"></div> every three columns Change your while loop to while ($rows = mysql_fetch_array($result)) { $col++; if($col == 0) echo '<div class="wrapper">'; // create a new wrapper echo ' <article class="grid_4"> <figure class="frame2"> <img src="http://www.kingofthespring.co.uk/' $rows[image], '"style="border: 0px solid" class="index_image" /> </figure>'; echo ' <p class="color-4 prev-indent-bot">', $rows[title], '</p>'; echo'<p>', $rows[description],'</p>'; echo' <div class="wrapper"><span class="price fleft">£', $rows[price],'</span>'; echo ' <a href="', $rows[8], '" class="button fright">Read More</a></div> </article>', $col; if ($col == COLS) { $col = 0; echo '</div>'; // end wrapper } }

You use that if for each field you want to block the use of / For example the firstname field if (empty($_POST["firstname"])) { $errors['firstname'] = "Please Enter Your First Name"; } elseif(strpos($_POST['firstname'], '/') { $errors['firstname'] = 'Cannot use /'; } else { $firstname = test_input($_POST["firstname"]); }

Use strpos if(strpos($value, '/')) { // a / was found }

What types of special characters are you wanting to block? Are you only allowing the user to enters letters and numbers only? You could do if(preg_match('~[^a-z0-9]+~i', $value)) { // special characters was used }

Name the text fields like <input type="text" name="textbox[]" ... > Then you can use shuffle($_POST['textbox']) when the form is submitted to randomize the submitted values.

Have the delete button and hidden form fields in separate <form>'s. If you include all the delete/hidden fields within one form then only the last id will be sent!

Yes. On your Windows Server you'll want to setup IIS with PHP. Then on your Mac you'd open the browser and go to the IP Address for your Windows Server so you can run the PHP scripts for accessing the Access Database.

You can use odbc to connect to your MS Access *.mdb database files. One turorial I found http://www.sitepoint.com/using-an-access-database-with-php/ If the company you work for has $$$ then you can get Parallels. However this requires a valid license for Windows and MS Access too.

Yes it is heredoc syntax @shwetapandit You have spaces after END_OF_BLOCK; make sure there is only a new line directly after the ; END_OF_BLOCK; <--- Remove these spaces ^^^^^^^^^^^^^^^^^

You already have the name in $_SESSION['name'] variable so why are you querying the database for their name again? You can just use this. echo "Welcome, ".$_SESSION['name']."!"; Also note you only use the while loop if your query returns more than one row.

If there is only one player to a time then you change the while loop to just $data = array(); while($row = mysql_fetch_array($mysql_result)) { $data[ $row['time'] ] = $row['players']; } Which will give you this array for $data Array ( [10:00] => 5 [11:00] => 8 [12:00] => 12 )

Try it and see if the data is stored in the format you want. If it is not you'll need to give us some example data from your database and then an example of how you want to store that data into an array.

If you are wanting to group all players that have the same time into an array. Then you can do. $data = array(); while($row = mysql_fetch_array($mysql_result)) { // create a new array if(!isset($data[ $row['time'] ])) $data[ $row['time'] ] = array(); // add player to array $data[ $row['time'] ][] = $row['players']; } // output the array to see what is stored printf('<pre>%s</pre>', print_r($data, 1));

I do not know what else to suggest. As I have said something somewhere is causing the query string to be ignored. So when you go to players/?id=1 or even players/index.php?id=1 the $_GET['id'] variable is not being set, because that is not set then the $id variable is not set. Which is why you are getting the page error.

Try changing index.php to <?php session_start(); mysql_connect("localhost", "davidfat", "DsSkXq2n") or die(mysql_error()); mysql_select_db("davidfat_tournaments") or die(mysql_error()); if((isset($_GET['id'])) && (is_numeric($_GET['id']))) { //accessed through viewusers. $id = $_GET['id']; } elseif ((isset($_POST['id'])) && (is_numeric($_POST['id']))) { //form has been subbed. $id = $_POST['id']; } if(isset($id)) { $query = "SELECT userID, username, password, first_name, last_name, email, gender, blurb, points, games_played, games_won, badges_earned, tournaments_won, dob_day, dob_month, dob_year, dp, badgeID, badges, unlocked, feat_badge, feat_badge_name, feat_badge_xp, level, administration, registration_date FROM users WHERE userID = $id"; $result = mysql_query($query) or die (mysql_error()); $row = mysql_fetch_array($result, MYSQL_NUM); } else { print "<h2> Page Error </h2> <p class=error> This page has been accessed in error. </p>"; exit; } ?> <!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> <link rel="shortcut icon" type="image/x-icon" href="http://tournament.davidfattore.com/assets/icons/icon.ico"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>My Profile | Briscola Tournaments 2013</title> <link rel="stylesheet" href="../css/main.css" type="text/css"> <link rel="stylesheet" href="../css/profile.css" type="text/css"> <script type="text/javascript"> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <style> #content_profile { position: absolute; width: 100%; height: 1306px; z-index: 2; background-image: url(../assets/background_profile.jpg); background-position:center; } #playerAvatar { position: absolute; width: 166px; height: 222px; z-index: 12; left: 2px; top: 2px; } #profile_header_badgeinfo { position: absolute; width: 268px; height: 201px; z-index: 2; left: 679px; top: 0px; } #profile_header_summary { position: absolute; width: 479px; height: 201px; z-index: 3; left: 184px; top: 2px; } #profile_header_username { position: absolute; width: 480px; height: 50px; z-index: 1; font-family: Nyala; font-size: 36px; } #profile_header_realname { position: absolute; width: 472px; height: 43px; z-index: 2; left: 4px; top: 54px; font-family: Tahoma; } #profile_header_blurb { position: absolute; width: 473px; height: 97px; z-index: 3; left: 4px; top: 104px; font-family: Tahoma; } #phpContent { position: absolute; width: 177px; height: 21px; z-index: 4; left: 3px; top: 178px; } #profile_header_level { position: absolute; width: 269px; height: 46px; z-index: 1; font-family: Tahoma; font-size: 24px; left: 3px; } #profile_header_favBadge { position: absolute; width: 262px; height: 102px; z-index: 2; left: 4px; top: 66px; background-image: url(../assets/players/favBadge.png); } #btnEditProfile { position: absolute; width: 200px; height: 38px; z-index: 3; left: 4px; top: 174px; } #profile_colomn_left { position: absolute; width: 672px; height: 825px; z-index: 1; top: 5px; left: 6px; font-family: Tahoma; font-size: 24px; color: #CCC; } #profile_colomn_right { position: absolute; width: 249px; height: 825px; z-index: 2; left: 683px; top: 5px; font-family: Tahoma; font-size: 24px; color: #CCC; } #badges_right { position: absolute; width: 250px; height: 136px; z-index: 1; font-family: Tahoma; } #apDiv3 { position: absolute; width: 250px; height: 295px; z-index: 2; top: 149px; } .profile_right_header_small { font-size: 18px; } .playerLevel { font-size: 20px; color: #FFFFFF; } #featBadge { position: absolute; width: 86px; height: 72px; z-index: 1; left: 9px; top: 4px; } #featBadge_name { position: absolute; width: 153px; height: 18px; z-index: 2; left: 95px; top: 23px; text-align: center; font-family: Tahoma; } #featBadge_XP { position: absolute; width: 106px; height: 20px; z-index: 3; left: 117px; top: 48px; text-align: center; font-family: Tahoma; } .xp_text { font-size: 12px; font-family: Tahoma; } #innerContent_1 { position: absolute; width: 655px; height: 223px; z-index: 1; background-image: url(../assets/players/innerContent_back.png); left: 8px; top: 5px; } #innerContent_1_header { position: absolute; width: 626px; height: 45px; z-index: 1; left: 12px; top: 12px; font-family: Tahoma; color: #4791c8; } .how_text { font-size: 11px; } a:link { color: #FFF; } a:visited { color: #FFF; } a:hover { color: #FFF; } a:active { color: #FFF; } </style> </head> <body> <div id="header"> <?php include ("../includes/header.php"); ?> <?php include ("../menu.php"); ?> </div> <div id="logo"> <?php include ("../welcome.php"); ?> <?php include ("../logo.php"); ?> </div> <div id="content_profile"> <div id="container_profile"><!-- BSA AdPacks code --> <script src="http://code.jquery.com/jquery-1.6.3.min.js"></script> <div id="profile_header"> <div id="profile_header_content"> <div id="profile_header_summary"> <div id="profile_header_username"> <?php //USERNAME print '"'. $row[1] .'"'; ?> </div> <div id="profile_header_realname"> <?php print "" . $row[3] . " " . $row[4] .""; ?> </div> <div id="profile_header_blurb"><?php print '<i>'. $row[7] .'</i>'; ?></div> </div> <div id="playerAvatar"><div align="center"> <?php //DISPLAY PICTURE echo '<div class="style30" align="center"><img src="'. $row[16] .'"></img></div>'; ?> </div> <div id="profile_header_badgeinfo"> <div id="profile_header_level"> <table width="269" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="83" height="41">LEVEL:</td> <td width="42" align="center" background="../assets/players/levelCircle.png" class="playerLevel"><?php print $row[23]; ?></td> <td width="144" align="left"><table width="139" border="0" cellspacing="2" cellpadding="2"> <tr> <td width="98" align="right" class="how_text">How do I earn XP?</td> <td width="27" align="right"><a href="#"><img src="../assets/help-icon.png" alt="" width="16" height="16" /></a></td> </tr> </table></td> </tr> <tr> <td height="5" colspan="3"><img src="../assets/divider.png" width="266" height="5" alt="" /></td> </tr> <tr> <td height="17" colspan="3" align="center" valign="bottom" class="xp_text">149 XP to Reach Level 11</td> </tr> </table> </div> <div id="profile_header_favBadge"> <div id="featBadge"> <div align="center"> <?php print '<img src="' . $row[20] . '"></img>'; ?> </div></div> <div id="featBadge_name"> <?php print $row[21]; ?> </div> <div id="featBadge_XP"> <?php print $row[22]; ?> </div> </div> <div id="btnEditProfile"><a href="#"><img src="../assets/players/btnEditProfile.png" width="105" height="35" /></a></div> </div> </div> </div> <div id="profile_content"> <div id="profile_colomn_left"> <div id="innerContent_1"> <div id="innerContent_1_header">Recent Game Activity</div> </div> </div> <div id="profile_colomn_right"> <div id="badges_right">Badges: <?php print $row[11]; ?> <br /> <hr width="99%" size="1" /> <?php print $row[18]; ?></div> <div id="apDiv3"> <table width="250" border="0" cellspacing="2" cellpadding="2"> <tr> <td width="169" height="37" class="profile_right_header_small">Games Played:</td> <td width="67" class="profile_right_header_small"><?php print $row[9]; ?></td> </tr> <tr> <td height="34" class="profile_right_header_small">Games Won:</td> <td class="profile_right_header_small"><?php print $row[10]; ?></td> </tr> <tr> <td height="35" class="profile_right_header_small">Series Won:</td> <td class="profile_right_header_small"><?php print $row[12]; ?></td> </tr> </table> </div> </div> </div> </div> <p> </p> </div> </div> <?php include("../footer.php"); ?> </div> </body> </html>

Can you post the code for index.php here. Something is causing your code to ignore the query string (the ?id= part).

Oh, so what is in the players directory? Is there another .htaccess file? Something is causing your code to ignore the query string in the url (the ?id= part) this is why you are getting the query error.

So what file is the url tournament.davidfattore.com/players/ mapped to? I am confused by this. Can you post your site structure here.

Try changing RewriteRule . /index.php [L] to RewriteRule . /index.php [L,QSA]