Create("triumphstag_db"); $sql1 = new MySQL_class; $sql1->Create("triumphstag_db"); echo("
Db connect OK.
"); //********************List the individual entry by id ********************************** $sql->Query("SELECT * from stagdataaltparts where id ='$id'"); $sql->Fetch($i); $id = $sql->data[0]; $indexid= $sql->data[1]; $altdesc= $sql->data[2]; $altpartno= $sql->data[3]; $alttext= $sql->data[4]; $alturl= $sql->data[5]; $name = $sql->data[6]; $email= $sql->data[7]; $datestamp= $sql->data[8]; $date1 = (date ("d F Y h:iA",$datestamp)); if ("http://" == $alturl OR "" == $alturl) { $url = ""; } Else { $url = "Click Here For Supporting URL "; } // old query I could not figure out !!! *** $refno = $sql1->QueryItem("select refno from stagdatapartsindex where partnumber='$partnumber'"); next one WORKS!! $refno = $sql1->QueryItem("select id from stagdataaltparts where altpartno='$altpartno'"); echo("
"); //echo(""); echo(""); echo (""); echo (""); echo(""); //echo(""); Echo (""); echo("
Alternative for Part Number : $partnumber ($desc) on Diagram $refno

Entered in Database on : $date1 By : $name

Alternative part number

$altpartno

Description :

$altdesc

Additional notes for this alternative

 $alttext

$url

Added By : $name on $date1
$url
Please quote :TriumphStag.net Ref=($partnumber / $id): If you have any queries regarding this entry
"); echo (""); ?>