line missing

[Gurk]

hallow

why won't this code let me show the first line on my db

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]);
}

i have 3 lines in my db and it shows me 2
i hope someone can help me out.

thank jou verry much

[CJ Llewellyn]

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

hallow

why won't this code let me show the first line on my db

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]);
}

i have 3 lines in my db and it shows me 2
i hope someone can help me out.

$result = mysql_query("SELECT id , name FROM mytable");
if(! $result || mysql_error() || mysql_num_rows($result) < 1)
{
echo "Unable to fetch records!"
}
else
{
printf("%s rows found<br>\n" ,mysql_num_rows($result));
while($row = mysql_fetch_array($result , MYSQL_NUM))
{
printf("ID: %s Name: %s<br>\n", $row[0], $row[1]);
}
}

[Gurk]

indees it says howmuch lines there are, but it won't dis play the values of
the first line.
it begins displaying at the second line, but he knows there is a first

how commes?

"CJ Llewellyn" <in*****@example.con> wrote in message
news:ch**********@slavica.ukpost.com...

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

hallow

why won't this code let me show the first line on my db

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]);
}

i have 3 lines in my db and it shows me 2
i hope someone can help me out.

$result = mysql_query("SELECT id , name FROM mytable");
if(! $result || mysql_error() || mysql_num_rows($result) < 1)
{
echo "Unable to fetch records!"
}
else
{
printf("%s rows found<br>\n" ,mysql_num_rows($result));
while($row = mysql_fetch_array($result , MYSQL_NUM))
{
printf("ID: %s Name: %s<br>\n", $row[0], $row[1]);
}
}

[Tim Van Wassenhove]

In article <41**********************@news.skynet.be>, Gurk wrote:

indees it says howmuch lines there are, but it won't dis play the values of
the first line.
it begins displaying at the second line, but he knows there is a first

A database doesn't know about "lines".

My guess is that the first row, contains values that are NULL or ''
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>

[CJ Llewellyn]

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

indees it says howmuch lines there are, but it won't dis play the values of the first line.
it begins displaying at the second line, but he knows there is a first

how commes?

No idea, try

print_r($row) inside <pre> tags