Maq

Are there errors? What does the output look like? What do you want it to look like? You need to be a little more descriptive...

I would recommend something like this so you can easily debug: $sql = "SELECT * FROM `$tablename` WHERE $sort > 699 LIMIT 1"; $result = mysql_query($sql) or die(mysql_error()); -You don't need anything around $tablename because your whole string is in double quotes and WILL interpolate properly -If I recall correctly, you can use reserved words for table names if you have them encapsulated with backticks, but you don't need them. -Put the statement in a string first so you can echo it out if there are any problems. -Use the or die() clause to output specific MySQL errors. -Like micah mentioned, do you really want the LIMIT 1 in there, it will return only 1 record...?

Have you checked with the phpBB Community?

Oh ok, so that's steam's algorithm to create the steam community id for the profile page?

EDIT: sorry misread the question....

How are you "saving" it? Can we see some ???code???

Yes.

You might want to look at SQL Inject Me (you can download it as a firefox plugin). On your registration page it says you have 27 failures for SQL Injections.

That really doesn't help at all cause then we would need to know what store_data returns...

What are you talking about, $var1 $var2? Read the manual link I provided it will explain it a lot better than I can, it also provides many examples.

Not knowing what the values of the variables, it's kind of hard to tell. Looks like it calls a PHP script that dumps something into $output. $retval is the return value from the system call. Read the manual on system().

* The above function is assuming that there will always be 10 characters before the actual calculating number. (I'm almost positive it's always the same because I use to be addicted to CS:S, in fact the only difference I can remember is that the 1 changes to a 2 for banned accounts or something like that) Just out of curiosity, what exactly is the purpose of this algorithm? Seems so random...

I made a function for you: function getSteamResult($id) { $sum = substr($id, 10); $sum *= 2; //result=24691356 $sum += 76561197960265728; //result=7656119845409284 $sum += substr($id, 10, 1); //9Th character from $result->id) result=7656119845409285 return $sum; } $id = "STEAM_0:1:12345678"; echo getSteamResult($id); ?>

By better you mean, separated by commas or a custom format? If you have a custom format, I would do something like this: You can replace this part of your code with the excerpt below it: $propertyuse = $_POST['propertyuse'] ; $loantype = $_POST['loantype'] ; $interestrate = $_POST['interestrate'] ; $loanamount = $_POST['loanamount'] ; $propvalue = $_POST['propvalue'] ; $downpayment = $_POST['downpayment'] ; $propaddress = $_POST['propaddress'] ; $city = $_POST['city'] ; $state = $_POST['state'] ; $zipcode = $_POST['zipcode'] ; $firstname = $_POST['firstname'] ; $middleinitial = $_POST['middleinitial'] ; $lastname = $_POST['lastname'] ; $ss1 = $_POST['ss1'] ; $ss2 = $_POST['ss2'] ; $ss3 = $_POST['ss3'] ; $maritalstatus = $_POST['maritalstatus'] ; $homephone1 = $_POST['homephone1'] ; $homephone2 = $_POST['homephone2'] ; $homephone3 = $_POST['homephone3'] ; $email = $_POST['email'] ; $age = $_POST['age'] ; $yearsofschool = $_POST['yearsofschool'] ; $dobmonth = $_POST['dobmonth'] ; $dobday = $_POST['dobday'] ; $dobyear = $_POST['dobyear'] ; $coborrower = $_POST['coborrower'] ; $cofirstname = $_POST['cofirstname'] ; $comiddleinitial = $_POST['comiddleinitial'] ; $colastname = $_POST['colastname'] ; $coss1 = $_POST['coss1'] ; $coss2 = $_POST['coss2'] ; $coss3 = $_POST['coss3'] ; $comaritalstatus = $_POST['comaritalstatus'] ; $cohomephone1 = $_POST['cohomephone1'] ; $cohomephone2 = $_POST['cohomephone2'] ; $cohomephone3 = $_POST['cohomephone3'] ; $coemail = $_POST['coemail'] ; $coage = $_POST['coage'] ; $coyearsofschool = $_POST['coyearsofschool'] ; $codobmonth = $_POST['codobmonth'] ; $codobday = $_POST['codobday'] ; $codobyear = $_POST['codobyear'] ; The above code can be condensed to this: foreach($_POST as $key => $value) { //this will dynamically create all of your post variables with the name of your //POST and assign the value to the value of the POST. $$key = $value; } Now you can use the variables you assigned before and format them in your desired manner. Hope this is what you mean, let me know if it's not and provide more detail so we can work out an appropriate solution.

Lol, I highly doubt the professor was lying to you... You probably weren't paying attention or didn't understand what the professor was talking about so you just made an assumption.

Lol, No they're not... I hope this isn't how you set up any of your systems... The characters are replaced with dots when you type, but that's not considered encrypted...

What are the errors...? 1) Use tags 2) Use <?php NOT , you are using what is called short tags that could cause problems if you don't have them enabled. 3) If you put this at the top of your page it may help you in the future as a debugging tool: ini_set ("display_errors", "1"); error_reporting(E_ALL); 4) You can just do something like this: foreach($_POST as $key => $value) { $message .= $value . "\n\r"; } mail ("aferrino@imstradingusa.com", "Loan Information", $message); EDIT: beaten to it, but I'll leave it up because I have a few tips in it.

Here's a very basic example & explanation, Tizag. If you search the forums for, "SQL Injections", you should find more than enough information.

Lol, I was just going to mention that. Before you use $_GET['id'] in the SQL statement, it's a good idea to sanitize it to prevent SQL Injections: $id = mysql_real_escape_string($_GET['id']); $query = "SELECT id, title, content, FROM_UNIXTIME(date+21600, '%W %D %M %Y at %h:%i %p') as dttm FROM news WHERE id='$id'"; You don't need single quotes if id is an integer (auto_increment).

For the future could you use tags. We also have a section specifically for MySQL Help.

First of all, I'm a he you incompetent little prick. Second, you're the one asking for help with BASIC CSS for trying to put a banner on top of the page, lol... Haku is right, be grateful I even tried to help you, I will put you on my list of kids not to help for now on. It's funny how no one else has complained, except for you...

border="0"

What banner? And better than what (code)?

Hehehe. If it is [sOLVED] please mark as so.

$type = $_POST['type']; I also thought you were using the GET method (grabbing the type value from the URL? So shouldn't that line be: $type = $_GET['type']; ?