How to remove multiple data from a database
The database has a number of data, but always take out only one (younger brother first use PHP), the following is my database connection code
PHP Code
Public Function Querysql ($sql) { $data _array = Parse_ini_file ("Database.ini", true); $connect = @mysql_connect ($data _array["url"], $data _array["username"], $data _array["pass") or Die ("Unable to connect Database server! "); mysql_query ("Set Names"). $data _array["Incode"]. "'"; $query = Mysql_db_query ($data _array["basename"], $sql, $connect); $arrary; if (! $query) { echo "database connection error"; } else{ $arrary = mysql_fetch_array ($query); } $close = @mysql_close ($connect) or Die ("Unable to close database server connect!"); return $arrary; }
------Solution--------------------
PHP Code
...... } else{ while ($r = Mysql_fetch_array ($query)) $arrary [] = $r; } ....
------Solution--------------------
else{
while ($arrary = Mysql_fetch_array ($query, Mysql_assoc)) {
Var_dump ($arrary);
}
}
------Solution--------------------
PHP Code
else{ $arry = Array (); while ($arr = @mysql_fetch_array ($result, Mysql_assoc)) { Array_push ($arry, $arr); } return $arry;}