RE: Question: Putting separate form elements into an array

[Stuart Felenstein <stuart4m@xxxxxxxxx>]

Changed my direction somewhat but keep getting a parse
error and although I know where it is , I can't seem
to figure out what I need to do to make it syntax
correct:

This is how I am passing the arrays:

if ( empty( $_SESSION['l_skill'] ) ) {
$_SESSION['l_skill']=array();
}

if ( is_array( $_REQUEST['skill'] ) ) {
$_SESSION['l_skill'] = array_unique(
array_merge( $_SESSION['l_skill'],
 $_REQUEST['skill'] )
);
}

if ( empty( $_SESSION['l_sky'] ) ) {
$_SESSION['l_sky']=array();
}

if ( is_array( $_REQUEST['sky'] ) ) {
$_SESSION['l_sky'] = array_unique(
array_merge( $_SESSION['l_sky'],
 $_REQUEST['sky'] )
);
}

if ( empty( $_SESSION['l_slu'] ) ) {
$_SESSION['l_slu']=array();
}

if ( is_array( $_REQUEST['slu'] ) ) {
$_SESSION['l_slu'] = array_unique(
array_merge( $_SESSION['l_slu'],
 $_REQUEST['slu'] )
);
}

This is how I am trying to get them into the database:

$queries = array();
for($i=0; $i<count($l_skill); $i++)
{
    $queries[] = "('" . $l_skill[$i] . "', " .
$l_sky[$i] . ", " . $l_slu[$i] . ")";
}

if(count($queries) == 0)
{
    # Nothing passed
    # exit
}

$query = "INSERT INTO LurkProfiles_Skicerts
(ProfileID, SkilCerts, NumYear, Lused)
VALUES ($LUID ". implode(", ", $queries); 
  
//Above line is where I am having the problem.  There
is something between LUID and the implode statement. 
LUID is not passing into the insert generating a sql
error.


$result = mysql_query($query);
echo $query;







--- Stuart Felenstein <stuart4m@xxxxxxxxx> wrote:

>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php