Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Arno Welzel <usenet@arnowelzel.de>
Newsgroups: comp.lang.php
Subject: Re: How to retreive data from row and show it as link in a page
Date: Sat, 2 Jan 2016 14:49:08 +0100
Lines: 27
Message-ID: <5687D554.6050409@arnowelzel.de>
References: <43088977-4e12-4d58-a977-aa114e491069@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Trace: individual.net fhrjItjLD/PvPtEdjrwjAAe/pmGaeCqAE/pXS7rQaj7jYrchTr
Cancel-Lock: sha1:Dz+iOo51EljW4lU3jzjYXw5ZIhM=
In-Reply-To: <43088977-4e12-4d58-a977-aa114e491069@googlegroups.com>
Xref: csiph.com comp.lang.php:16058

androidmaroso@gmail.com schrieb am 2016-01-02 um 12:18:

[Getting the last record of a table in MySQL]

> I've done this but without results :
> 
> $link=Connection();
> $ultimoip=mysql_query("SELECT * FROM `iptable` ORDER BY `id` DESC limit 1",$link);
> 
> if($ultimoip!==FALSE){
> 		     while($row = mysql_fetch_array($ultimoip)) {
> 	printf($row["ip"]);
> 	echo '<a href="' . $row["ip"] . '">IP Attuale</a>';
> 					}
>         mysql_free_result($ultimoip);
> 
> can anyone help me please?

Any error messages? Any server side logs? What does Connection() do and
where is that function - in an included script?


-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de
http://fahrradzukunft.de