SQL query in pyramid structure |
SQL query in pyramid structure |
Barbara |
Dec 17 2015, 04:59 PM
Post
#1
|
Group: Members Posts: 2 Joined: 17-December 15 Member No.: 23,837 |
Hi! I have problem with displaying sql query in pyramid structure (it is made like a table). I am working in Wordpress. I want to display name by his pyramid number and I want to show it in table (pyramid). I don't know what loop is best for that. I have made something like this: get_results("SELECT pyramid_number, CONCAT(name,' ',last_name) AS user_name FROM users");?>
And this is the first row of my pyramid. I have tried to put pyramid number inside <td> and user_name between <td></td> but obviously I don't know how. <table class="pyramid"> <tbody> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td if pyramid_number=1>user_name</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> |
Lo-Fi Version | Time is now: 25th April 2024 - 07:58 PM |