You are not logged in.

  • Login

PHP/SQL Array aus SQL abfrage

der_robert

Trainee

  • "der_robert" started this thread

Posts: 13

  • Send private message

1

Saturday, March 19th 2011, 1:25am

PHP/SQL Array aus SQL abfrage

Hallo Leute,

ich wollte mal fragen wie ich aus einer SQL abfrage die so aussieht:

PL/SQL Code

 
1

SELECT `USER`, SUM(`points`) AS points, COUNT(`USER`) AS citys FROM `citys` GROUP BY `USER` ORDER BY `points` DESC, `USER`


ein Array erstelle/baue das dann so aussieht:

HTML Code

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

Array ( 
    [0] => Array 
        ( 
            [user] => User1
            [points] => 100 
            [city] => Stadt1 
        )
 
    [1] => Array
        (
            [user] => User2
            [points] => 200 
            [city] => Stadt2
        )
 
    [2] => Array
        (
            [user] => User3
            [points] => 300 
            [city] => Stadt3
        )
# usw....
)


Vielen Dank schonmal dür Hilfe/Tipps/Anregungen.

Szabo

Professional

Posts: 248

  • Send private message

2

Saturday, March 19th 2011, 1:41am

PHP Quellcode

 
1
2
3
4
5

$result = mysql_query("SELECT ...");
$data = array();
while($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}

der_robert

Trainee

  • "der_robert" started this thread

Posts: 13

  • Send private message

3

Saturday, March 19th 2011, 2:23am

Vielen Dank !!!!!

Similar threads

Tagging

Social bookmarks