Tuesday, March 26, 2013

Alphabet listing of result in php mysql

<?php

//CONNECTS TO YOUR DATABASE (MODIFY TO YOUR SETTINGS)
mysql_connect("localhost", "root", "");
$db = 'library';
$table = 'titles';

$alpha = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");

//LISTS TITLE IN ALPHABETICAL ORDER UNDER EACH LETTER
foreach($alpha as $a){
    $q = mysql_query("SELECT * FROM $db.$table WHERE title LIKE '$a%'");
    $n = mysql_num_rows($q);
   
    //EXCLUDES LETTER IF THERE TITLES THAT START WITH IT
    if($n){
        echo '<b style="font-size:20px">'.$a.'</b><br><br>';
        while($r=mysql_fetch_array($q)){
            echo $r["title"].'<br>';
        }
        echo '<br>';
    }
}

?>

CREATE TABLE `titles` (
    `title` VARCHAR ( 100 ) NOT NULL
) ENGINE = MYISAM;
INSERT INTO titles VALUES ('Alpha'), ('Betical'), ('Order'), ('Demo'), ('Demo2'), ('Demo3', 'Indexing');

No comments:

Post a Comment

Thank you for your Comment....

Popular Posts