12. maj 2006 - 13:24Der er
5 kommentarer og 1 løsning
SQL statement i PHP script
Jeg har det her script jeg skal bruge i PHP
Kan jeg bare skkrive det ind saadan her, eller er der noget med nogle kommaer, koloner er eller noget andet?
<<STATEMENT>> SELECT i.individ AS [ID], i.firstName AS [First Name], i.lastname AS [Last Name], MAX(e.eventtime) as [Last Read] FROM individuals AS i LEFT JOIN cards AS c ON i.individ = c.indivndx AND i.tenantndx = c.tenantndx JOIN events AS e ON i.individ = e.indivndx AND i.tenantndx = e.tenantndx AND i.accessverndx = e.accessverndx JOIN eventtypes as et ON e.eventtypendx = et.eventtypeid WHERE e.eventtypendx IN (14,16) AND (e.floatvalue <> 1.0) GROUP BY i.individ, i.firstName, i.lastname ORDER BY i.individ, i.firstName, i.lastname, [Last Read] DESC <<STATEMENT>>
$sql="SELECT i.individ AS [ID], i.firstName AS [First Name], i.lastname AS [Last Name], MAX(e.eventtime) as [Last Read] FROM individuals AS i LEFT JOIN cards AS c ON i.individ = c.indivndx AND i.tenantndx = c.tenantndx JOIN events AS e ON i.individ = e.indivndx AND i.tenantndx = e.tenantndx AND i.accessverndx = e.accessverndx JOIN eventtypes as et ON e.eventtypendx = et.eventtypeid WHERE e.eventtypendx IN (14,16) AND (e.floatvalue <> 1.0) GROUP BY i.individ, i.firstName, i.lastname ORDER BY i.individ, i.firstName, i.lastname, [Last Read] DESC";
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.