Red Truck
Contact UsAbout UsOwner OperatorAgent InformationTSH-AVF
Tennesse Steel Haulers, Inc Logo
Available Freight Page
national flatbed carrier

Tennessee Steel Haulers, Inc
Available Loads

This site updates every 15 minutes, please check back for new loads.

Loads highlighted in blue are for Tennessee Steel Haulers drivers only.



='$date' order by fromstate,fromcity,dateneeded,tostate,tocity"; $entry = pg_exec($db,$sql); $rows = pg_NumRows($entry); if($rows>0) { //we have some entries, print them //print header echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //now print all the entries for($i=0;$i<$rows;$i++) { $r = pg_fetch_array($entry,$i); //clean data while (list($key, $value) = each ($r)) { $r[$key] = trim(stripslashes($value)); }//while() //format the date mm/dd/yyyy $pieces = explode("-",$r[dateneeded]); $date = $pieces[1] . "/" . $pieces[2] . "/" . $pieces[0]; //print data $style = ""; if($r[source]=='AGT') { //we're going to need to get some data //use the contact id as agent_id to get all the info on the agent $sql = "select * from agents where agent_id='$r[contact]'"; $e = pg_exec($db,$sql); if(pg_numRows($e)==1) { //we got the result $agent = pg_fetch_array($e,0); while(list($k,$v)=each($agent)) $agent[$k] = trim(stripslashes($v)); if($agent[agentcode]!="") $contact = $agent[agentcode]; else $contact = $agent[first_name] . " " . $agent[last_name]; $r[callbackphone] = $agent[phone]; }//end if() else $contact = $r[callbackphone] = ""; $style = "style=\"color: #ffffff; background-color: #0033cc;\""; }//end if(r[source]=AGT) else $contact = strtoupper($r[contact]); echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n\n"; }//end for(i) //close table echo "
Date NeededOriginDestinationEquip.LTLContactPhone
$date$r[fromcity], $r[fromstate]$r[tocity], $r[tostate]$r[req_equip] $r[spnotes] $contact $r[callbackphone]
"; }//end if(rows) else echo "Load listings are not available at this time. Please check back later."; pg_close($db); }//end if(db) else echo "Load listings are not available at this time. Please check back later."; ?>

Tennesse Steel Haulers Truck Logo
Copyright ©. All Rights Reserved