multiple lin

[Gurk]

hallow

how can i add lines into my page

for example
i have this line

..download january

but in my database are more downloads called january.
i have the function to fugure out how much lines there are in my db,
but how can i echo them as much there are lines in my db

thanks

maarten

[Daniel Tryba]

Gurk <gu******@hotmail.com> wrote:

how can i add lines into my page

for example
i have this line

.download january

but in my database are more downloads called january.
i have the function to fugure out how much lines there are in my db,
but how can i echo them as much there are lines in my db

Huh? Is your question how to read all rows from a database query?

http://www.php.net/manual/en/functio...etch-array.php

Example 2. mysql_fetch_array() with MYSQL_NUM
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}

mysql_free_result($result);
?>

Much depends on the actual database used.

--

Daniel Tryba

[Gurk]

tkank jou verry much

kind regards Maarten
"Daniel Tryba" <ne****************@canopus.nl> wrote in message
news:ch**********@news.tue.nl...

Gurk <gu******@hotmail.com> wrote:

how can i add lines into my page

for example
i have this line

.download january

but in my database are more downloads called january.
i have the function to fugure out how much lines there are in my db,
but how can i echo them as much there are lines in my db

Huh? Is your question how to read all rows from a database query?

http://www.php.net/manual/en/functio...etch-array.php

Example 2. mysql_fetch_array() with MYSQL_NUM
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}

mysql_free_result($result);
?>

Much depends on the actual database used.

--

Daniel Tryba

[Gurk]

thanks for the code, it works but it wont display the first value of the db.

can someone give me an explenation of this code, so i can figure out what's
wrong.

thanks Maarten

"Gurk" <gu******@hotmail.com> wrote in message
news:41**********************@news.skynet.be...

tkank jou verry much

kind regards Maarten
"Daniel Tryba" <ne****************@canopus.nl> wrote in message
news:ch**********@news.tue.nl...

Gurk <gu******@hotmail.com> wrote:

how can i add lines into my page

for example
i have this line

.download january

but in my database are more downloads called january.
i have the function to fugure out how much lines there are in my db,
but how can i echo them as much there are lines in my db

Huh? Is your question how to read all rows from a database query?

http://www.php.net/manual/en/functio...etch-array.php

Example 2. mysql_fetch_array() with MYSQL_NUM
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}

mysql_free_result($result);
?>

Much depends on the actual database used.

--

Daniel Tryba