jquery - how to get data to html <ul> <li> </li> </ul> list from mysql database with php -

i have video player , want populate video on mysql database, here code.

<ul id="playlist1" style="display:none;">     <li data-thumb-source="assets/img/ddd.jpg" data-video-source="assets/video/ddd.mp4" data-poster-source="assets/img/ddd.jpg" data-downloadable="yes">         <div data-video-short-description="">             <div>                 <p class="minimaldarkthumbnailtitle">ddd</p>                 <p class="minimaldarkthumbnaildesc">dddd.</p>             </div>         </div>         <div data-video-long-description="">             <div>                 <p class="minimaldarkvideotitledesc">dddd</p>                 <p class="minimaldarkvideomaindesc">ddd</p>                 <p>for more information please follow <a href="#" target="_blank">this link</a></p>             </div>         </div>     </li> </ul> 

my mysql database has following columns

• id
• data-thumb-source
• data-video-source
• data-poster-source
• minimaldarkthumbnailtitle
• minimaldarkthumbnaildesc

my php code data database:

<?php     $result= mysql_query("select * video order id  desc" ) or die (mysql_error());     while ($row= mysql_fetch_array ($result) ){     $id=$row['id']; ?> 

however, video player blank because has nothing play.

edit: used code display value

<ul>     <?php     $sql = "select * `mytable`";     foreach ($db->query($sql) $row) {         $li  = '<li> data-thumb-source="' .$row['data-thumb-source']. '"';         $li .= ' class="playlistitem" data-type="local"';         $li .= ' data-video-source="' .$row['data-video-source']. '"';         $li .= ' minimaldarkthumbnailtitle="' .$row['minimaldarkthumbnailtitle']. '"';         $li .= ' minimaldarkthumbnaildesc="' .$row['minimaldarkthumbnaildesc']. '"';         echo $li;     }     $db = null; ?> </ul> 

this did not make difference though.

you closed opening li tag before defining attributes.

<ul> <?php $sql = "select * `mytable`"; foreach ($db->query($sql) $row) {     $li  = '<li data-thumb-source="' .$row['data-thumb-source']. '"';     $li .= ' class="playlistitem" data-type="local"';     $li .= ' data-video-source="' .$row['data-video-source']. '"';     $li .= ' minimaldarkthumbnailtitle="' .$row['minimaldarkthumbnailtitle']. '"';     $li .= ' minimaldarkthumbnaildesc="' .$row['minimaldarkthumbnaildesc']. '"';     echo $li . '>descriptions</li>'; } $db = null; ?> </ul>