|
SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
02. 12. 2007. | #3 |
old school
Professional
|
Jesi probao ovako:
Kôd:
update post_details AS pd, (SELECT AVG(rank) AS rting, COUNT(*) AS nm_votes FROM votes WHERE post_id = $post_id_var_u_phpu) AS v SET rating = v.rting, num_votes = v.nm_votes WHERE pd.post_id = $post_id_var_u_phpu;
__________________
Blog: Baze podataka ------------------------ Oracle OCP DBA Oracle OCE SQL Expert Oracle OCP Developer Certified MySQL DBA |
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
cross-domain komunikacije pomocu iframe-a | ivanhoe | (X)HTML, JavaScript, DHTML, XML, CSS | 3 | 27. 05. 2009. 18:14 |
ranges pomocu regexpa | ivanhoe | Regular expression i htaccess | 1 | 12. 11. 2007. 09:31 |
mysql update problem | vendi | SQL baze podataka - Sponzor: Baze-Podataka.net | 3 | 27. 06. 2007. 23:32 |
Citanje binarnih fajlova pomocu PHP? | krcko | PHP | 4 | 19. 07. 2006. 01:33 |
prenosenje pomocu get metode | oliver78 | PHP | 16 | 30. 11. 2005. 20:09 |