Re: Mailtos and links from a query result table!
От | Surojit Niyogi |
---|---|
Тема | Re: Mailtos and links from a query result table! |
Дата | |
Msg-id | 3CDAEAC6.50205@bungeecode.com обсуждение исходный текст |
Ответ на | Mailtos and links from a query result table! (angelo.rigo@globo.com) |
Список | pgsql-php |
Doing this would be good also if you expect to alter your table in the future. <br /><br /> -Surojit<br /><br /> Papp Gyozowrote:<br /><blockquote cite="midE175ul4-0000Vt-00@pompom.freestart.hu" type="cite"><pre wrap="">2002. május 9. 22:32dátummal <a class="moz-txt-link-abbreviated" href="mailto:angelo.rigo@globo.com">angelo.rigo@globo.com</a> ezt írta:</pre><blockquote type="cite"><pre wrap="">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 </pre></blockquote><pre wrap=""> 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. </pre><blockquote type="cite"><pre wrap="">my code below is not working! any idea? printf ("<tr bgcolor='$bgcolor'><td>%s</td><td>%s</td><td><a href='<a class="moz-txt-link-freetext" href="mailto:$myrow[19">mailto:$myrow[19</a>]'>%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: <a class="moz-txt-link-freetext" href="http://www.zoom.com.br">http://www.zoom.com.br</a>. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster </pre></blockquote><pre wrap=""> </pre></blockquote><br />
В списке pgsql-php по дате отправления: