[SOLVED] getting results from mysql

[vampke]

Hi peoples,

 

I 'm writing a script where i want to get all the numbers out of a database and put them in an html

this is the database table:

unid  id  un1  un2  un3  un4  un5  un6  un7

1 1 2 3 8 19 48 52 63

2 1 2 3 8 20 21 43 58

3 2 1 7 11 23 26 33 44

4 2 3 12 17 42 49 71 96

5 3 21 28 38 39 47 54 59

6 3 1 4 9 19 35 42 95

 

my php code:

 

$msg ="";
$get_numbers = mysql_query("SELECT * FROM numbers");

while($row = mysql_fetch_row($get_numbers))
{
    $userid  = $row[0];
    $id      = $row[1];
    $number1 = $row[2];
    $number2 = $row[3];
    $number3 = $row[4];
    $number4 = $row[5];
    $number5 = $row[6];
    $number6 = $row[7];
    $number7 = $row[8];

    $msg .= "$number1, $number2, $number3, $number4, $number5, $number6, $number7 \n";

}

 

This returns 189 lines of results.

Here are the first few:

 

2, 3, 8, 19, 48, 52, 63

userID: 1

2, 3, 8, 19, 48, 52, 63

2, 3, 8, 20, 21, 43, 58

userID: 2

2, 3, 8, 19, 48, 52, 63

userID: 1

2, 3, 8, 19, 48, 52, 63

2, 3, 8, 20, 21, 43, 58

1, 7, 11, 23, 26, 33, 44

 

etc...

 

Can someone explain to me what i'm so obviously doing wrong?

I only want to return the 6 rows in the mysql table

 

[Ken2k7]

Use mysql_fetch_array()

[vampke]

Use mysql_fetch_array()

 

same result

[adam291086]

feth_array should work. Post your code

[Ken2k7]

<?php
$msg ="";
$get_numbers = mysql_query("SELECT * FROM numbers") or die(mysql_error());

while($row = mysql_fetch_array($get_numbers))
{
    $userid  = $row[0];
    $id      = $row[1];
    $number1 = $row[2];
    $number2 = $row[3];
    $number3 = $row[4];
    $number4 = $row[5];
    $number5 = $row[6];
    $number6 = $row[7];
    $number7 = $row[8];

    $msg .= "$number1, $number2, $number3, $number4, $number5, $number6, $number7 \n";

}?>

[revraz]

Where is your echo statement.

 

Why does $msg .= ?

[adam291086]

beaten to it

[vampke]

Thanks ken2k7, that worked, I'm not sure what is different then in my code though...

weird....

 

the $msg is returned in the html code, I thought it was clear so i did not mention it

[revraz]

Ah I see, you're loading up the variable first then displaying it.

 

I usually echo it on each loop iteration.

[Ken2k7]

mysql_fetch_row() fetches one row of data while mysql_fetch_array() can fetch more than 1.

[trq]

mysql_fetch_row() fetches one row of data while mysql_fetch_array() can fetch more than 1.

 

Since when? mysql_fetch_array fetches one row each time it is called then moves the internal pointer forward.

[Ken2k7]

mysql_fetch_row() fetches one row of data while mysql_fetch_array() can fetch more than 1.

 

Since when? mysql_fetch_array fetches one row each time it is called then moves the internal pointer forward.

Oh okay. Thanks. Why do people say 'internal pointer'? ???

[revraz]

That's how it keeps track of where it's at or else it won't know what the next row is.