Solved

Php script to sort SQL database names alphabetical

Posted on 2013-02-01
3
456 Views
Last Modified: 2013-02-01
Php script to sort SQL database names alphabetical

Hi I have a table called teachers in it there is two fields ID and Name
I want this name filed to be alphabetical when a user adds a new name. Is there a script I can run that sorts the table from A TO Z or do I need to add something to my input php script to force the name to go alphabetical?
Thank
 i have added the incert script just in case

<?php 

// Read values from form using $_POST (safest) 


$fname=$_POST["vname"]; 


// Connect to server 
// Replace username and password by your details  

$db = @mysql_connect("localhost","username","password"); 
if (!$db) 
{ 
        do_error("Could not connect to the server"); 
} 


// Connect to the database 
// Note that your database will be called username 

@mysql_select_db("test",$db)or do_error("Could not connect to the database"); 

// Run query 

$sql="INSERT INTO teacher (name) values ('$fname')"; 

if (mysql_query($sql,$db)) 
{ 
        echo "The following Teacher"; 
        echo "<br>Record: $fname  has been added to the          
        database.<p>"; 
} 
else 
{ 
        do_error("Failed to add record"); 
} 

function  do_error($error) 
{ 
        echo  $error; 
        die; 
} 

?> 

Open in new window

0
Comment
Question by:paddy086
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 38843429
no. the INPUT (INSERT) into the table will not and cannot "sort" the names alphabetically.
you have to do this during the SELECT ...
SELECT ID, NAME FROM teacher ORDER BY NAME

Open in new window

0
 
LVL 20

Assisted Solution

by:Mark Brady
Mark Brady earned 50 total points
ID: 38843462
If you just want to view the names alpabetically in something like phpmyadmin or netwbeans you could click on the column header and it will sort either ascending or descending. There is no way to have an insert query insert a record alphabetically unfortunately.

There are to many things that it would break. For instance, if an id column was set to auto insert then an alpabetical insert would break that system (the numbers would not be incremental).

You can sort all your result when you do  a select query.
0
 
LVL 109

Assisted Solution

by:Ray Paseur
Ray Paseur earned 50 total points
ID: 38843497
You might want to get this book and work through the examples.
http://www.sitepoint.com/books/phpmysql5/

It will help you learn how PHP and Databases work together.  And it has examples using PDO.  That's important because MySQL is being deprecated and removed from PHP very soon.  So don't start a new project with the MySQL extension -- choose one of the other APIs or one of the other data bases.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question