SQL Querry Help

[TheJoey]

Hi im having trouble trying to create a querry that will retrieve codeID, Firstname & lastname of people i have playing on my server that only play pacman, then displays how many times they have played it.

 

[Coreye]

What problems are you having? Post the code and we'll be able to help you better...

[TheJoey]

Besides from the simple

 

Select CodeID, Firstname, Lastname

FROM GAMERS

 

ive very new to querrys.

Any help very much appeciated, and its the only sql i use in my whole website.. im only trying to test something.

[kickstart]

Hi

 

From the very basics.

 

Firstly you need to connect to the database server, using a userid and password. Something like:-

 

$dbhost = 'www.mydb.com';

$dbuser = 'myUserid';

$dbpasswd = 'myPassword';

 

$conn = mysql_connect($dbhost,$dbuser,$dbpasswd);

 

Then select the actual database:-

 

$dbname = 'myDatabaseName';

mysql_select_db($dbname,$conn ) or die('Could not select database.'.mysql_error());

 

Then set up your piece of SQL.

 

$sql = "Select CodeID, Firstname, Lastname FROM GAMERS";

 

Execute the SQL, bringing back a result:-

 

$result = mysql_query($sql);

 

Then loop around bring back each row until you have processed them all / processed the ones you care about. This is executing mysql_fetch_assoc which grabs the next row from $result and puts it into an associative array which is assigned to $row.

 

while( $row = mysql_fetch_assoc($result) )

{

echo $row['CodeID']." ".$row['Firstname']." ".$row['Lastname'];

}

 

Hope those basics help.

 

All the best

 

Keith

[TheJoey]

Thanks how would i run the sql so just show people who play pacman

 

[corbin]

What does your database layout look like?