Solved

Php script to sort SQL database names alphabetical

Posted on 2013-02-01
3
445 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 142

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 108

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
This article discusses how to create an extensible mechanism for linked drop downs.
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…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

708 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now