HSX Forums: Playing & Trading Strategy Board






Or, I could not put the same data into the DB more than once.

Posted by: KaiGee on Dec 17, 13:59 in response to Triggered's post Maybe use SELECT DISTINCT in your SQL query, or add the...

Garbage in, garbage out, as they say.

Memo to KaiGee...StarBond Changes for Nov 21, 2018 has double entries. {nm}   mrbinns on Dec 14, 18:23

Well s#!t. What else can go wrong. {nm}   KaiGee on Dec 16, 19:19

Maybe use SELECT DISTINCT in your SQL query, or add the query results to a PHP Set {nm}   Triggered on Dec 17, 11:46

Or, I could not put the same data into the DB more than once.   KaiGee on Dec 17, 13:59

Well, ya, if you want to go with a simple, easy fix.... :) {nm}   DTravel on Dec 17, 17:00





Post a Reply

To post to the forums you must first login!

Untitled Ben Affleck Movie aka T (HASBN) 99999 32.41 (+0.09)         No Manches Frida 2 (NMFR2) 100000 9.57 (-0.03)         Those Who Wish Me Dead (TWWMD) 39999 16.43 (+0.11)         Those Who Wish Me Dead (TWWMD) 100000 16.43 (+0.11)         The One and Only Ivan (OIVAN) 34999 33.68 (-0.38)         Christian Bale (CBALE) 20000 31.81 (+0.24)         The Princess Diaries 3 (PDIA3) 100000 49.26 (+8.10)         The Sun Is Also a Star (TSIAS) 20000 21.83 (+0.09)         Transformers 7 (TFRM7) 34999 41.12 (-0.52)         The Sun Is Also a Star (TSIAS) 20000 21.83 (+0.09)         Gloria Bell (GLORB) 99999 5.66 (+1.13)         The American (AMERI) 34999 3.90 (+0.60)         The Stand-In (STNDN) 100000 13.48 (-0.20)         Dora and the Lost City of Gold a (DORAE) 30000 73.62 (+2.92)         Shazam! H$45 Put (SHAZM.PU) 20000 1.59 (+0.02)         Pet Sematary H$25 Call (PETSM.CA) 20000 2.91 (+0.11)         Stockholm (STKHM) 12989 1.54 (+0.03)         The Friend (TFRND) 49999 15.19 (+1.60)         The Killer (KILER) 99997 17.90 (-1.05)         The Killer (KILER) 99000 17.90 (-1.05)         Captive State (CAPST) 100000 6.18 (-0.63)         Captive State (CAPST) 100000 6.18 (-0.63)         Richard Armitage (RARMI) 50 173.77 (+0.28)         Dumbo H$70 Call (DUMBO.CA) 20000 3.88 (+0.09)         Shazam! (SHAZM) 100000 125.11 (+4.16)         Shazam! H$45 Call (SHAZM.CA) 20000 3.43 (+0.19)         The Princess Diaries 3 (PDIA3) 100000 49.26 (+8.10)         Wish Dragon (WDRGN) 100000 40.01 (-0.20)         Peter Rabbit 2 (PRAB2) 100000 64.91 (-0.26)         The Princess Diaries 3 (PDIA3) 100000 49.26 (+8.10)         A Star Wars Story 3 (SWAR3) 100000 113.64 (+2.40)         A Star Wars Story 3 (SWAR3) 100000 113.64 (+2.40)         In Fabric (NFBRC) 40000 2.05 (+0.24)         The British Fund (BRITS) 10000 20.28 (+0.07)         In Fabric (NFBRC) 40000 2.05 (+0.24)         Nicole aka Noelle (NICOL) 40000 1.89 (-0.09)         Nicole aka Noelle (NICOL) 40000 1.89 (-0.09)         The Farewell (TFRWL) 10000 7.04 (-0.06)         The Princess Diaries 3 (PDIA3) 99975 49.26 (+8.10)         Call Jane (CALLJ) 100000 2.32 (-0.15)         The Farewell (TFRWL) 40000 7.04 (-0.06)         Unicorn Store (UNICS) 1131 0.77 (-0.03)         Honey Boy (HONYB) 99999 1.79 (-0.08)         Dumbo (DUMBO) 50000 186.97 (-0.54)         Captive State (CAPST) 50000 6.18 (-0.63)         Us (US) 70000 157.58 (-0.38)         Sigourney Weaver (SWEAV) 1000 21.86 (-0.08)         Luce (LUCE) 100000 2.03 (-0.14)         Sigourney Weaver (SWEAV) 1000 21.86 (-0.08)         Lucy in the Sky (PBDOT) 15000 14.60 (-0.72)