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.

I am new to coding and have no clue about sessions cookies or anything needed to create a way for people to securely register and login to a site. The site i have planned i expect (hope) to be used by my entire community so i really need to get it right without any vunerabilities. Can anyone suggest any good resources or tutorials or anything that might help me?

Ok i gave it a go but im still getting the email from ****@cpanel42.uk2.net instead of, My Name - [email protected]

Could you please explain or show me what you mean, its taken me almost 3 days just to get this far, im new to scripting or coding.

Trying to send email to all users in db all works fine but it wont use my name or email. when i check inbox they are all from ****@cpanel42.uk2.net, i need it to look like, From: My Name - [email protected] <?php $dbhost = ''; $dbuser = ''; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db("", $conn); $name = "My Name"; $from = "[email protected]"; $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1rn"; $headers .= 'From: '.$name.'<'.$from.'>'."\n"; $subject = "Subject"; $body = $message; $query = mysql_query("SELECT email FROM users") or die(mysql_error()); while(list($email) = mysql_fetch_row($query)) { mail($email, $subject, $body, $headers); } ?> I can get it to use just my email if i add "-f [email protected]" but i really want to add my name

This is the phpmailer.php file 17302_.php