note 14686 added to function.ifx-htmltbl-result.php
| From: | alvarope at hotmail dot com | Date: | Thu, 09 Aug 2001 10:50:22 +0000 |
| Subject: | note 14686 added to function.ifx-htmltbl-result.php | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-16505@lists.php.net to get a copy of this message | ||
This function is very useful even when you need to format the table (you can use style css) or you
want to add links in a field, you can do like this:
$conn = ifx_connect ("dbpath@server","user","pass")OR die ("Could
not Connect");
$query = "select fname as Name, '<a
href=phppage.php?var='||appno||'>'||sname||'</a>' as Surname from
tab02 where sname like '$form_var%'";
/* You can select the name of the column with the 'as' and add the link */
$res = ifx_query($query, $conn);
ifx_htmltbl_result ($res, "border=\"2\"");
ifx_free_result($resultado);
ifx_close($conexion);
http://www.php.net/manual/en/function.ifx-htmltbl-result.php