I need help pls

[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.

[SharkBait]

Linking to tables within the same database usually is done with fields that are similar.

 

Table1 has a field called id

Table2 has a field called table1_id

 

Then you would link id from the first table to the value of the table1_id field. Make sense? The two tables need a relationship to be able to relate them.