06. oktober 2001 - 15:45Der er
5 kommentarer og 1 løsning
Mysql query
Jeg vil gerne have kogt disse queries sammen til én: SELECT count(sitedomain) hits_in WHERE sitedomain=\'$blabla\' SELECT count(sitedomain) hits_out WHERE sitedomain=\'$blabla\' SELECT count(sitedomain) clicks WHERE sitedomain=\'$blabla\'
Der skal stå: SELECT count(sitedomain) FROM hits_in WHERE sitedomain=\'$blabla\' SELECT count(sitedomain) FROM hits_out WHERE sitedomain=\'$blabla\' SELECT count(sitedomain) FROM clicks WHERE sitedomain=\'$blabla\'
SELECT hitsin, hitsout, clickno FROM (SELECT count(sitedomain) as hitsin FROM hits_in WHERE sitedomain=\'$blabla\'), (SELECT count(sitedomain) as hitsout FROM hits_out WHERE sitedomain=\'$blabla\'), (SELECT count(sitedomain) as clickno FROM clicks WHERE sitedomain=\'$blabla\')
Den sputter det her ud: You have an error in your SQL syntax near \'SELECT count(sitedomain) as hitsin FROM hits_in WHERE sitedomain=\'test.dk\' at line 2
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.