Query output more than expected

Posted on 16th Feb 2014 07:03 pm by admin

$query=mysql_query("SELECT * FROM players, communities, divisions WHERE dob BETWEEN '{$start_date}' AND '{$end_date}' and communities.id=players.community order by communities.community, communities.church, lname, fname");

when I output the names from the players table. I am getting four duplicate records.

Your Answer:

Login to answer

Other forums

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.

In a nutshell, the first page is entirely html

Can't get the unicode character
I'm trying to get some text from various parts of a file. I have converted the file to hex (bin2hex)

Help with simple query
Hi,

I'm trying to do a Query with a Union where I want to print the number of rows $tc conta

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

UDP server recvfrom() always returns -1? :(
Hello all,
I am getting a very strange error in my code :( I am writing a server application in C

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi