bamfon

Thanks guys for your comment, I think I know what I need to do Give me a day or two, If I make it with no problems I will mark this as solved, If not I will reply back thanks once again

I was going to do it with cron jobs at first but it wont really work for my needs, My first plan was to, When the user clicks upgrade it would save the userID, Base ID, building type and how long to upgrade is finished to a php file, Then have a cron job run every 30 sec, when the cron job runs it will check the php file that while have a array while loop. at the end of running the page it will delete the user save info But it would not work for a number of reason, 1) user would not be able to see how long to upgrade is finished using this way. 2)As the building level up it takes longer to upgrade using the while it was to hard to add that in and get it to work. 3)delete never worked well. 4)the cron job wont work well if building time is not in 30sec or minutes, I.E if the build time was 1 minute and 10 sec, you would have to wait for 20 sec for the cron job to run

What I am trying to do is, I am building a game right now that works on user building, buildings in there "town", for each level of the building in the town it cost money and power. I have done all the coding for the money and power part. But what I am trying to do is make is so that for each level they upgrade it takes 5 minutes real time from when they click upgrade. I am not asking anyone to write the code for me what I am asking is a pushing in the right way so I can write it myself. Thank you for your time

Just need someone to show me in what area I should start looking todo this just need a helping hand to start on the basic I would like to have an Ajax based map, where the player explore the maps ( yeah, serveral maps like plains, dungeons, lakes.. etc ). Imagine a Pokemon Game for example. The user plays around the field and when it is in specific points, then turn up a button where they can perform some actions that will call the coding for battles IE the game map below http://static.monstermmorpg.com/images/Screenshots/EN/GamePage.png Thanks once again

That's the thing, there no error, when you try to put in password, even if you have between 5-15 characters long and have a number, the message does not go away and page does not submit :S

Before I write anything I will just so I have VERY basic know how of Javascript, don't really use it so have not learnt it Using jquery to validate a simple form, but it keep breaking on the password part, I am sure I done everything by the book and right I plan on adding this to my CMS, I used to do it all by PHP but that way is longer and does not look as nice as jquery does <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js"></script> <script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.8/jquery.validate.min.js"></script> <form id="myform"> <input type="text" name="username" /> <br/> <input type="text" name="email" /> <br/> <input type="text" name="password" /> <br/> <input type="text" name="confirm_password" /> <br/> <input type="submit" /> </form> <a id="docs" href="http://docs.jquery.com/Plugins/Validation" target="_blank">Validation Documentation</a> $(document).ready(function () { $('#myform').validate({ // initialize the plugin rules: { username: { required: true, minlength: 5 }, email: { required: true, email: true }, password: { required: true, minlength: 5, maxlength: 15, ContainsAtLeastOneDigit: true }, confirm_password: { required: true, equalTo: "#password" }, }, messages: { username: { required: "Please enter a username", minlength: "Your username must consist of at least 5 characters" }, password: { required: "Please provide a password", minlength: "Your password must be at between 6 to 14 characters long", maxlength: "Your password must be at between 6 to 14 characters long11", ContainsAtLeastOneDigit: "must contaion one number" }, confirm_password: { required: "Please confirm passwordd", equalTo: "Please enter the same password as above" }, email: "Please enter a valid email address", }, submitHandler: function (form) { // for demo alert('valid form submitted'); // for demo return false; // for demo } }); });

If you looked at the coding all its doing is checking if its on and then running "stripslashes" if its on, I turn it off, but other that may use my CMS might not.

Well I am now getting around to updating some of the CMS that I have done, and I wanted to know whats the thoughts on the user filtering below. Is there anything I could do to make it better or would it do its job fine as it is and no need to update? <?php //cleaning the user inputing anit Sql attack function nice_escape($unescapedString) { if (get_magic_quotes_gpc()) { $unescapedString = stripslashes($unescapedString); } $unescapedString=strip_tags($unescapedString); $semiEscapedString = mysqli_real_escape_string($unescapedString); $escapedString = addcslashes($semiEscapedString, "%_"); return $escapedString; } function nice_output($escapedString) { $patterns = array(); $patterns[0] = '/\\\%/'; $patterns[1] = '/\\\_/'; $replacements = array(); $replacements[0] = '%'; $replacements[1] = '_'; $output = preg_replace($patterns, $replacements, $escapedString); return $output; } function cleanup($string) { $out = nice_output(nice_escape($string)); return $out; } ?>

Wondering how much tables in a database would it take to start lagging the the database. And how many rows in a table would it take to lag the table when trying to find a table

