hi,
could someone please show me how to parse the value of the field 'Standard_Letter_Id' in a URL parameter in the following script. The HREF is at the botom of the table.
cheers
<?php
// create short variable names
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm= trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'You have not entered search details. Please go back and try again.';
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
@ $db = mysql_pconnect('localhost', 'root', 'xxxx');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('vb4u_bdb');
$query = "select * from standardletter where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$Recordset1 =
$num_results = mysql_num_rows($result);
echo '<p>Number Of Standard Letters found: '.$num_results.'</p>';
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo '<TABLE ROWS=8 COLUMNS=2 BORDER=1>';
echo '<TR>';
echo '<TD BGCOLOR=#b2b2b2>';
echo ($i+1).' Standard Letter Id:';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Standard_Letter_Id']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Standard Letter Name: ';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Standard_Letter_Name']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Standard Letter Text: ';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Standard_Letter_Text']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Reviewed By Joe: ';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Reviewed_By_Joe']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Reviewed By Clint: ';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Reviiewed_By_Clint']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Finalised: ';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Finalised']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Standard Letter Editable Text: ';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo stripslashes($row['Standard_Letter_Editable_Text']);
echo '</TD></TR><TR><TD BGCOLOR=#b2b2b2>';
echo 'Delete?';
echo '</TD><TD BGCOLOR=#FFFFFF>';
echo '<a href=" ">Delete</a>';
echo '</TD></TR></TABLE><BR><BR>';
}
echo '</TABLE>'
?>
