PHP Mysql table fetch only gives first row

Question

$query = "SELECT * FROM pass";
$result = mysql_query($query,$conn);
echo mysql_num_rows($result);

while($row = mysql_fetch_array($result))
{
    $username = $row['user'];
    $password = $row['pass'];   
}

Num rows = 12 but while loops only the first one if I use in while $row = mysql_fetch_array(mysql_query("SELECT * FROM pass",$conn))

If i use the first code it gives error after the first row, Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in

WARNING: If you're just learning PHP, please, do not learn the obsolete mysql_query interface. It's awful and has been removed in PHP 7. A replacement like PDO is not hard to learn and a guide like PHP The Right Way helps explain best practices. Make sure your user parameters are properly escaped or you will end up with severe SQL injection bugs. — tadman
– tadman, Commented Apr 2, 2017 at 4:49

Gert · Accepted Answer · 2017-04-02 01:23:33Z

1

you define the variables wrong if you don't give it a number it will always only have 1 result and do some reading about newer ways to connect to mysql database

$i = 0;
while($row = mysql_fetch_assoc($result))
{
    $username[$i] = $row['user'];
    $password[$i] = $row['pass'];   
    $i++;
}

//you can test like this
$r = 0;
while($r < $i)
{
    echo $username[$r];
    echo $password[$r];
    $r++;
}

edited Apr 2, 2017 at 1:23

answered Apr 2, 2017 at 0:58

Gert

3703 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gert Over a year ago

@katates see my edit i missed something change fetch array to mysql_fetch_assoc

katates Over a year ago

Thats weird now it only gets the first char, edit: solved it!

Gert Over a year ago

might because your table name is the same as your column name also do you have mysql_select_db("your data base name") line after you connected to the data base but before the query? and this line i believe should be this $result = mysql_query($query);

Collectives™ on Stack Overflow

PHP Mysql table fetch only gives first row

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related