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 = "myemail@myemail.com"; $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 - my@email.co.uk

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 - my@email.co.uk <?php $dbhost = ''; $dbuser = ''; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db("", $conn); $name = "My Name"; $from = "my@email.co.uk"; $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 my@email.co.uk" but i really want to add my name

This is the phpmailer.php file 17302_.php

Ok when i set up the ajaxim i noticed it created some tables on my database, one of them is ajaxim_users, i already have a table called user for when people log in to my main site, i simply want the ajaxim to detect users from the table that i already have, 'user' so that the people registered on my site dont have to re register with the ajaxim, i have looked through all the files that come with the ajaxim and i cant seem to find where its says to look for users in ajaxim_users so i can just change it to ' user'

Hi i have just installed ajaxim on my site but im not sure how to integrate it with my login system, on the site someone said 'You will have to cre­ate your own library that authen­ti­cates against your exist­ing data­base. It would be use­ful to look at the var­i­ous library scripts that are included with Ajax IM.' Now i have had a look at the files they suggested but it makes no sense to me what so ever, can somebody please help me.

Yeah Any other ideas?

Like this? <?php session_start(); require_once 'database.php'; ?> <?php require_once dirname(__FILE__)."/src/phpfreechat.class.php"; $params = array(); $params["title"] = "Nealeweb Chat"; $params["nick"] =$_SESSION['user']; $params['firstisadmin'] = true; //$params["isadmin"] = true; // makes everybody admin: do not use it on production servers $params["serverid"] = md5(__FILE__); // calculate a unique id for this chat $params["debug"] = false; $chat = new phpFreeChat( $params ); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>phpFreeChat- Sources Index</title> <link rel="stylesheet" title="classic" type="text/css" href="style/generic.css" /> <link rel="stylesheet" title="classic" type="text/css" href="style/header.css" /> <link rel="stylesheet" title="classic" type="text/css" href="style/footer.css" /> <link rel="stylesheet" title="classic" type="text/css" href="style/menu.css" /> <link rel="stylesheet" title="classic" type="text/css" href="style/content.css" /> </head> <body> <div class="menu"> <p class="partner"> <br/> </p> </div> <div class="content"> <?php $chat->printChat(); ?> <?php if (isset($params["isadmin"]) && $params["isadmin"]) { ?> <p style="color:red;font-weight:bold;">Warning: because of "isadmin" parameter, everybody is admin. Please modify this script before using it on production servers !</p> <?php } ?> </div> <div class="footer"> <font color="#FFFFFF"> <span class="partners">phpFreeChat partners:</span> </font><font color="#FFFFFF">jeux gratuits | </font><font color="#FFFFFF">jeux flash | </font><font color="#FFFFFF">pronofun</font><font color="#FFFFFF"> | </font><font color="#FFFFFF">areno</font><font color="#FFFFFF"> | </font><font color="#FFFFFF">micropolia</font><font color="#FFFFFF"> | </font><font color="#FFFFFF">zeitoun</font><font color="#FFFFFF"> | </font> <a href="http://federation.jeu-gratuit.net"><font color="#FFFFFF">federation</font></a> </div> </body></html>

This is the whole database.php file minus my password, username and database name <? $con = mysql_connect('localhost','Username','Password'); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db('Database name'); ?>