StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You need to do two thing, first is an SQL query to retrive the values, you can do something like:</p> <pre><code>SELECT firstname,lastname,country FROM TABLE WHERE listedagree='Y' ORDER BY country </code></pre> <p>When you retrive the data on PHP you need to iterate over it, keeping the acctual country in a temp variable to be able to detect when it changes, for example you cand o something like:</p> <pre><code>//Conect to the database mysql_connect("hostaddress.com", "username", "password") or die(mysql_error()); //Selet the database to work with mysql_select_db("Database_Name") or die(mysql_error()); $sql = "SELECT firstname,lastname,country FROM TABLE WHERE listedagree='Y' ORDER BY country"; //retrive the data $result = mysql_query($sql) or die(mysql_error()); //Now iterate over the result and generate the HTML $html = ''; $tmp_country = ''; while($data = mysql_fetch_array( $result )) { //If the country have changed if($tmp_country != $data['country']) { //Check if we need to close the UL if($tmp_country != '') {$html .= "</ul>"}; //Print the country header $html .= "<h4>$data['country']</h4>"; $htm l .= "<ul>"; //store the last country $tmp_country = $data['country']; } //Add the names to each country $html .= "<li>$data['firstname'] $data['lastname']</li>"; } //Close the last UL $html .= "</ul>"; </code></pre> <p>I couldn't try the code so maybe it need some fine tunning to get it working but the it will do the job, if you have any problems let me know and i will help you.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload