List database file and place a new line after a certain number

Question

List database file and place a new line after a certain number

Navigation

#1 by (0 votes)

0

I've been trying to find a small solution for days:

Example:

I have this code:

//LISTAR AS PLAYLISTS
$dados_playlist = mysql_fetch_array(mysql_query("SELECT * FROM playlists where codigo = '".$_POST["playlists"]."'"));

At the time it is listed, I need to put 1 command (".$hora."".$minuto.") after a certain number that the user chooses.

Example:

Normal list:

1. Música 
2. Música 
3. Música 
4. Música 
5. Música 
6. Música

Now, an example of how I need to leave it after it is listed:

1. Música 
2. Música 
3. Música 
".$hora."".$minuto."
4. Música 
5. Música 
6. Música 
".$hora."".$minuto."

(in the case above the user selected: run every 3 songs right time)

After this, I'll save this list to a temporary file - > execute a cron so that ".$hora."".$minuto." is spoken in a player

php mysql inserir

asked by anonymous 29.07.2015 / 23:50

1 answer

Routine to validate if date is earlier than today if it is to change the state of the field to complete Referencing a group of ID's resulting from 'group_concat'

score 0 · Answer 1

$count = 1;
while( $row = mysql_fetch_array(mysql_query("SELECT * FROM playlists where codigo = '".$_POST["playlists"]."'")) )
{
    if( $count == $escolha_usuario1 )
    {
      echo "HORAMINUTO";
    }

    if( $count == $escolha_usuario2 )
    {
      echo "HORAMINUTO";
    }

    if( $count == $escolha_usuario3 )
    {
      echo "HORAMINUTO";
    }

    $count++;
}