Was watching Iron man again today and it got me thinking. Below are a few things Jarvis can do, for the people have not not watched iron man Voice communication Remote communication (e.g. with Iron Man suit) Ability to control other devices connected to Jarvis remotely (e.g. energy transportation between suit repulsors, or some things in Stark's buildings - these are actually just basic interfaces, lights, music) Ability to control everything think on computer Ability to identify dangerous decisions of a user and warn him/her

Not good at explaning myself but I will try $con = database_connect(); $sqs="SELECT * FROM `11game`.`army_info` LEFT JOIN `11game`.`armyinbase` ON ( `army_info`.`type` = `armyinbase`.`type` )" ; $res1=mysql_query($sqs,$con); if(!$res1) { die('error in data'.mysql_error()); } ?> while($row1=mysql_fetch_assoc($res1)) { $name=$row1['name']; $info=$row1['info']; ?> $result2 = mysql_query($sql2)or exit(mysql_error()); while($row2 = mysql_fetch_array($result2)) { $total = $row1['total']; } <td height="14" align="center"><?php echo $row1['name'];?></td> <td height="30" rowspan="2" align="center"> <?php echo $total ?></td> <td rowspan="2"> </td> <td rowspan="2">1</td> </tr> <tr> <td height="14" align="center"><?php echo $info ;?></td> </tr> <?php } ?> What I am trying to do Is The first table to recall up the the info and place it in the table (done that part its working ) But I was the 2nd table to recall up info and add it in the right place EG on the line where ID =1 on both tables What should be shown is something like this Table Troops How many you own cost per a unit tank 2 10gold The troops and cost per a unit is from table one while the how many you own is from table 2 Right now its showing info info from table 1 how many times there are rows intable 2

Fixed it myself.

Any help anyone?

Well I am trying to is send a email with the user attachment along with what they put in form <?php if (isset($_POST['submit'])){ $strFilesName1 = $_FILES["file"]["tmp_name"]; //define the receiver of the email $to = '[email]inix@live.co.uk[/email]'; //define the subject of the email $subject = 'email with attachment'; //create a boundary string. It must be unique //so we use the MD5 algorithm to generate a random hash $random_hash = md5(date('r', time())); //define the headers we want passed. Note that they are separated with \r\n $headers = "From: [email]webmaster@example.com[/email]\r\nReply-To: [email]webmaster@example.com[/email]"; //add boundary string and mime type specification $headers .= "\r\nContent-Type: multipart/mixed; boundary=\"PHP-mixed-".$random_hash."\""; //read the atachment file contents into a string, //encode it with MIME base64, //and split it into smaller chunks $attachment = chunk_split(base64_encode(file_get_contents("$strFilesName1"))); //define the body of the message. ob_start(); //Turn on output buffering ?> --PHP-mixed-<?php echo $random_hash; ?> Content-Type: multipart/alternative; boundary="PHP-alt-<?php echo $random_hash; ?>" --PHP-alt-<?php echo $random_hash; ?> Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello World!!! This is simple text email message. --PHP-alt-<?php echo $random_hash; ?> Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit <h2>Hello World!</h2> <p>This is something with <b>HTML</b> formatting.</p> <?php $to = "[email]inix@live.co.uk[/email]"; $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $email = $_POST['email']; $document_title = $_POST['document_title']; $word_count = $_POST['word_count']; $comments = $_POST['comments']; echo "First name" .$first_name; echo"<br />"; echo "Last name" .$last_name; echo"<br />"; echo "Email" .$email; echo"<br />"; echo "Document title" .$document_title; echo"<br />"; echo "Word count" .$word_count; echo"<br />"; echo "Comments" .$comments; ?> --PHP-alt-<?php echo $random_hash; ?>-- --PHP-mixed-<?php echo $random_hash; ?> Content-Type: ; name="<?php echo $_FILES["file"]["tmp_name"]; ?>" Content-Transfer-Encoding: base64 Content-Disposition: attachment <?php echo $attachment; ?> --PHP-mixed-<?php echo $random_hash; ?>-- <?php //copy current buffer contents into $message variable and delete current output buffer $message = ob_get_clean(); //send the email $mail_sent = @mail( $to, $subject, $message, $headers ); //if the message is sent successfully print "Mail sent". Otherwise print "Mail failed" echo $mail_sent ? "Mail sent" : "Mail failed"; }else{ ?> <form method="post" enctype="multipart/form-data" name="form1" id="form1" onsubmit="return valid();"> <p> <label>First name: <input name="first_name" type="text" id="first_name" maxlength="50" /> </label> <br /> <br /> <label>Last name: <input name="last_name" type="text" id="last_name" maxlength="100" /> </label> <br /> <br /> <label>Email: <input name="email" type="text" id="email" maxlength="100" /> </label> <br /> <br /> <label>Document title: <input name="document_title" type="text" id="document_title" maxlength="100" /> </label> <br /> <br /> <label>Word count: <input name="word_count" type="text" id="word_count" maxlength="100" /> </label> <br /> <br /> <label>Comments: <input name="comments" type="text" id="comments" maxlength="100" /> <br /> <br /> </label> <label>Upload file <input type="file" name="file" id="file"> <br /> <br /></label> <input type="submit" name="submit" id="submit" value="Submit" /> </p> </form> <?php }?> What it is doing is, sending user info and but not attaching the file but putting random long numbers so it seems to be encoding the file but not adding it as a attachment Content-Type: application/msworks name="/home/inixdeve/tmp/phpqVDPz3" Content-Transfer-Encoding: base64 Content-Disposition: attachment 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAAQAAAAAAAAAA EAAAAgAAAAEAAAD+////AAAAAAAAAAD///////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////9 /////v////7///8EAAAABQAAAAYAAAAHAAAACAAAAAkAAAASAAAACwAAAAwAAAANAAAADgAAAA8A AAAQAAAAEQAAAAMAAAATAAAAFAAAABUAAAAWAAAAFwAAABgAA AAZAAAAGgAAABsAAAAcAAAAHQAA AB4AAAAfAAAAIAAAACEAAAAiAAAAIwAAACQAAAAlAAAAJgAAA P7////+//////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////1IA bwBvAHQAIABFAG4AdAByAHkAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAWAAUA//////////8BAAAAslqkDgqe0RGkBwDAT7kyugAAAAAAAAAAAAAAAHA27hV0DswB JwAAAEABAAAAAAAAQwBPAE4AVABFAE4AVABTAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAABIAAgECAAAAAwAAAP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAKAAAAAEgAAAAAAAABAEMAbwBtAHAAT wBiAGoAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEgACA P///////////////wAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABWAAAAA AAAAFMAUABFAEwATABJAE4ARwAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAASAAIA//////// ////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAALgAAAAAAAAAAQAA AP7///8DAAAABAAAAP7///////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////9kACAA dABoAGEAdAAgAGgAZQAgAHcAYQBzACAAcABvAHAAdQBsAGEAc gAgAGkAcwAgACAAYgBlAGMAYQB1 AHMAZQAsACAAaQBmACAAaABlACAAdwBhAHMAIABuAG8AdAAgA HQAaABlACAAbQBpAGwAbABlAHIA IAB3AG8AdQBsAGQAIAAgAG4AbwB0ACAAIABoAGEAdgBlACAAb ABlAG4AdAAgAGgAaQBtACAAdABo AGUAIABjAGEAcgB0ACAAdABvACAAbQBvAHYAZQAuAA0ADQA1A A0AIABUAGgAZQAgAHQAaAByAGUA ZQAgAG8AYwBjAHUAcABhAHQAaQBvAG4AcwAgAHQAaABhAHQAI AB3AGEAcwAgAG0AZQBuAHQAaQBv AG4AZQBkACAAaQBuACAAdABoAGUAIABwAGEAcwBzAGEAZwBlA CAAdwBlAHIAZQAgACAAHCB0AGgA ZQAgAG0AaQBsAGwAZQByACwAIABzAGMAaABvAG8AbABtAGEAc wB0AGUAcgAgAGEAbgBkACAAcgBl AGMAdABvAHIAHSANAA0ANgANAEEAbgBvAHQAaABlAHIAIAB3A G8AcgBkACAAZgBvAHIAIAAYIGcA aQB2AGUAbgAZICAAaQBzACAAGCBiAGUAcwB0AG8AdwBlAGQAG SAsACAAYQBuAG8AdABoAGUAcgAg AHcAbwByAGQAIABmAG8AcgAgABggdQBuAHcAaQBsAGwAaQBuA GcAGSAgAGkAcwAgABggcwBvAHIA cgB5ABkgDQANADcADQBUAGgAbwBtAGEAcwAgAEgAYQByAGQAe QAgAHQAZQBsAGwAIAB1AHMAZQAg AG8AbgAgAHQAaABlACAAZgBpAHIAcwB0ACAAbABpAG4AZQAgA HQAaABhAHQAIAB0AGgAZQAgAHMA YwBoAG8AbwBsACAAbQBhAHMAdABlAHIAIAB3AGEAcwAgAGwAZ QBhAHYAaQBuAGcALAAgAGgAZQAg AGEAbABzAG8AIABzAGEAeQBzACAAdABoAGEAdAAgACAATQByA CAAUABoAGkAbABsAG8AdABzAG8A bgAgAGgAYQBkACAAYQBsAGwAIAB0AGgAZQAgAHQAaABpAG4AZ wBzACAAaABlACAAbwB3AG4AZQBk ACAAaQBuACAAYQAgAGMAYQByAHQALAAgAGEAbgBkACAAbABhA HMAdABsAHkAIABNAHIAIABQAGgA aQBsAGwAbwB0AHMAbwBuACAAcwBhAHkAcwAgAHQAaABhAHQAI ABoAGUAIAB3AGEAcwAgAG0AbwB2 AGkAbgBnACAAdABvACAAQwBoAHIAaQBzAHQAbQBpAG4AcwB0A GUAcgAgAGEAbgBkACAAaABlACAA YwBvAHUAbABkACAAbgBvAHQAIAB0AGEAawBlACAAaABpAHMAI ABwAGkAYQBuAG8AIAB3AGkAdABo ACAAaABpAG0ADQANADgADQBKAHUAZABlACAAdABoAG8AdQBnA GgAdAAgAHQAaABhAHQAIABoAGkA cwAgAGEAdQBuAHQAGSBzACAAZgB1AGUAbAAtAGgAbwB1AHMAZ QAgAHcAbwB1AGwAZAAgAGIAZQAg AG8AZgAgAHUAcwBlACAAdABvACAAdABoAGUAIABzAGMAaABvA G8AbAAgAG0AYQBzAHQAZQByACwA IABiAGUAYwBhAHUAcwBlACAAaABlACAAdABoAG8AdQBnAGgAd AAgAHQAaABlACAAcwBjAGgAbwBv AGwAIABtAGEAcwB0AGUAcgAgAGMAbwB1AGwAZAAgAGwAZQBhA HYAZQAgAGgAaQBzACAAcABpAGEA bgBvACAAdABoAGUAcgBlAC4ADQANADkADQBTAGUAYwB0AGkAb wBuACAAQQAgAHQAYQBsAGsAcwAg AGkAbgAgAG0AbwByAGUAIABpAG4AZgBvAHIAbQBhAHQAaQB2A GUAIABzAHQAeQBsAGUALAAgAGEA bgBkACAAaABhAHMAIABhACAAbABvAHQAIABvAGYAIABmAGEAY wB0AHMAIABpAG4AIABpAHQAIABz AHUAYwBoACAAYQBzACAAHCB0AGgAZQAgAG8AbABkACAAcwB0A GUAYQBtAGUAcgBzACAAdwBoAGkA YwBoACAAdQBzAGUAZAAgAHQAbwAgAGMAcgBvAHMAcwAgAHQAa ABlACAAQQB0AGwAYQBuAHQAaQBj AC0ALQAtACAAIAAYIG8AYwBlAGEAbgAgAGcAcgBlAHkAaABvA HUAbgBkAHMAGSAgAHQAaABlAHkA IAB3AGUAcgBlACAAYwBhAGwAbABlAGQAHSAgAHcAaABlAHIAZ QBhAHMAIABTAGUAYwB0AGkAbwBu ACAAQgAsACAAaQBzACAAaQBuAGYAbwByAG0AYQBsACAAYQBuA GQAIABpAHMAIABhAGkAbQBlAGQA IABhAHQAIABhACAAeQBvAHUAbgBnAGUAcgAgAGEAZwBlACAAZ wByAG8AdQBwACAAYgBlAGMAYQB1 AHMAZQAgAG8AZgAgAHQAaABlACAAcwBpAG0AcABsAGUAIABzA HQAeQBsAGUAIABvAGYAIAB3AHIA aQB0AGkAbgBnACAAYQBuAGQAIAB0AGgAZQAgAHcAYQB5ACAAa QB0ACAAcwBlAHQAcwAgAHQAaABl ACAAcwB0AG8AcgB5AC4AIABGAG8AcgAgAGUAeABhAG0AcABsA GUAIABpAHQAIABoAGEAcwAgAG4A bwAgAGgAaQBzAHQAbwByAGkAYwBhAGwAIABmAGEAYwB0AHMAL AAgAGEAbgBkACAAaABhAHMAIABw AGEAcgB0AHMAIAB3AGgAZQByAGUAIAB0AGgAZQAgAGMAaABhA HIAYQBjAHQAZQByAHMAIABhAHIA ZQAgAHQAYQBsAGsAaQBuAGcAIAB0AG8AIABlAGEAYwBoACAAb wB0AGgAZQByAC4AIAAgAA0ADQBO AGEAbgBhACAASwB3AGEAbQBlACAAQgBhAG0AZgBvACAAIABDA HUAcwB0AG8AbQBlAHIAIABuAHUA bQBiAGUAcgA6ADIAMAA4ADAAMwAxADkAMwAgACAAVABlAHMAd ABwAGEAcABlAHIAIABuAHUAbQBi AGUAcgA6ADQAMAA1ADIANwAvADAAMgAgAFQAdQB0AG8AcgAgA G4AdQBtAGIAZQByADoAMQA0ADIA OAANAA0AYgBlAGMAYQB1AHMAZQAsACAAaABlACAAbwBuAGwAe QAgAGEAdAB0AGUAbgBkAGUAZAAg AG4AaQBnAGgAdAAgAHMAYwBoAG8AbwBsACAAdwBoAGkAbABlA CAATQByACAAUABoAGkAbABsAG8A dABzAG8AbgAgACAAdwBhAHMAIAB0AGUAYQBjAGgAaQBuAGcAI ABpAHQALgANAA0AMwABAAAAAAAU AgAAFgIAABoCAAAsAwAALgMAADIDAADIAwAAygMAAM4DAAAuB QAAMAUAADQFAADoBQAA6gUAAO4F AAByBwAAdAcAAHgHAAA+CQAAQAkAAFQJAABWCQAAWgkAACIKAAAkCgAAKAoAAJQLAACWCwAAmgsA APINAAD0DQAA+A0AANAQAADSEAAA1hAAAKARAACiEQAAphEAAEYSAABIEgAATBIAAEoUAABMFAAA UBQAAHAVAAByFQAAdhUAALAYAACyGAAAYhkAAGQZAAD8AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8 AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8AfwB/AH8AfwB /AH8AfwB/AH8AfwB/AH8AfwB1AEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAKAAAADKCIgAAACcaAgAoihgAAAAAIKDbKQABEAIACCBAt 1MACRABAAQAAAAHAAEAAAAAABQC AABACQAAVAkAANYYAABgGQAAYhkAAGQZAADqAeAB6gHgAbgBi gHgAQAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAALgAAAAwiUFMCABIiCQgA ACSKHAAAAAgYAAAQGAAAGBgAACAYAAAwGAAAOBgAACgAAAASI gkIAAAkihwAAAAIGAAAEBgAABgY AAAgGAAAMBgAADgYAAAKAAAAEiIJBAAAFgAAAAIKDCL4fAMAE iIJBAAAHhIBAENITktXS1MgBAAI ABAAAAMAAgAAAEgAAPgBEAD/////GABURVhUAAABAAAAVEVYVAACAABkFwAAGABGRFBQAAABAAAA RkRQUAAaAAAAAgAAGABGRFBDAAABAAAARkRQQwAcAAAAAgAAG ABTVFNIAAABAAAAU1RTSAAeAABo AQAAGABTVFNIAQABAAAAU1RTSGgfAACiAgAAGABTWUlEAAABA AAAU1lJRAoiAAAUAAAAGABTR1Ag AAABAAAAU0dQIB4iAAAEAAAAGABJTksgAAABAAAASU5LICIiA AAEAAAAGABCVEVQAAABAAAAUExD ICYiAAAYAAAAGABCVEVDAAABAAAAUExDID4iAAAYAAAAGABGT 05UAAABAAAARk9OVFYiAABwAAAA GABTVFJTAAABAAAAUExDIMYiAAA6AAAAGABQUk5UAAABAAAAV 05QUgAjAADjIgAAGABGUkFNAAAB AAAARlJBTeNFAACIAAAAGABUSVRMAAABAAAAVElUTGtGAAASA AAAGABET1AgAAABAAAARE9QIH1G AAAuAAAAbgB0AGkAbwBuAGUAZAAgAGkAbgAgAHQAaABlACAAc ABhAHMAcwBhAGcAZQAgAHcAZQBy AGUAIAAgABwgdABoAGUAIABtAGkAbABsAGUAcgAsACAAcwBjA GgAbwBvAGwAUwBlAGMAdABpAG8A bgAgAEEADQANADEADQBUAGgAZQAgACAAcABhAHMAcwBlAG4AZ wBlAHIAcwAgAHcAZQByAGUAIABo AGEAcABwAHkAIAB0AG8AIAByAGUAYQBjAGgAIAB0AGgAZQBpA HIAIABkAGUAcwB0AGkAbgBhAHQA aQBvAG4AIABiAGUAYwBhAHUAcwBlACAAIAB0AGgAZQB5ACAAd wBhAG4AdABlAGQAIAB0AG8AIAAg AHQAYQBrAGUAIABjAGEAcgBlACAAbwBmACAAdABoAGUAaQByA CAAIABiAHUAcwBpAG4AZQBzAHMA IABvAG4AIAB0AGgAZQAgAGwAYQBzAHQAIABkAGEAeQAgAG8AZ gAgAHQAaABlACAAdwBlAGUAawAu AA0ADQAyAA0AUwBvAG0AZQAgAG8AZgAgAHQAaABlACAAcABhA HMAcwBlAG4AZwBlAHIAcwAgAHcA bwB1AGwAZAAgAG0AbwBzAHQAIABsAGkAawBlAGwAeQAgAGwAZ QBhAHYAZQAgAE4AZQB3ACAAWQBv AHIAawAgAGEAZgB0AGUAcgAgAHQAaABlACAAdwBlAGUAawBlA G4AZAAuAA0ADQAzAA0AVABoAGUA IAB0AHkAcABlACAAbwBmACAAdgBlAHMAcwBlAGwAIAB0AGgAY QB0ACAAcwBhAGkAbABlAGQAIAB0 AGgAZQAgAEEAdABsAGEAbgB0AGkAYwAgAGEAdAAgAHQAaABhA HQAIAB0AGkAbQBlACAAdwBhAHMA IABhACAAdgBlAHMAcwBlAGwAIAB0AGgAYQB0ACAAdwBhAHMAI AAgAG0AYQBkAGUAIABvAHUAdAAg AG8AZgAgADIAIABwAG8AcgB0AGkAbwBuAHMAIAB0AGgAYQB0A CAAdwBlAHIAZQAgAGQAaQBmAGYA ZQByAGUAbgB0ACAAZgByAG8AbQAgAGUAYQBjAGgAIABvAHQAa ABlAHIAIABrAG4AbwB3AG4AIABh AHMAIABjAG8AbQBwAG8AdQBuAGQAIABtAGEAcgBpAG4AZQAgA HMAdAByAHUAYwB0AHUAcgBlAHMA LgANAA0ANAANAFQAdwBvACAAcABhAHIAdABzACAAbwBmACAAd ABoAGUAIAB2AGUAcwBzAGUAbAAg AG0AZQBuAHQAaQBvAG4AZQBkACAAYQByAGUALAAgAHQAaABlA CAAZQBsAGUAYwB0AHIAaQBjACAA ZQBuAGcAaQBuAGUAcwAgAGEAbgBkACAAdABoAGUAIABwAHIAb wBwAGUAbABsAGkAbgBnACAAbQBh AGMAaABpAG4AZQByAHkAIAANAA0ANQANAFQAdwBvACAAcQB1A G8AdABlACAAYQByAGUAIAAcICYg IABhACAAdwBlAHMAdAB3AGEAcgBkAC0AYgBvAHUAbgBkACAAQ QB0AGwAYQBuAHQAaQBjACAAbABp AG4AZQByACAAdwBhAHMAIAByAGEAcABpAGQAbAB5ACAAbgBlA GEAcgBpAG4AZwAgAE4AZQB3ACAA WQBvAHIAawAdICAAYQBuAGQAIABhAGwAcwBvACAAHCBUAGgAZ QAgAHYAZQBzAHMAZQBsACAAbgBv AHcAIABzAHAAZQBlAGQAaQBuAGcAIABhAGwAbwBuAGcAIAB0A GgAZQAgAHMAbwB1AHQAaABlAHIA bgAgAGMAbwBhAHMAdAAgAG8AZgAgAEwAbwBuAGcAIABJAHMAb ABhAG4AZAAgAHcAYQBzACAAdABo AGUAIABFAHUAdABlAHIAcAAtAFQAaABhAGwAaQBhACwAIABmA HIAbwBtACAAUwBvAHUAdABoAGEA bQBwAHQAbwBuAB0gDQANADYADQBUAGgAZQAgAHMAaABpAHAAI AB3AGEAcwAgAG0AYQBkAGUAIABv AHUAdAAgAG8AZgAgAHQAdwBvACAAcABvAHIAdABpAG8AbgBzA CAAdABoAGEAdAAgAHcAYQBzACAA ZQBuAHQAaQByAGUAbAB5ACAAZABpAGYAZgBlAHIAZQBuAHQAI ABmAHIAbwBtACAAZQBhAGMAaAAg AG8AdABoAGUAcgAuACAASQBuACAAcwBpAGQAZQAgAHQAaABlA CAAaAB1AGwAbAAgAG8AZgAgAHQA aABlAHMAZQAgAHAAbwByAHQAaQBvAG4AcwAgAHcAYQBzACAAb gBvAHQAaABpAG4AZwAgAGIAdQB0 ACAAZQBsAGUAYwB0AHIAaQBjACAAZQBuAGcAaQBuAGUAcwAgA GEAbgBkACAAdABoAGUAIABwAHIA bwBwAGUAbABsAGkAbgBnACAAbQBhAGMAaABpAG4AZQByAHkAI AB0AGgAYQB0ACAAbwBuAGwAeQAg AGgAYQBkACAAdABoAGUAIABuAGUAYwBlAHMAcwBhAHIAeQAgA GYAdQBlAGwAIABhAG4AZAAgAGEA ZABqAHUAbgBjAHQAcwAuAA0ADQBTAGUAYwB0AGkAbwBuACAAQ gANAA0AMQANAFQAaABlACAAcwBj AGgAbwBvAGwAIABtAGEAcwB0AGUAcgAgAGgAYQBkACAAYQAgA HAAaQBhAG4AbwAsACAAYgBlAGMA YQB1AHMAZQAgAGgAZQAgAHQAaABvAHUAZwBoAHQAIABvAGYAI ABsAGUAYQByAG4AaQBuAGcAIABt AHUAcwBpAGMALAAgAHMAbwAgAGgAZQAgAGIAbwB1AGcAaAB0A CAAaQB0ACAAYQB0ACAAYQBuACAA YQB1AGMAdABpAG8AbgAuAA0ADQAyAA0AVABoAGUAIABiAG8Ae QAgAHcAaABvACAATQByACAAUABo AGkAbABsAG8AdABzAG8AbgAgAHcAYQBzACAAdABhAGwAawBpA G4AZwAgAHQAbwAgAGkAcwAgAGMA YQBsAGwAZQBkACAASgB1AGQAZQAuACAAVABoAGUAIAByAGUAY QBzAG8AbgAgAHQAaABlAHkAIABo AGEAZAAgAHMAdQBjAGgAIABhACAAZwBvAG8AZAAgAHIAZQBsA GEAdABpAG8AbgBzAGgAaQBwACAA aQBzACAAYgBlAGMAYQB1AHMAZQAsACAAaABlACAAbwBuAGwAe QAgAGEAdAB0AGUAbgBkAGUAZAAg AG4AaQBnAGgAdAAgAHMAYwBoAG8AbwBsACAAdwBoAGkAbABlA CAATQByACAAUABoAGkAbABsAG8A dABzAG8AbgAgACAAdwBhAHMAIAB0AGUAYQBjAGgAaQBuAGcAI ABpAHQALgANAA0AMwANAE0AeQAg AGkAbQBwAHIAZQBzAHMAaQBvAG4AIABvAGYAIAB0AGgAZQAgA GMAbABlAHIAZwB5AG0AYQBuACAA dwBhAHMAIAB0AGgAYQB0ACwAIABoAGUAIABkAGkAcwBsAGkAa wBlAGQAIAB0AGgAZQAgAHMAaQBn AGgAdAAgAG8AZgAgAGMAaABhAG4AZwBlACwAIABhAG4AZAAgA GgAZQAgAGcAbwBlAHMAIABhAHcA YQB5ACAAdwBoAGUAbgAgAGgAZQAgAHMAZQBlAHMAIABpAHQAL gAgAEkAdAAgAG0AYQBrAGUAcwAg AG0AZQAgAHQAaABpAG4AawAgAHQAaABhAHQAIABoAGUAIABpA HMAIAB2AGUAcgB5ACAAZQBtAG8A dABpAG8AbgBhAGwAIABhAG4AZAAgAG4AbwB0ACAAaQBuACAAd ABvAHUAYwBoAGUAZAAgAHcAaQB0 AGgAIABoAGkAcwAgAGYAZQBlAGwAaQBuAGcALAAgACAAaQB0A CAAYQBsAHMAbwAgAG0AYQBrAGUA cwAgAG0AZQAgAHQAaABpAG4AawAgAHQAaABhAHQAIABoAGUAI ABpAHMAIABhACAAbwBsAGQAIABn AHUAeQAgAG0AbwBzAHQAIABsAGkAawBlAGwAeQAgAGkAbgAgA GgAaQBzACAANgAwACAAYQBzACAA bwBsAGQAZQByACAAcABlAG8AcABsAGUAIABhAHIAZQAgAG0Ab wByAGUAIABzAGUAdAAgAGkAbgAg AHQAaABlAGkAcgAgAHcAYQB5AHMALgANAA0ANAANAFQAdwBvA CAAcQB1AG8AdABlAHMAIAB0AGgA YQB0ACAAcwBoAG8AdwBlAGQAIAB0AGgAZQAgAHMAYwBoAG8Ab wBsACAAbQBhAHMAdABlAHIAIAB3 AGEAcwAgAHAAbwBwAHUAbABhAHIAIAB3AGEAcwAgABwgIAB0A GgAZQAgAHMAYwBoAG8AbwBsAG0A YQBzAHQAZQByACAAdwBhAHMAIABsAGUAYQB2AGkAbgBnACAAd ABoAGUAIAB2AGkAbABsAGEAZwBl ACAAYQBuAGQAIABlAHYAZQByAHkAYgBvAGQAeQAgAHMAZQBlA G0AZQBkACAAcwBvAHIAcgB5AB0g IABhAG4AZAAgAGEAbABzAG8AIAAcIFQAaABlACAAbQBpAGwAb ABlAHIAIABhAHQAIABDAHIAZQBz AHMAYwBvAG0AYgBlACAAbABlAG4AdAAgAGgAaQBtACAAdABoA GUAIABzAG0AYQBsAGwAIAB3AGgA aQB0AGUALAAgAHQAaQBsAHQAZQBkACAAYwBhAHIAdAAgAGEAb gBkACAAaABvAHIAcwBlACAAdABv ACAAYwBhAHIAcgB5ACAAaABpAHMAIABnAG8AbwBkAHMAHSAgA HQAaABlACAAcgBlAGEAcwBvAG4A IABJACAAdABoAGkAbgBrACAAdABoAGkAcwAgAHMAaABvAHcAZ QBUAQAADgAAAMjqEgAEAAAAAFRT SDgAAAA+AAAAYgAAAIYAAACQAAAAmgAAAKQAAACuAAAAuAAAAMIAAADWAAAA8AAAAA4BAAA0AQAA AAD/////DwBEAGUAZgBpAG4AaQB0AGkAbwBuACAAVABlAHIAbQAAAAAADwBEAGUAZgBpAG4AaQB0 AGkAbwBuACAATABpAHMAdAAAAAAAAgBIADEAAAAAAAIASAAyA AAAAAACAEgAMwAAAAAAAgBIADQA AAAAAAIASAA1AAAAAAACAEgANgAAAAAABwBBAGQAZAByAGUAc wBzAAAAAAAKAEIAbABvAGMAawBx AHUAbwB0AGUAAAAAAAwAUAByAGUAZgBvAHIAbQBhAHQAdABlA GQAAAAAABAAegAtAEIAbwB0AHQA bwBtACAAbwBmACAARgBvAHIAbQAAAAAADQB6AC0AVABvAHAAI ABvAGYAIABGAG8AcgBtAAAAAACO AgAAHAAAAMjqEgAAAAAAAFRTSHAAAAB+AAAAhgAAAJQAAACcAAAAqgAAALgAAADOAAAA2AAAAOgA AADyAAAAAgEAAAwBAAAWAQAAIAEAADABAAA6AQAASgEAAFQBA ABkAQAAbAEAAHoBAACOAQAAvgEA ABICAABEAgAAUAIAAIICAAAGAAoAAAAMIhjwAQAAAAMABAAAA AwiBgAKAAAADCIY8AEAAAADAAQA AAAMIgYACgAAAAwiGPABAAAABgAKAAAADSL4fAMAAAAKABIAA AACCgwioKYEABgi+HwDAAAABAAG AAAAGAoMIgcADAAAAAIKDCL4fAMAGCIEAAYAAAAYCgwiBwAMA AAAAgoMIoi2AgAYIgQABgAAABgK DCIEAAYAAAACCgwiBAAGAAAAGAoMIgcADAAAAAIKDCIY8AEAG CIEAAYAAAAYCgwiBwAMAAAAAgoM IuCMAQAYIgQABgAAABgKDCIHAAwAAAADCgwiGPABABgiAwAEA AAAAwoGAAoAAAAMIhjwAQABAAkA EAAAAA0i+HwDAA4i+HwDAAMAFwAsAAAADCIY8AEAJIogAAAAABgBAAgYAQAQGAEAGBgBACAYAQAw GAEAOBgBAAAAKQBQAAAAMoJKAAAAJxoLACiKQAAAAAggxUoJA BAgipUSABggT+AbACAgFCslACgg 2XUuADAgnsA3ADggYwtBAEAgKFZKAEgg7aBTAFAgsutcAAAAG AAuAAAADCLgjAEAFQokiiAAAAAA GAIACBgCABAYAgAYGAIAIBgCADAYAgA4GAIA2XUFAAgAAAAEE gLMAQAYAC4AAAAMIuCMAQAVCiSK IAAAAAAYAgAIGAIAEBgCABgYAgAgGAIAMBgCADgYAgDZdQUAC AAAAAQSAswBAAwAAAADAAAAAQAA AAMAAAAEAAAABAAAAHQAdAABAAAABAAAAAAAAAAAAAAAZBkAA AAaAAABAAAABAAAAAAAAAAAAAAA ZBkAAAAcAABcAAAAAwAAANDqEgAEAAAAAE9OVAwAAAAwAAAAT AAAAA8AVABpAG0AZQBzACAATgBl AHcAIABSAG8AbQBhAG4AAAABAgsAQwBvAHUAcgBpAGUAcgAgA E4AZQB3AGYAAwEFAEEAcgBpAGEA bAABAAICAwAAAAgAAAD/AAAAWQsAAFgAAAABAAAAAAAAAAoAAAAAIgEAAAAKAAAAACIHAAAACgAA AAAiBgAAAAOk+MNgEwAAZxsAAFgCAABYAgAAUQAAACkAAABPAAAAHgEAAHAiSwBIUCBQaG90b3Nt YXJ0IDcyMDAgU2VyaWVzAAAAAAAAAAEEAAacANQhQ++ABwEACQCaCzQIZAABAA8AWAICAAEAWAIC AAEAQTQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAEAAAAAAAAA AQAAAAIAAAAVAQAA/////wAAAAAAAAAAAAAAAAAAAABESU5VIgBIB4QJUBh3tZNsAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAEQAAAABAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAACwAAAAAA AAAAAAMAAAACAAAAAgAFAAAAAAAAAAAAAAABAAAAAQABAAEAA QAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAQAAAAEAAQABAAEAAQAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAEgHA ABTTVRKAAAAABAAOAdIAFAAIABQ AGgAbwB0AG8AcwBtAGEAcgB0ACAANwAyADAAMAAgAFMAZQByA GkAZQBzAAAASW5wdXRCaW4AQXV0 b21hdGljYWxseVNlbGVjdABSRVNETEwAVW5pcmVzRExMAEhQU HJlQW5hbHlzaXMARmFsc2UATVNQ cmVBbmFseXNpcwBGYWxzZQBIUFJlcG9ydFN5bW1ldHJpY01hc mdpbnMARmFsc2UASFBNaW5pbWl6 ZU1hcmdpbnMARmFsc2UASFBBbGlnbk1hcmdpbnNGb3JNRABUc nVlAEhQUHJpbnRQcmV2aWV3AEZh bHNlAEhQT3ZlclNwcmF5T3B0aW9uAEF1dG9tYXRpYwBIUE92Z XJTcHJheQAxMDAASFBCb3JkZXJM ZXNzUGhvdG8ARmFsc2UASFBCb3JkZXJMZXNzQXV0b0ZpdABGY WxzZQBIUEN1c3RvbUJvcmRlcmxl c3MAVHJ1ZQBIUE91dHB1dE9yZGVyUmV2ZXJzZQBUcnVlAFBhc GVyU2l6ZQBMRVRURVIAT3JpZW50 YXRpb24AUE9SVFJBSVQASFBTZW5kUHJlbG9hZENvbW1hbmQAV FJVRQBIUE5Vc2VEaWZmRmlyc3RQ YWdlQ2hvaWNlAFRydWUASFBEcnlUaW1lT3B0aW9uAEF1dG9tY XRpYwBIUERyeVRpbWUAMABIUElu a1ZvbHVtZU9wdGlvbgBBdXRvbWF0aWMASFBJbmtWb2x1bWUAT m9ybWFsAEhQUHJpbnRJbkdyYXlT Y2FsZQBGYWxzZQBQcmludFF1YWxpdHkATm9ybWFsAFByaW50U XVhbGl0eUdyb3VwAFBRR3JvdXBf NgBIUENvbG9yTW9kZQBDT0xPUl9NT0RFAEhQUERMVHlwZQBQR ExfUENMMwBIUFBvc3RlclByaW50 aW5nAEZhbHNlAEhQUG9zdGVyUHJpbnRpbmdPcHRpb24AUE9TV EVSXzIAQ29sb3JNb2RlAENvbG9y MjQASFBNaXJyb3JQcmludABGYWxzZQBUZXh0QXNCbGFjawBGY WxzZQBNZWRpYVR5cGUAUExBSU4A UmVzb2x1dGlvbgA2MDBkcGkAUFFEUEkASW5zdGFsbGVkAEhQQ XV0b0R1cGxleFNjYWxpbmcAVHJ1 ZQBIUFByaW50T25Cb3RoU2lkZXNNYW51YWxseQBGYWxzZQBIU E1hbnVhbER1cGxleERpYWxvZ0l0 ZW1zAEluc3RydWN0aW9uSURfMDFfRkFDRVVQLU5PUk9UQVRFA EhQTWFudWFsRHVwbGV4UGFnZVJv dGF0ZQBVc2VyUm90YXRlAEhQT3V0cHV0QmluT3JpZW50YXRpb 24ARkFDRVVQAEhQTWFudWFsRmVl ZE9yaWVudGF0aW9uAEZBQ0VVUABIUFNwZWVkTWVjaABGYXN0R HJhZnQASFBNYW51YWxEdXBsZXhE aWFsb2dNb2RlbABNb2RhbABIUE1hbnVhbER1cGxleFBhZ2VPc mRlcgBPZGRQYWdlc0ZpcnN0AEhQ TWFwTWFudWFsRmVlZFRvVHJheTEARmFsc2UAUFNBbGlnbm1lb nRGaWxlAEhQWjNBbGhuAFBTU2Vy dmljZXNPcHRpb24ATGF1bmNoVG9vbEJveABIUENsZWFuaW5nR mlsZXNEYXRhAEhQX0NsZWFuX1Rl c3RQYWdlAEhQQ29uc3VtZXJDdXN0b21QYXBlcgBIUEN1c3Rvb QBIUENvbG9yU2VsZWN0aW9uRm9y SFBBAEVuYWJsZWQASFBCb3JuT25EYXRlAEhQQk9EAEhQQ3Vzd G9tU2l6ZUNvbW1hbmQAVFJVRQBI UFJFU0RMTE5hbWUASFBGUkVTNTAASFBSZWRFeWVSZWR1Y3Rpb 24AT24ASFBEaWdpdGFsSW1hZ2lu ZwBIUEhvbWVQcmludGluZwBIUFNtYXJ0Rm9jdXMAT24ASFBDb 250cmFzdABPbgBIUERpZ2l0YWxG bGFzaABPbgBIUFNoYXJwbmVzcwBPbgBIUFNtb290aGluZwBPb gBIUEpwZWdQbmdQYXNzdGhyb3Vn aABUcnVlAEhQSFRETExOYW1lAEhQRklHbGhuAEhQTUhETExOY W1lAEhQRklNRTUwAEhQSFBBRmls dGVyAFRydWUASFBBZHZhbmNlZENvbG9yU2V0dGluZwBUcnVlA EhQQ1JEQ29tbWFuZABUcnVlAEhQ U2VuZFVuaXRNZWFzdXJlQ29tbWFuZABUUlVFAEhQWE1MRmlsZ VVzZWQAaHBwNzIwMHQueG1sAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAABQGAAASVVQSBAAEQAAAAAAAAAAA AAAAAABAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABAAEAZAABAAEAAgACAAAAAQAAAAIAAABBADQAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAJAJoLNAgAAP///////////////wEAAAAGAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAQAAAAAAAAABAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAWwBuAG8AbgBlA F0AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIABbAG4AbwBuAGUAX QAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAADQAAABQAAAAAAAAAAEAA AAAAAAAwMDAAAAAAADAwMAAAAAA AAAAAAAAAAAAAAAAAAkAAAABAAAAZAAAAAAAAAAAAAAAAAAAA AAAgD8AAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA QAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAE8AVwBOAEUAUgAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAEAAAAAAAAAAAAAAAEAAAAP AAAAFQEAAAAAAAAPAAAAFQEAAAAAAAD/////AAAAAAAAAAAPAAAAFQEAAA8AAAAVAQAAAAAAAAAA AAAAAAAAAAAAADQIAAA0CAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAQAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAZAAAAAEAAABNAGkAYwBy AG8AcwBvAGYAdACuACAAVwBvAHIAawBzACAAVwBvAHIAZAAgA FAAcgBvAGMAZQBzAHMAbwByAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAgAAAP////9Xa3NX UC5leGUAAAAAAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAA QAAAAEAAAABAAAAAQAAAAEAAAAB AAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABA AAAAQAAAAEAAAABAAAAAQAAAA8A AAAVAQAADwAAABUBAAAPAAAAFQEAAA8AAAAVAQAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAABDADoAXABQAFIATwBHAFIAQQB+ADEAXABNAEkAQwBSAE8AUwB+ADEAXABXAGsAcwBXAFAA LgBlAHgAZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAEgAtAAEAd 2luc3Bvb2wAAEhQIFBob3Rvc21h cnQgNzIwMCBTZXJpZXMAADE5Mi4xNjguMS4xMwAAAAAAAAAAA AAAAAAAAAAAAAIARgAAAAAa//8B Egf/BCJUqw8ABSKAxpoABiJQk1MAByIkYwUACCLwYBMACSLwYBMAExIWABgiAQAAABsiQQAAAC4i AQAAAEAAAAAAGv//ARIG/wQiVKsPAAUi8PkGAAYiUJNTAAciJGMFAAgi8GATAAki8GATABMSFgAY IgIAAAAuIgIAAABzAGEAdgBlAC4AdwBwAHMAAAAuAAAAACIwT XMAASKgJaMAAyLQaREABSLQaREA GBIBABkKKCIJBAAAKSIBAAAAAE4AZQB3AGYAAwEFAEEAcgBpA GEAbAABAAICAwAAAAgAAAD/AAAA WQsAAFgAAAABAAAAAAAAAAoAAAAAIgEAAAAKAAAAACIHAAAAC gAAAAAiBgAAAG4AZQAgAGkAYQBu AG8AIAB3AGkAdABoACAAaABpAG0ADQANADgADQBIAEoAdQBhA GQAYQB1AGQAZQAgAHQAaABvAHUA ZwBoAHQAIAB0AGgAYQB0ACAAaABpAHMAIABhAHUAbgB0ACAAZ gB1AGsAZQBsAGUALQBoAG8AdQBz AGUAIAB3AG8AdQBsAGQAIABiAGUAIABvAGYAIAB1AHMAZQAgA HQAbwAgAHQAaABlACAAcwBjAGgA bwBvAGwAIABtAGEAcwB0AGUAcgAsACAAYgBlAGMAYQB1AHMAZ QAgAGgAZQAgAHQAaABvAHUAZwBo AHQAIAB0AGgAZQAgAHMAYwABAP7/AwoAAP////+yWqQOCp7REaQHAMBPuTK6GgAAAFF1aWxsOTYg U3RvcnkgR3JvdXAgQ2xhc3MA/////wEAAAAAAAAA9DmycQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAAAABA AAAeaqdYAAAAAAFAAAAeaqdYAAA AACBqp1gBQAAAHmqnWAKAAAAgaqdYCwAAAB5qp1gNQAAAA8AA AB5qp1gAAAAAIGqnWCYAgAAeaqd YKUCAACBqp1gIwQAAHmqnWAtBAAAgaqdYK0EAAB5qp1gtwQAA IGqnWCUBgAAeaqdYJ4GAACBqp1g iAgAAHmqnWCSCAAAgaqdYMgIAAB5qp1g0ggAAIGqnWDuCAAAe aqdYPsIAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAA==

I know how to use join, that why I was asking would it bypass it, So i felt no need to give out my database layout

What I am trying to do is, make it list all the info in datebase1 but if the the review is in databse 2 and the reviewer name is the same as the person logged in it wont show. but using that while function, only show as many rows of info as it is in database2 so database 2 only = 3 rows database one only shows 3 rows @ mjdamato would doing it Join table ways bypass "o, if one result has 5 records and the other has 5,000 records, the loop will exit after five records are extracted from both because the first one will return false." ? Sorry I am not really good at explaining stuff

$sql7 = "SELECT * FROM $datebase1 Where series_name LIKE '$start_letter%' ORDER BY series_name "; $result7 = mysql_query($sql7) or exit(mysql_error()); $sql2 = "SELECT * FROM $memberreview_table"; $result2 = mysql_query($sql2)or exit(mysql_error()); while ($row = mysql_fetch_assoc($result7) and $row1 = mysql_fetch_assoc($result2) ) { $series_name = $row['series_name']; $review_name= $row1['anime_name']; $member_reviewer = $row1['reviewer_name']; if($review_name!=$series_name & $member_reviewer!=$signedin_username ){ $animeid = $row['animeid']; $pictures = $row['pictures']; $series_summary = $row['series_summary']; ?> <td class="picture" style="width:140px;"><img src="<?php echo $pictures ?>" alt="" width="100" height="100" /></td> <td align="left"><a href="./ana_new_review.php<?php echo "?id=".$animeid ?>"><?php echo $series_name ?></a></td> <td><a href="./ana_new_review.php<?php echo "?id=".$animeid ?>"><?php echo $series_summary ?> </a></td> <?php }} ?> What I am trying to do is, make it list all the info in datebase1 as long as the name of the review and the reviewer name is not the same but using that while function, only show as many rows of info as it is in database2 so database 2 only = 3 rows database one only shows 3 rows Sorry I am not really good at explaining stuff

Just change the file extension from html/htm to php open it up in notepad and press save as and put php at the end of its name

That is not what I wanted did you even read what i said? Also whats the point of having a long messy array when I can do it this way?

I got a text bow shown below, <input name="category[]" value="Action" type="checkbox"> Action </li> <li> <input name="category[]" value="Adventure" type="checkbox"> Adventure </li> <li> <input name="category[]" value="Bishounen" type="checkbox"> Bishounen </li> <li> <input name="category[]" value="Comedy" type="checkbox"> Comedy </li> <li> <input name="category[]" value="Demons" type="checkbox"> Demons </li> <li> <input name="category[]" value="Drama" type="checkbox"> Drama </li> <li> <input name="category[]" value="Ecchi" type="checkbox"> Ecchi </li> <li> <input name="category[]" value="Fantasy" type="checkbox"> Fantasy </li> <li> <input name="category[]" value="Harem" type="checkbox"> Harem </li> <li> <input name="category[]" value="Horror" type="checkbox"> Horror </li> <li> <input name="category[]" value="Josei" type="checkbox"> Josei </li> <li> <input name="category[]" value="Magic" type="checkbox"> Magic </li> <li> <input name="category[]" value="Mahou Shoujo " type="checkbox"> Mahou Shoujo </li> </ul></td> <td width="34%"><ul> <li style="float:none"> <input name="category[]" value="Martial Arts" type="checkbox"> Martial Arts </li> <li> <input name="category[]" value="Mecha" type="checkbox"> Mecha </li> <li> <input name="category[]" value="16Music" type="checkbox"> Music </li> <li> <input name="category[]" value="Mystery" type="checkbox"> Mystery </li> <li> <input name="category[]" value="Ninja" type="checkbox"> Ninja </li> <li> <input name="category[]" value="Parody" type="checkbox"> Parody </li> <li> <input name="category[]" value="Psychological" type="checkbox"> Psychological </li> <li> <input name="category[]" value="Reverse Harem" type="checkbox"> Reverse Harem </li> <li> <input name="category[]" value="Romance" type="checkbox"> Romance </li> <li> <input name="category[]" value="Samurai" type="checkbox"> Samurai</li> <li> <input name="category[]" value="School Life" type="checkbox"> School Life </li> <li> <input name="category[]" value="Science Fiction" type="checkbox"> Science Fiction </li> <li> <input name="category[]" value="Seinen" type="checkbox"> Seinen </li> </ul></td> <td width="33%"><ul style=" "> <li> <input name="category[]" value="Shoujo" type="checkbox"> Shoujo</li> <li> <input name="category[]" value="Shoujo Ai" type="checkbox"> Shoujo Ai</li> <li> <input name="category[]" value="Shounen" type="checkbox"> Shounen </li> <li> <input name="category[]" value="Shounen Ai" type="checkbox"> Shounen Ai </li> <li> <input name="category[]" value="Si-Fi" type="checkbox"> Si-Fi </li> <li> <input name="category[]" value="Slapstick" type="checkbox"> Slapstick </li> <li> <input name="category[]" value="Slice of Life" type="checkbox"> Slice of Life </li> <li> <input name="category[]" value="Sports" type="checkbox"> Sports </li> <li> <input name="category[]" value="Sucpernatural" type="checkbox"> Sucpernatural </li> <li> <input name="category[]" value="Thriller" type="checkbox"> Thriller </li> <li> <input name="category[]" value="Tragedy" type="checkbox"> Tragedy </li> <li> <input name="category[]" value="38" type="checkbox"> I know How to save the ticked ones to the database using implode(',', $_POST['category']) on the edit page I got the check list again, but I dont know how to go about ticking the once that have been put in the database

My bad this one *facepalm* <?php include_once "Common/header.php"; $connect=mysql_connect("localhost", "root", "")or die ("Could not connect to database"); mysql_select_db("test",$connect) or die (mysql_errno().":<b> ".mysql_error()."</b>"); $user1=$_SESSION['uname']; $sql1 = "SELECT * FROM Users WHERE Username ='$user1' "; $data = mysql_query($sql1); while ($row = mysql_fetch_assoc($data)) { $firstname=$row['First_Name']; $lastname=$row['Last_Name']; mysql_query($data) or exit(mysql_error()); } echo $data; Print "<table border cellpadding=3>"; Print "<tr>"; Print "<th>First Name:</th> <td>".$firstname . "</td> "; Print "<th>Last:</th> <td>".$lastname. " </td></tr>"; Print "</table>"; ?>

untested but should work <?php include_once "Common/header.php"; $connect=mysql_connect("localhost", "root", "")or die ("Could not connect to database"); mysql_select_db("test",$connect) or die (mysql_errno().":<b> ".mysql_error()."</b>"); $user1=$_SESSION['uname']; $data = mysql_query("SELECT * FROM Users WHERE Username ='$user1' "); while ($row = mysql_fetch_assoc($data)) { $firstname=$row['First_Name']; $lastname=$row['Last_Name']; } mysql_query($data) or exit(mysql_error()); echo $data; Print "<table border cellpadding=3>"; Print "<tr>"; Print "<th>First Name:</th> <td>".$firstname . "</td> "; Print "<th>Last:</th> <td>".$lastname. " </td></tr>"; Print "</table>"; ?> Login Successful <?php include_once "Common/footer.php"; ?>

yep $data = mysql_query("SELECT * FROM Users WHERE Username ='".$_SESSION['uname']."'") or die(mysql_error()); Or I would do it like looks better, $user1=$_SESSION['uname']; $data = mysql_query("SELECT * FROM Users WHERE Username ='$user1' ") or die(mysql_error());

If they login Successful you could make there user name a session, and do it like that

There no point telling it user $username=$_POST['username5']; then using $_POST['username5']; in the query <?php include ('connection.php'); $username=$_POST['username5']; $password=$_POST['password5']; $query="SELECT password FROM merchants WHERE username = '$username'"; if ($password == $query) { $url = "SELECT url FROM merchants WHERE username = '$username'"; header("Location: $url"); } else { //change later echo urgh; } ?> What error are you getting? You could use the one below thats working it will do the same thing as your one <?php $username = $_POST['username']; $password = $_POST['password']; $sql="select * from merchants WHERE username='$username' and password='$password' "; $res=mysql_query($sql); if(!$res) { die('error loging'); } $row=mysql_fetch_array($res); if(mysql_num_rows($res)>0) { $url = "SELECT url FROM merchants WHERE username = '$username'"; header("Location: $url"); } else {//change later echo urgh; } ?>