Hi,
You could use something like
#start
do
{
echo tr;
$fields=odbc_num_fields($data2);
for($i=3 ; $i=$fields ; $i++)
echo td nowrap;
if (odbc_result($data2,$i) = 'SOX')
echo a href='sox_page_url'.odbc_result($data2,$i)./a;
else
echo odbc_result($data2,$i);
echo /td/tr\n;
} while(odbc_fetch_row($data2));
echo /table;
#end
The idea is to output one thing when the result matches your criteria and
another when it doesn't.
Hope this helps
Dobromir Velev
-Original Message-
From: John A DAVIS [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, July 17, 2001 2:39 AM
Subject: [PHP-DB] Need syntax for conditional in recordset loop
How would I code IF .odbc_result($data2,$i) = 'SOX' THEN make it a link?
By link I mean that I want the word SOX highlited in blue and underlined
and referencing a webpage that explains SOX verbosefully. Don't know PHP IF
THEN syntax too well.
/* fill table with data */
do
{
echo tr;
$fields=odbc_num_fields($data2);
for($i=3 ; $i=$fields ; $i++)
echo td nowrap.odbc_result($data2,$i)./td;
echo /tr\n;
} while(odbc_fetch_row($data2));
echo /table;
John A. Davis
Information Systems Specialist
OHD DWP
State of Oregon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
