Advertisement
Cannoneer

Вивід данних із БД у циклі

Sep 4th, 2016
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. <?php
  2. include ("system/functions/db/db_connect.php");
  3. $c_list = mysql_query("SELECT id,title,author_nick,s_theme FROM courses WHERE verified=TRUE AND banned=FALSE");
  4. $c_data = mysql_fetch_array($c_list);
  5. if ($c_list == FALSE) {
  6. echo("Не знайдено!");
  7. }
  8. else
  9. {
  10. do
  11. {
  12. printf("
  13. <table class='lesson'>
  14. <tr>
  15. <td class='lesson_title'>
  16. <a href='view-lesson.php?id=%s'><p class='lesson-name'>%s</p></a>
  17. <p class='lesson_adds'>Автор курсу:%s</p>
  18. </td>
  19. </tr>
  20. <tr>
  21. <td>%s</td>
  22. </tr>
  23. </table><br><br> ", $c_data["id"], $c_data["title"], $c_data["author_nick"], $c_data["s_theme"]);
  24. }
  25. while($c_data = mysql_fetch_array($c_list));
  26. }
  27.  
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement