What are you trying to link to? Most likely you need to pass a few variables in the URL
This should give you an idea: echo "<TD><A HREF="whateverpage.php?var1=$var1&record=$column_value">$column_value</A><TD>"; olinux --- "Franden, Craig" <[EMAIL PROTECTED]> wrote: > Hi, > > I am using a small php script to return records from > an oracle8.1.6 > database. I would like to have one of the columns > contents display the data > as a hyperlink and I am not quite sure how to do it. > Here is the code that > returns the data (which is correct). The table > formatting is the issue. All > help is greatly appreciated. > > --cbf > > / create connection > if ($connection = > OCIPLogon("chowder","head","help")) > { > //echo "$connection > ".OCIServerVersion($connection)."<BR>\n"; > } > else > { > echo "Couldn't connect to Oracle.<BR>\n"; > Exit(); > } > // create SQL statement > $sql = "select > case_id, > case_desc, > evnt_code||' - '||evnt_desc, > sched_date||' - '||start_time > > // parse SQL statement > $sql_statement = OCIParse($connection,$sql) > or die("Couldn't parse statement."); > > // execute SQL query > OCIExecute($sql_statement) > or die("Couldn't execute statement."); > echo OCIError()."<BR>"; > // get number of columns for use later > > // start results formatting > $row1 = "#EEEEF8"; > $row2 = "#ffffff"; > $rowcolor = $row1; > > echo "<TABLE BORDER=0>"; > echo "<TR> > <TH>Case Number</TH> > <TH>Case Description</TH> > <TH>Event Code & Description</TH> > <TH>Scheduled Date & Time</TH> > </TR> > "; > > // format results by row > while (OCIFetch($sql_statement)) { > echo "<TR BGCOLOR='$rowcolor'>"; > $num_columns = OCINumCols($sql_statement); > for ($i = 1; $i <= $num_columns; $i++) { > $column_name = OCIColumnName($sql_statement,$i); > $column_value = OCIResult($sql_statement,$i); > echo "<TD>$column_value</TD>"; > } > echo "</TR>"; > if ($rowcolor == $row1) $rowcolor = $row2; > elseif ($rowcolor == $row2) $rowcolor = $row1; > } > echo OCIRowcount($sql_statement) . " records > returned"; > echo "</TABLE>"; > > // free resources and close connection > OCIFreeStatement($sql_statement); > OCILogoff($connection); > > ?></p> > > > Thanks. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php