PHP MYSQL Returning Result Two Times (Double)

Question

SQL Quires is displaying multiple values

i mean if sql query actually out put is like this :

10456123   4561265    12   13   45  55   66
45869655   4556446    99   56   45  45   45

it is displaying as :

10456123   4561265    12   13   45  55   66
45869655   4556446    99   56   45  45   45
10456123   4561265    12   13   45  55   66
45869655   4556446    99   56   45  45   45

It is Showing DOUBLE times (2times)

You are actually executing two queries and printing out the results of both. Could it be that both actually have the same result? — Ulrich Schmidt-Goertz
– Ulrich Schmidt-Goertz, Commented Aug 23, 2013 at 14:10
@UlrichSchmidt-Goertz i used 2 quires because, i didn't know understand how to do this in a single query :( — user2704822
– user2704822, Commented Aug 23, 2013 at 14:14
Ok, I see. Well, have you tried executing the query (it would be $sql) on the database directly? — Ulrich Schmidt-Goertz
– Ulrich Schmidt-Goertz, Commented Aug 23, 2013 at 14:17
Did you try running the queries directly in MySQL or some tool like phpMyAdmin and see what the results are? Maybe your query is wrong and it is giving duplicate results. — Technoh
– Technoh, Commented Aug 23, 2013 at 14:17

DARK_A · Accepted Answer · 2014-12-23 14:34:13Z

1

Try adding DISTINCT:

SELECT DISTINCT * 
  FROM 32r07,
       32r07names 
 WHERE 32r07.htno = 32r07names.htnon 
   AND 32r07.htno = '$name'

SELECT DISTINCT * 
  FROM 32r07names 
 WHERE htnon = '$name'

This is not plroblem solver, but it will help. also, DO NOT use *. I think you need to check for duplicate values in tables.

edited Dec 23, 2014 at 14:34

answered Aug 23, 2013 at 14:30

DARK_A

5751 gold badge7 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2704822 Over a year ago

i'm sure there are no duplicate values. you said ` DO NOT use *` did this mean, should i write all column names there with (comma) separated..

user2704822 Over a year ago

there are no duplicate values... is there any change that this can be done in a single query... i used this (32r07.htno = 32r07names.htnon ) just to check that the input is in both tables....

DARK_A Over a year ago

Yes, I mean write all columns. Try query in SQL Developer first. Do you found problem?

erKURITA · Accepted Answer · 2013-08-23 14:28:24Z

0

You are actually executing (almost) the same query twice:

SELECT * FROM 32r07, 32r07names WHERE 32r07.htno = 32r07names.htnon AND 32r07.htno = '$name';

could be rewritten as

SELECT * FROM 32r07 INNER JOIN 32r07names ON htno = htnon WHERE 32r07.htno = '$name';

The second query being

SELECT * FROM 32r07names WHERE htnon = '$name';

Which is like saying, altogether:

... WHERE htnon = htno = '$name';

answered Aug 23, 2013 at 14:28

erKURITA

4073 silver badges13 bronze badges

2 Comments

user2704822 Over a year ago

this didn't help :( i tried SELECT * FROM 32r07 INNER JOIN 32r07names ON htno = htnon WHERE 32r07.htno = '$name'; but same :(

erKURITA Over a year ago

Yes, you should use one query, not both. Try adding more data, specially data that would show up using one query but not the other.

Collectives™ on Stack Overflow

PHP MYSQL Returning Result Two Times (Double)

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related