PHP Problems Combining implode() with mysql_real_escape_string()

Question

How do I correctly write the code for a MySQL query that both implodes and mysql_real_escape_string?

This is the code that I have, but it's failing:

$sql = "INSERT INTO BEER_LOCATIONS 
        (LOCATION_NAME, LOCATION_STREET, LOCATION_CITY, LOCATION_STATE,
        LOCATION_ZIPCODE, LOCATION_PHONE, BEER_STYLE ) 
    VALUES 
        ('" . mysql_real_escape_string(implode("', '", $row)) . "')";

Thanks

Answer 1

implode("', '", array_map('mysql_real_escape_string', $row))

This applies mysql_real_escape_string to every element in $row and returns an array with the escaped values to implode.