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.

Other php-forum

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

Is there a more efficient way to code this than what I have?
I have three associative arrays.

$combinedSettings
$userSettings
$defaultSettings

Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.

I have images like this:

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

Not loading image
When this function gets loaded it doesn't load the image just trying to figure out why.

Code:

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam