Help with foreign key

Question

I have an intranet system where the user creates a message for different sectors of the company, after creating the message, it can be edited and when it suffers a change, it puts an edited hyperlink at the end of the message, which when clicked, opens a modal with the original message.

So far so good, the problem is when a note suffers more than one change, man select always take the first record, instead of taking all. I will try to describe how it works:

TABLE MESSAGES has (id, message, date, time) and etc. TABLE RECADOS_EDITADOS has (id, id_messages <- foreign key of messages.) etc

EXAMPLE:

Make a INSERT on the table ERRANDS it receives id=31. If I modify this message, a UPDATE on the table ERRANDS and a INSERT on the table RECADOS_EDITY, which receives an id from him and the id=31, which would be the foreign key. If I make another UPDATE on the table ERRANDS, the table RECADOS_EDITY suffers another INSERT with the same foreign key 31.

There when I make one select for example SELECT * FROM RECADOS_EDITADOS WHERE id_recados = 31, he picks up the first record with 31 and not all.

I tried to do it and it didn’t solve:

  $select = mysql_query("SELECT * FROM recadosedit WHERE idRecados = '$id'");
    $v = mysql_fetch_array($select);


    $linhas = mysql_num_rows($select);

    $recadoAnterior = array();
    $dtAlterado = array();
    $hrAlterado = array();


    for($i = 0 ; $i <= $linhas ; $i++){
    $recadoAnterior[$i] = $v['recado'];
    $dtAlterado[$i] = $v['dtAlterado'];
    $hrAlterado[$i] = $v['hrAlterado'];
    }

At the time of showing I also do a go, but it always shows the same record.

 for($i = 0 ; $i <= $linhas ; $i++){echo '

       <div class="row">
        <div class="small-12 medium-12 large-12 columns">
    <label>'.$recadoAnterior[$i].'</label>
    <label>Data alterado:</label>'.$dtAlterado[$i].' <label>Hora alterado:</label>'.$hrAlterado[$i].'


    </div>
      </div>';
      }

Answer 1

Do the following:

$select = "SELECT * FROM recadosedit WHERE idRecados = {$id}";
    if($query = mysql_query($select)){
        if(mysql_num_rows($select)){
            while($resultado = mysql_fetch_array($select)){
                $resultados[] = $resultado; 
            }   
        }   
    }

    if(!empty($resultado)){
        foreach($resultados as $resultado){
            print " Recado: " . $resultado['recado'];
            print " Alterado(data): " . $resultado['dtAlterado']    
            print " Alterado(horas): " . $resultado['hrAlterado']   . "<br/>";
        }   
    }

Well, I don’t have much time, so I’ll be simple and objective.

The problem is how you return the values of this query with the mysql_fetch_array:

$v = mysql_fetch_array($select);

In this case, you only store the value of the first column of the results found in this query. For this, you only need to enter the mysql_fetch_array in a loop, as in the example above:

while($v = mysql_fetch_array($select))
{
...
}

Why should we not use mysql type functions_*?