Pogledajte određenu poruku
Staro 02. 12. 2007.   #3
Dejan Topalovic
old school
Professional
 
Datum učlanjenja: 15.02.2006
Lokacija: Wien, Austria
Poruke: 304
Hvala: 121
47 "Hvala" u 26 poruka
Dejan Topalovic će postati "faca" uskoro
Pošaljite poruku preko MSN za Dejan Topalovic
Default

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
Dejan Topalovic je offline   Odgovorite uz citat