Query within an echo.

[jason360]

Hey guys,

 

I am stuck on this piece of code. Within the function I am using I need to include an mysql query.  I am not sure how to insert it within the echo.  Currently the query works but the code stops once close the '' and </ul> and </section> are cut out.

 

Please note that there is alot more code within the echo, not just the section and ul.  Just simplified it for my question.

 

Any help would be appreciated.

 

Thanks

 

<?php
  $query = mysql_query('SELECT id FROM videos WHERE user="'.$id.'"');
list ($video_id) = mysql_fetch_array($query);


if ($video_id != '') {


 echo '<section>
       <ul >';


       $query = mysql_query('SELECT video FROM videos WHERE id="'.$id.'" ORDER BY RAND()');
                        
       $i = 0;
                        
        class myCounter implements Countable {
        public function count() {
        static $count = 0;
        return ++$count;
        }
        }
                                                
        $counter = new myCounter;
                        
        while ($row = mysql_fetch_array($query))
                        
        {
                        
        if($i % 5 === 0)
                        
        {
                        
                        
        }


echo "<li data-path='feeds/api/videos/".$row['video']."' ></li>";
                                               
        $i++; 
        }
                                            
'</ul>
</section>';


?>

Edited January 16, 2015 by jason360

[QuickOldCar]

You need to echo it as well

echo '</ul>
</section>';

[jason360]

Thanks QuickOldCar...that was simple.