pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Papp Gyozo <pgerzson@freestart.hu>
To: angelo.rigo@globo.com
To: pgsql-php@postgresql.org
Subject: Re: Mailtos and links from a query result table!
Date: Thu, 9 May 2002 22:43:17 +0200
Message-ID: <E175ul4-0000Vt-00@pompom.freestart.hu> (raw)
In-Reply-To: <3CD2936400024AD8@nplex.globo.com>
References: <3CD2936400024AD8@nplex.globo.com>

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

-- 
Papp, Győző
- pgerzson@freestart.hu



view thread (4+ messages)  latest in thread

Message-ID: <E175ul4-0000Vt-00@pompom.freestart.hu>
Permalink:  ../E175ul4-0000Vt-00@pompom.freestart.hu/
Also on:    postgresql.org/message-id/E175ul4-0000Vt-00@pompom.freestart.hu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: pgerzson@freestart.hu, angelo.rigo@globo.com
  Subject: Re: Mailtos and links from a query result table!
  In-Reply-To: <E175ul4-0000Vt-00@pompom.freestart.hu>
  References: <3CD2936400024AD8@nplex.globo.com> <E175ul4-0000Vt-00@pompom.freestart.hu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox