
Untitled
By: a guest on
Jun 30th, 2012 | syntax:
None | size: 0.83 KB | hits: 13 | expires: Never
jQuery Selects Plugin, pull variables from database
$counties = array();
$counties['1']['BARN'] = 'Barnstable';
$counties['1']['PLYM'] = 'Plymouth';
$counties['2']['CHIT'] = 'Chittenden';
$counties['3']['ANDE'] = 'Anderson';
$counties = array();
$sql = "SELECT
id,
naam,
klant_id
FROM contactpersoon
ORDER BY klant_id ASC ";
if(!$res = mysql_query($sql,$con))
{
trigger_error(mysql_error().'<br />In query: '.$sql);
}
else
{
while ($row = mysql_fetch_array($res))
{
$counties[$row['klant_id'][$row['id'] = htmlentities($row['naam']);
}
}
$counties[$row['klant_id'][$row['id'] = htmlentities($row['naam']);
$counties [$row['klant_id']] [$row['id']] = htmlentities($row['naam']);
$a = $row['klant_id'];
$b = $row['id'];
$counties[a][b]= htmlentities($row['naam']);