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

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

The page should be expire when cilck back button
hi,
i'm new to php world.
i create user registration page.
when i submit it,data goes to my

PHP hyperlinks generator
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

Storing/displaying image urls in a database?
Hi
Basically I have the following scenario:
User chooses picture from list. Picture info is ad

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "