parsing an array

[DougieC]

hello,
I am getting a string array from a bunch of textfields with the $_Post
function. what i want to do is put that into a sql query, but if they dont fill out all the text fields there is blank values.
for example
('duncan','victoria','vancouver','sooke','naniamo','ladysmith','','','','','','','','','','','','','','','','','','','','','','','','','','','')

Im new to php so i'm not usre how to do it but is there a way to go through the array so I only have the cities and not the blank fields?

Thanks

[kevinsequeira]

post your existing code

reg
kevin

[erikwebb]

while ($current = each($_POST["city"])) {
    if ($current["value"])
        $sql .= $current["value"];
}

[tekky]

I did this before but it was kinda ucky....

was somethinglike this...

while ($current = each($_POST["city"])) { 
    if ($current["value"])
    {
        $columns .= "'" .$current['key']. "'"; //or whatever u use for the column name
        $values .= "'" .$current["value"]. "'"; //this is used for the values list
     } 
}
$sql = "INSERT INTO $table $columns VALUEs ($values)";

infact this is cleaner than how I did it... and should work just as well 🙂

[DougieC]

Thanks for the help guys I got it working😃