Posted by Johny Begood on 04/05/07 08:40

Hi All,

I am trying to get a script to query a an odbc table and return with a list
of records, each record's ID will be a hyperlink which when clicked on will
use that ID as criteria for the next script. I can do it with a single
record and a form field but this is not really what I need, can someone be
so kind as to give me some guidance the script I want to use is as follows:

I having trouble with this bit '<a
href="testcallscript.php?$TableField=[$Criteria];">'

<?php
// other code here....
$query = odbc_exec($odbc, "SELECT * FROM DataBaseTable") or die
(odbc_errormsg());
while($row = odbc_fetch_array($query))
{
echo ''.$row['DataField1'].'<br />';
echo ''.$row['DataField2'].'';
$Criteria = $row['DataField3'];
echo '<a
href="testcallscript.php?$TableField=[$Criteria];">'.$Criteria.'</a> - ';
echo ''.$row['ShrtDate'].' - ';
echo ''.$row['RTime'].' - ';
echo ''.$row['Age'].'<br />';
}
?>

Again, I'm a newbie, can't you tell, so don't laugh too loud, remember you
were newbie once!!:-)

Kind regards

Mark

• Next in forum: Re: Newbie needs help ......creating a hyperlink with criteria
• Prev in forum: Re: What is the learning curve for PHP?
• Thread view: Newbie needs help ......creating a hyperlink with criteria

[Reply to this message]