How to connect two tables on php file.

[mby247]

Pls I need help. I got two tables on a database but I dont know how to run them independently. Please find below our script. It is a shipping tracking website. All I want is each table to run independently once tracked.

<?php 
//Connect To Database
$hostname='localhost.com';
$username='forexample';
$password='xxxx';
$dbname='example';
$usertable='ECMY4572957';
 
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
 
//This array contains all correct tracking numbers
$track_number = $_POST['track_number'];
if(empty($track_number)){
    die('<b>Please go back & enter tracking number</b>');
}
else if(strlen($track_number) <= 0 || strlen($track_number) > 15){
    die('<b>Invalid tracking number, please go back</b>');
}
else{
$correct_tracking_numbers=array(ECMY4572957, BHSZ006933);
if(in_array($track_number,$correct_tracking_numbers)){
    $query = 'SELECT * FROM ' . $usertable;
    $result = mysql_query($query) or die(mysql_error());
echo "<table border='5'>
<tr>
<th>Date/Time</th>
<th>Event</th>
<th>Location</th>
<th>Details</th>
<th>Type of Move</th>
</tr>";
    while($row = mysql_fetch_array($result)){
echo "<tr>";
        echo "<td>" . $row['Date/Time'] .  "</td>";
echo "<td>" . $row['Event'] .  "</td>";
echo "<td>" . $row['Location'] .  "</td>";
echo "<td>" . $row['Details'] .  "</td>";
echo "<td>" . $row['Type of Move'] .  "</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
 
}else{
    echo '<b>The tracking number is invalid, Please go back & enter a Valid Tracking Number!</b>';
}
}
?>
</body>
</html>

How do I write or connect the second usertable to the php file as the first script which is working fine once tracked? The table name is "FTYX34555867". I don't know how to run or write multiple table on same database. All I need is, how to connect multiplt tables so each table can run different tracking number. Am stress as am not getting it well. Please help me.

[dlite922]

What does the second table contain? same thing as the first?

Do you need to check each tracking number against both tables?

It's not clear "what" you want to do with the second table. You can't "run" tables. tables is just a collection of data. so what is this data and what do you want to do with it?


Dan