problema con stampa array

[Dj Darius]

Salve a tutti ho un problema con questo script
tutto funziona correttamente, però quando si arriva a "echo "The preselected genre is $result_row_search_genre[0] ";" mi stampa solo e sempre il primo elemento dell' array nonstante si selezioni un diverso Record con consequente diverso genre.
La query funziona difatti in fondo ho fatto stampare tutto l' array come potete notare e appunto li stampa in ordine...

Una mano perfavore...

    <?php 
include_once('db_connect.php');
                        
$user_id=$_SESSION['logged'];

$query_select_release=" SELECT code, artist, title FROM Record WHERE Record.user = '$user_id'";
                         
                         $result_select_release=mysql_query($query_select_release) or die("error select_release");
                         
                         while($result_row_select_release=mysql_fetch_row($result_select_release)){
                         
                         echo "<option value=\"$result_row_select_release[0]\">$result_row_select_release[0] $result_row_select_release[1] - $result_row_select_release[2]";
                         
                         }
                         ?>
                         
</select></p>
<input type="submit" name="sbt_btn_slct_rls" value="Select" />
</form>
<?php 
                        
if (isset($_POST['sbt_btn_slct_rls'])){
echo "<h2>Edit release</h2>";
                        
$select_release_id=$_POST['select_release_id'];
                    
$query_show_release="SELECT artist, title, recordDate, recordVisibility, label, catalogNumber, description FROM Record WHERE Record.code = '$select_release_id' ";    
                    
$result_show_release=mysql_query($query_show_release) or die("error show_release");
                    
                    $result_row_show_release=mysql_fetch_row($result_show_release); 


$query_search_genre="SELECT Genre.genre FROM Genre JOIN Record ON Genre.record=Record.code";
                        $result_search_genre=mysql_query($query_search_genre) or die("error search_genre");
                        $result_row_search_genre=mysql_fetch_row($result_search_genre);

                    
echo " <form id=\"r_data\" action=\"release_insert.php\" method=\"post\" name=\"add_release\" onsubmit=\"return (formControl());\" enctype=\"multipart/form-data\">


<label for=\"release_artist\">Artist</label><input type=\"text\" id=\"release_artist\"  name=\"release_artist\" value=\"$result_row_show_release[0]\"/></p> 


<label for=\"release_title\">Title</label><input type=\"text\" id=\"release_title\" name=\"release_title\" value=\"$result_row_show_release[1]\"/></p>


<label for=\"release_date\">Release date (YYYY-MM-DD)</label><input type=\"text\" id=\"release_date\" name=\"release_date\" value=\"$result_row_show_release[2]\"/></p>


<label for=\"release_label\">Label</label><input type=\"text\" id=\"release_label\" name=\"release_label\" value=\"$result_row_show_release[4]\"/></p>


<label for=\"release_catNumber\">Catalog number</label><input type=\"text\" id=\"release_catNumber\" name=\"release_catNumber\" value=\"$result_row_show_release[5]\"/></p>";}
if (isset($_POST['sbt_btn_slct_rls'])){
    
echo "The preselected genre is $result_row_search_genre[0] ";

echo  "

<label for=\"release_genre\">Genre</label><select id=\"release_genre\" name=\"release_genre\">
 <option value=\"\">
 <option value=\"Breakbeat\">Breakbeat
 <option value=\"Breakcore\">Breakcore
 <option value=\"Drum and Bass\">Drum and Bass
 <option value=\"Dubstep\">Dubstep
 <option value=\"Electro\">Electro
 <option value=\"Electronica\">Electronica
<option value=\"Garage\">Garage
<option value=\"Hip Hop\">Hip Hop
<option value=\"House\">House
<option value=\"IDM\">IDM
<option value=\"Industrial\">Industrial
<option value=\"Jungle\">Jungle
<option value=\"Rap\">Rap
<option value=\"Techno\">Techno
<option value=\"Trip Hop\">Trip Hop
<option value=\"Other\">Other
</select></p>
 

<label for=\"release_description\">Description: </label>

<textarea id=\"release_description\" rows=\"5\" cols=\"30\" name=\"release_description\"></textarea></p></p>


<label for=\"select_visibility\">Select visibility</label>
 <select id=\"select_visibility\" name=\"select_visibility\">
<option value=\"vib_all\">public
<option value=\"vib_none\">friends only
</select>
</p>


<label for=\"cover\">Release cover</label><input type=\"file\" id=\"cover\" size=\"10\" name=\"release_cover\" /></p>


<input type=\"submit\" value=\"Submit\" class=\"sbt_btn\" name=\"sbt_btn_rls\"/></p>
</form>";
                        
                        while($result_row_search_genre=mysql_fetch_row($result_search_genre))
                         
echo "<ul>[*]$result_row_search_genre[0][/list]";
                         }
                         
?>

[Dj Darius]

La query giusta era questa.

$query_search_genre="SELECT Genre.genre FROM Genre JOIN Record ON Genre.record=$select_release_id"; 

Stavo prendendo la prima riga della tabella e non la prima riga di quello che selezionavo.