Solved

Php script to sort SQL database names alphabetical

Posted on 2013-02-01
3
460 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 110

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
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…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

707 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