[php] Drei Arten, Daten aus einer Datenbank zu holen

[andreas kempf]

On Thu, 2 Aug 2001 12:48:31 +0200, Martin Paff
<martin.paff_(at)_netzeitung.de> wrote:

>include("test_db.inc");
>
>$sql =3D "SELECT datum, wert FROM nz_stats=20
>			WHERE datum >=3D '2001-07-01'=20
>			AND datum <=3D '2001-07-31'
>			AND rubrik =3D 'sum'
>			";

So gehts auch:
$sql =3D "SELECT datum, wert FROM nz_stats=20
         WHERE datum BETWEEN '2001-07-01' AND '2001-07-31'
           AND rubrik =3D 'sum'

>// Variante A
[...]
>	while ($zeile =3D mysql_fetch_array($result))
>	{
>		$datum =3D $zeile["datum"];
>		$wert =3D $zeile["wert"];
>		echo "<BR>$datum: $wert";

Und auch so geht es:
echo "<br>$zeile[datum]: $zeile[wert]";

ciao, andreas
--=20
[amalesh]      |  backend - development  |  PHP ASP SQL
andreas kempf  |  http://www.amalesh.de  |  online-shops
barnerstr. 14  |  tel: 040 - 39834682    |  eventsysteme
22765 hamburg  |  info_(at)_amalesh.de        |  communities