Need sql help

trying to run 2 queries at once

[Chaswald]

I have two sql queries they both work fine alone but i need to run them together. Please help.

$stoname=mysql_real_escape_string($_POST['stoname']);
$loco=mysql_real_escape_string($_POST['loco']);
$keywords=mysql_real_escape_string($_POST['keywords']);
$sum=mysql_real_escape_string($_POST['sum']);
$zip=mysql_real_escape_string($_POST['zip']);
$phone=mysql_real_escape_string($_POST['phone']);

$sql= "INSERT INTO search_display (title,location,keywords,sum,zip,phone) VALUES ('$stoname','$loco','$keywords','$sum','$zip','$phone)";

$sql= "INSERT INTO search_display (lon,lat)
SELECT lon,lat
FROM zip_code
WHERE zips = '$zip'";

[cameraman]

Welcome to Webmaster World, Chaswald.

Do this first:
select lon,lat from zip_code where zips='$zip'

then insert the retrieved values when you do the first insert in your post:
$sql= "INSERT INTO search_display (title, location, keywords, sum, zip, phone, lon, lat) VALUES ('$stoname', '$loco', '$keywords', '$sum', '$zip', '$phone', '$lon','$lat')";