Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E3B544759C3 for ; Thu, 9 May 2002 18:31:42 -0400 (EDT) Received: from noon.pghoster.com (unknown [64.246.32.44]) by postgresql.org (Postfix) with ESMTP id 892DB475B6E for ; Thu, 9 May 2002 18:31:41 -0400 (EDT) Received: from bungeecode.com (cs666899-134.austin.rr.com [66.68.99.134]) (authenticated (0 bits)) by noon.pghoster.com (8.11.6/8.11.6) with ESMTP id g49MUA916688; Thu, 9 May 2002 17:30:10 -0500 Message-ID: <3CDAEAC6.50205@bungeecode.com> Date: Thu, 09 May 2002 16:31:50 -0500 From: Surojit Niyogi User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.0+) Gecko/20020508 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgerzson@freestart.hu Cc: angelo.rigo@globo.com, pgsql-php@postgresql.org Subject: Re: Mailtos and links from a query result table! References: <3CD2936400024AD8@nplex.globo.com> Content-Type: text/html; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-Archive-Number: 200205/48 X-Sequence-Number: 1180 Doing this would be good also if you expect to alter your table in the future.  

-Surojit

Papp Gyozo wrote:
2002. május 9. 22:32 dátummal angelo.rigo@globo.com ezt írta:
  
Hi!
I need to make mailtos and hiperlinks in a query result table
i dont know wich variable to pass to the <a href =""> to make this
happen
    

I suggest to you using named fields.You can achieve this by calling
pg_fetch_array with PGSQL_ASSOC parameter (or pg_fetch_object())

	$myrow = pg_fetch_array($result, $row, PGSQL_ASSOC);

Then you can use $myrow['email'], etc, whatever you named those columns 
in postgres.

  
my code below is not working! any idea?

printf ("<tr bgcolor='$bgcolor'><td>%s</td><td>%s</td><td><a
href='mailto:$myrow[19]'>%s</a></td><td><a
href="$myrow[9]">%s</a></td><td>%s</td><td>%s</td></tr>
",$myrow[1], $myrow[2], $myrow[3], $myrow[19], $myrow[9], $myrow[10]);
$row++;
}
while ($row < $numrows);
printf ("</table>
");
pg_close($db);
?>



________________________________________
A busca mais veloz e precisa da internet. Acesse agora:
http://www.zoom.com.br.


---------------------------(end of
broadcast)--------------------------- TIP 4: Don't 'kill -9' the
postmaster