nealec

Thanks, works perfect now, guess i should have known that.

All the other scores come out in correct order apart from 10. The score column contains just numbers. mysql_query("SELECT score FROM scores ORDER BY score DESC");

Sorry my bad, i meant that 10 is always the lowest number.... 10, 3, 3, 7, 8, 9.

Im displaying scores from my database from highest to lowest but 10 always comes out first. Why?

Oh sorry ignore the last post the link seems to be for sample terms and conditions page for a completley different type of site, my mistake.

I dont really know of any sites like the one im making thats why i thought i should make on, but while looking around i did come across this but as i haver never even read a terms and agreements page let alone wrote one most of goes straight over my head so im lost as to what i would do with it. http://www.businesslink.gov.uk/bdotg/action/detail?itemId=1076142035&type=RESOURCES

OK it looks like that may unfortunatley be my only option for now but id rather not put anything up thats going to deter people as the site i am making will be more useful to the people in my area if it has the maximum amount of registered users, and i am not being payed to make this site and its not going to make me any money its just something i wanted to do so i cant really afford to pay a solicitor (I live in UK) to write these pages for me. Is there any kind of guides or templates that you know of that may be of any use?

Ok great thankyou both for the info. Before i go can you tell me how important pages like terms and conditions and privacy are for this kind of site because i have never used them before but it feels like something i will need for a site that my whole community will hopefully be using. Am i at risk of any kind of legal action if i dont have these pages?

Sorry to go off subject for a second but i just had a look at the link you provide about not using w3schools, which im afraid i have been unaware that they were not correctly advising people. the w3fools page lists a few good links for html, css, and javascript but there doesnt seem to be any for php, do you know of any?

Step 1 im afraid, i have had a very quick look at this sort of thing and have come across such things a SHA1 and SQL Injection but have no real idea what they are or how to implement them.

Sorry, yes they will be entering their email, passwords, names, username, phone numbers and uploading photos using multiple forms and it will all be inserted into a mysql database.

I have nearly finished a website that i am making for my local community, they will be registering on the site and i am wandering what sort of security for the site i should be thinking about. I just dont want someone out there doing something to cause problem with the site and ruining it for everyone else.

This just sends me multiple emails with a different name in each one rather than all the names in one email. <?php $servername="*******"; $username="*******"; $password="*******"; $conn= mysql_connect($servername,$username,$password)or die(mysql_error()); mysql_select_db("*******",$conn); $result = mysql_query("SELECT name FROM people WHERE mail='yes' "); while($row = mysql_fetch_array($result)){ $to = "[email protected]"; $subject = "People names"; $body = "This is a list of all names in database. $row[name]"; mail($to, $subject, $body); } ?>

I am trying to send a list of every name in a database via email but everything i have tried just sends lots of emails with a different name in each email. How can i send every name in one email?

When i upload photos and the name of the photo i would like to be able to overlay a portion of the original photo with another image already in the site directory, and also add the photos name over the top of the overlayed image, i may have explained this in a confusing way so i have attached an example. Is this something that can be done using something like GD or imagick, if so could someone please give me a good place to start.