How to display more than one value with the same identifier from the database?

Question

PHP

with this query I output
$query="select `id_photo` from `reiting` where `id_user`=".$_SESSION['user']."";
but in the table 2 id_user and accordingly I need to display 2 id_photo but how?

Answer 1

It is completely unclear what the problem is (given that the request is written correctly). Or a problem in PHP-implementation? :) You can do, for example, like this:

$query="select `id_photo` from `reiting` where `id_user`={$_SESSION['user']}";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_assoc($result))
{
  echo "{$row['id_photo']}.<br/>";
}