PHP echo problem, only one row :(

[amycoll]

This is an script which recieves a news from database (MySQL).

There are 4 news in database, but echo prints only one of them. (first).

		  
	  mysql_connect("localhost", "root", "pass");
	  mysql_select_db("commander");
	  
	  $query = mysql_query("SELECT * FROM news");
	  $rows = mysql_fetch_array($query);
	  
	  echo "$rows[title]";
                              echo "$rows[description]";

[Potatis]

while($row = mysql_fetch_array($query)) {

echo $row['title'];
echo $row['description'];

}

 

 

Is what you need.

[amycoll]

It echoes like 1000000 of them, 

[ignace]

If you only use $row['world'] type use mysql_fetch_assoc if you want to do something like list($field1, $field2) then use mysql_fetch_row mysql_fetch_array returns both whereby you get:

 

Array ( [0] => hello, ['world'] => hello, [1] => bar, ['foo'] => bar )

[PFMaBiSmAd]

To return specific rows you are interested in, you must use a WHERE clause in your query - http://w3schools.com/php/php_mysql_where.asp

[Lukeidiot]

 

$query = mysql_query("SELECT * FROM news LIMIT 10");
while($row = mysql_fetch_array($query)) {

echo $row['title'];
echo $row['description'];

}

 

 

Is what you need.

[amycoll]

I don't want to echo specific ones, just normal ones but it gives only one announcement/new instead it gives 4 of them as theres 4 of them in DB.

[amycoll]

Anyone? 

[Lee]

If there are 4 of them in the db, then as PFMaBiSmAd says, you need to use the WHERE clause in your query to specify which one to output. Otherwise, the loop will keep outputting every row in your sql table.