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");

Did you know?Explore Trending and Topic pages for more stories like this.
when I output the names from the players table. I am getting four duplicate records.
No comments posted yet

Your Answer:

Login to answer
178 Like 15 Dislike
Previous forums Next forums
Other forums

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error

Asset Transfer from One plant to another within same company code
Hi,

Please advise how to transfer one asset from one plant to another plant within same c

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown

pspell
using pspell, is it possible to get words that would be best in the current phrase?

For examp

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash