PHP MYSQL problem hjälp

2009-08-22 21:08

Permalänk

Borny

Medlem

Plats: London
Registrerad: Jul 2003

●

PHP MYSQL problem hjälp

Hejsan håller på med php/mysql men har kört fast mig lite.

Vill visa den sista raden i databasen där resultat har lagts till.

För tillfället visas sista raden i databasen:

$query = "SELECT gpk_team.tmName as fixTeam1, gpk_team2.tmName as fixTeam2, gpk_fixture.fixScore1, gpk_fixture.fixScore2, gpk_fixture.fixDate
FROM `gpk_fixture`
LEFT JOIN gpk_team ON gpk_fixture.fixTeam1 = gpk_team.tmID
LEFT JOIN gpk_team as gpk_team2 ON gpk_fixture.fixTeam2 = gpk_team2.tmID
order by fixscore
DESC LIMIT 1";

Men vill visa sista raden där gpk_fixture.fixScore2 and gpk_fixture.fixScore1 = not null.

Trodde detta skulle funka

$query = "SELECT gpk_team.tmName as fixTeam1, gpk_team2.tmName as fixTeam2, gpk_fixture.fixScore1, gpk_fixture.fixScore2, gpk_fixture.fixDate
FROM `gpk_fixture`
LEFT JOIN gpk_team ON gpk_fixture.fixTeam1 = gpk_team.tmID
LEFT JOIN gpk_team as gpk_team2 ON gpk_fixture.fixTeam2 = gpk_team2.tmID
where fixdate = not null
order by fixdate;

DESC LIMIT 1";

Ifall nån kan hjälpa mig så skulle jag var jätte glad.

mvh
Joel

Visa signatur

AMD OPTERON athlon 3800 x2. DFI LANPARTY nforce 4ULTRA D, 2x1 gig twinmos Chassi Themlake 3,3| GC = Powercoler x850 XT Vivo, Logitech G15, Aiwa surround System, NEC DVD Burner, 1 x 1 x 200 gig 1x500 gigmaxtor SATA 1, 1 x180 gig Western Digital 1x320 western

Rapportera Redigera

Citera flera Citera

2009-08-22 22:18

Permalänk

Borny

Medlem

Plats: London
Registrerad: Jul 2003

●

Detta löste problemet :D..
where fixscore1 > 0

Visa signatur

AMD OPTERON athlon 3800 x2. DFI LANPARTY nforce 4ULTRA D, 2x1 gig twinmos Chassi Themlake 3,3| GC = Powercoler x850 XT Vivo, Logitech G15, Aiwa surround System, NEC DVD Burner, 1 x 1 x 200 gig 1x500 gigmaxtor SATA 1, 1 x180 gig Western Digital 1x320 western

Rapportera Redigera

Citera flera Citera

2009-08-22 23:10

Permalänk

Milky Way

Medlem

Plats: Stockholm
Registrerad: Feb 2006

●

NULL är lite speciellt, så man får använda "IS NULL" och "IS NOT NULL". T.ex. "WHERE fixscore1 IS NOT NULL" eller "WHERE fixscore1 IS NULL".

Visa signatur

Dator: i5-13600K, Asus Prime Z690-P, Noctua NH-D14, Kingston Fury Beast RGB 32GB DDR5-6000, Gigabyte RTX 4090 gaming OC, Seasonic Platinum SS-1000XP, Lian-Li Lancool 215, Samsung 980Pro 2TB M.2 NVME, Acer Predator XB323QKNV 4k 144Hz

Rapportera Redigera

Citera flera Citera

PHP MYSQL problem hjälp

PHP MYSQL problem hjälp

Externa nyheter

Spelnyheter från FZ