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
