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

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

max() problem
I have a while loop to get image names.
Code: $imagequery = mysql_query("SELECT * FROM ad_i

Shuffle Array
Hi,

I am writing a script for a game that needs players to randomly be assigned a target (ano

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

Object Interfaces
EDIT: Never mind, I just updated to php 5.

Hey all,

I'm currently experimenting with p

Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.

However

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

Varible in trigger - refering to correct schema
Hello

Im having some issues with my trigger.
What I want to do is call opon a differ

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_