Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[crack]

salut!
cum pun intr-un vector inregistrarile dintr-o coloana ?
de ex sa pun tot ce e in data intr-un vector :

+----+-------------+---------+
| id | data | valoare |
+----+-------------+---------+
| 1 | 2005-01-31 | 17.365 |
| 2 | 2005-01-31 | 14.567 |
| 3 | 2005-01-31 | 45.687 |
| 4 | 2005-01-30 | 21.654 |
| 5 | 2005-01-22 | 21.564 |
| 6 | 2005-01-12 | 54.231 |
| 7 | 2004-06-21 | 32.544 |
| 8 | 2003-05-16 | 57.665 |
| 9 | 1999-12-25 | 56.231 |
| 10| 2003-10-18 | 44.444 |
+----+------------+---------+

[aurelian]

Din memorie, o metoda nerecomandata:
an style="color: #000000"><?php $query = "SELECT * FROM _TABEL_"; $rs = mysql_query($query); $i=0 $result = array(); while($row=mysql_fetch_array($rs)){     $result[$i]=$row['data'];     $i++; } print_r($result); 
sau:
an style="color: #000000"><?php <?php $mysqli = new mysqli("localhost", DB_USER,DB_PASS, DATABASE); /* check connection */ if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit(); } $query = "SELECT * FROM _TABELUL_MEU_"; if ($result = $mysqli->query($query)) {     printf("Select returned %d rows.\n", $result->num_rows);     $rz = array();     $i = 0;     while($row = $result->fetch_array(MYSQLI_ASSOC)){         $rz[$i]=$row['data'];         $i++;     }    /* free result set */    $result->close(); } print_r($rz); 
Recomandat:
http://pear.php.net/manual/en/package.database.db.db-common.getall.php
sau si mai bine:
http://pear.php.net/manual/en/package.database.db.db-common.getcol.php

[crack]

a mers cu prima metoda, aia "nerecomandata"
poti sa-mi spui de ce ai catalogato asa ?

[aurelian]

Prea multe _obiecte_ pe capul meu in ultima vreme :)

Eu asa as face:
http://pear.php.net/manual/en/package.database.db.db-common.getcol.php

[crack]

interesant... merci pt link

[PHPRomania Bot]