How do I select from multiple mySQL tables and output to PHP?

[system]

I am creating a tracking site which will output Tracking Information stored in a Mysql database when i tracking number is entered as input. below is my insert script. I need a help to output where TrackNo=$TrackNo:

if (isset($_POST[‘Shipper’]) &&
isset($_POST[‘ShipDate’]) &&
isset($_POST[‘Receiver’]) &&
isset($_POST[‘ShipLocation’]) &&
isset($_POST[‘DeliveryStatus’]) &&
isset($_POST[‘DeliveryDate’]) &&
isset($_POST[‘TrackNo’]))
{
$Shipper = get_post(‘Shipper’);
$ShipDate = get_post(‘ShipDate’);
$Receiver = get_post(‘Receiver’);
$ShipLocation = get_post(‘ShipLocation’);
$DeliveryStatus = get_post(‘DeliveryStatus’);
$DeliveryDate = get_post(‘DeliveryDate’);
$TrackNo = get_post(‘TrackNo’);
$query = “INSERT INTO track (Shipper, ShipDate, Receiver, ShipLocation, DeliveryStatus, DeliveryDate, TrackNo) VALUES (’$Shipper’, ‘$ShipDate’, ‘$Receiver’, ‘$ShipLocation’, ‘$DeliveryStatus’, ‘$DeliveryDate’, ‘$TrackNo’)”;
if (!mysql_query($query, $db_server))
echo “INSERT failed: $query
” .
mysql_error() . “

”;
}
echo <<<_END

Shipper   Send Date   Receiver  Ship Location 

<pre>

Delivery Status   Expected Delivery Date   Tracking Number 

[wilson382]

replace the whole if statement with:

[php]
if (isset($_POST[‘Shipper’]) &&
isset($_POST[‘ShipDate’]) &&
isset($_POST[‘Receiver’]) &&
isset($_POST[‘ShipLocation’]) &&
isset($_POST[‘DeliveryStatus’]) &&
isset($_POST[‘DeliveryDate’]) &&
isset($_POST[‘TrackNo’]))
{
$Shipper = $_POST(‘Shipper’);
$ShipDate = $_POST(‘ShipDate’);
$Receiver = $_POST(‘Receiver’);
$ShipLocation = $_POST(‘ShipLocation’);
$DeliveryStatus = $_POST(‘DeliveryStatus’);
$DeliveryDate = $_POST(‘DeliveryDate’);
$TrackNo = $_POST(‘TrackNo’);
$query = “INSERT INTO track (Shipper, ShipDate, Receiver, ShipLocation, DeliveryStatus, DeliveryDate, TrackNo) VALUES
(’$Shipper’, ‘$ShipDate’, ‘$Receiver’, ‘$ShipLocation’, ‘$DeliveryStatus’, ‘$DeliveryDate’, ‘$TrackNo’)”;

	if (!mysql_query($query, $db_server))
            echo "INSERT failed: $query<br />" .
            mysql_error() . "<br /><br />";

}
[/php]

and to answer your question, the below with get everything that matches your TrackNo

"SELECT * FROM `track` WHERE `TrackNo` = '$TrackNo'"