note 95049 deleted from function.explode by danbrown
| From: | danbrown@php.net | Date: | Thu, 10 Dec 2009 19:12:23 +0000 |
| Subject: | note 95049 deleted from function.explode by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163826@lists.php.net to get a copy of this message | ||
Note Submitter: castagnariccardo at libero dot it
----
/*
Convert mysql_fetch_array in an php array
*/
$sql = "CREATE TABLE IF NOT EXISTS country (
iso varchar(2) collate latin1_general_ci NOT NULL,
country varchar(80) collate latin1_general_ci NOT NULL,
PRIMARY KEY (iso))
ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;";
$exesql = mysql_query($sql);
$country = "INSERT INTO country (iso, country) VALUES ('AD', 'Andorra'),
('AF', 'Afghanistan'),('AI', 'Anguilla'),('AL',
'Albania'),('AM', 'Armenia'),('AO',
'Angola');";
$insert = mysql_query($country);
$view = "SELECT * FROM country;";
$result = mysql_query($view);
$p = "";
while ($theco = mysql_fetch_array($result))
{
$p .= "".$theco['country']."-";
}
$myarray = explode("-", $p);
echo "".$myarray[0]."<br />";
echo "".$myarray[1]."<br />";
echo "".$myarray[2]."<br />";