• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
wrong id returned in join

#9
(01-07-2016, 05:23 AM)PaulD Wrote: It is strange because I have never had that issue despite using many joins with '*' as select criteria.

I assume that table 1 has id as a primary key, if not that might be the cause.

I don't have the time to recreate the problem. But the problem comes within the PHP.

Mysql returns both ids from those 2 tables - id=13 and id=14.
But when PHP try to put them into PHP array(object) its not possible to keep them both so 1 of them is ignored and lost.
You know that $row['id'] can return just 1 value. Smile

For that reason its good always to specify SELECT fields or to be sure that you got what you need..
Best VPS Hosting : Digital Ocean
Reply


Messages In This Thread
wrong id returned in join - by frocco - 01-06-2016, 12:57 PM
RE: wrong id returned in join - by PaulD - 01-06-2016, 01:03 PM
RE: wrong id returned in join - by frocco - 01-06-2016, 01:11 PM
RE: wrong id returned in join - by sv3tli0 - 01-06-2016, 01:11 PM
RE: wrong id returned in join - by frocco - 01-06-2016, 01:20 PM
RE: wrong id returned in join - by sv3tli0 - 01-06-2016, 01:25 PM
RE: wrong id returned in join - by frocco - 01-06-2016, 01:32 PM
RE: wrong id returned in join - by PaulD - 01-07-2016, 05:23 AM
RE: wrong id returned in join - by sv3tli0 - 01-07-2016, 05:32 AM
RE: wrong id returned in join - by PaulD - 01-07-2016, 06:19 AM
RE: wrong id returned in join - by frocco - 01-07-2016, 07:04 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.