SQL Help

[Funny]

This is a easy code but I am not able to figure it as Im fairly new to SQL.

Example I have a table like this-
Name: ID:
abcde 1
efghia 3
pofjsa 5
asklda 6

I want to sort the tables according to increasing ID.
Like this-
Name: ID:
abcde 1
efghia 2
pofjsa 3
asklda 4


Assuming that the ID's are continuously increasing but there are some ID's missing like 11,14,15,16,17,20,21.. etc

Thanks

 

[soft2050]

Simply use ORDER BY column_name here in your sql query

Example:

SELECT * FROM mysecrettable ORDER BY names

 

[Mr Happy]

Just to add to the above you can have ORDER BY something DESC or ORDER BY something ASC
which means you can have it decreasing (DESC) or ascending (ASC)

 

[Lock Down]

I believe soft meant to say :

SELECT * FROM mysecrettable ORDER BY id asc

 

[soft2050]

nah
That would make it from ascending order of the id of the column
Specifying the name of the field would result in the data output in acending order of the column.

http://php.about.com/od/learnmysql/p/SQL_order_by.htm

 

[Lock Down]

This is a easy code but I am not able to figure it as Im fairly new to SQL.

Example I have a table like this-
Name: ID:
abcde 1
efghia 3
pofjsa 5
asklda 6

I want to sort the tables according to increasing ID.
Like this-
Name: ID:
abcde 1
efghia 2
pofjsa 3
asklda 4


Assuming that the ID's are continuously increasing but there are some ID's missing like 11,14,15,16,17,20,21.. etc

Thanks

He said he wanted it by id. check his quote again.

And I guess you can use this link http://php.about.com/od/learnmysql/p/SQL_order_by.htm and one for reading http://www.rif.org/

 

[Funny]

Thank you for the help guys.

 

[Funny]

Now I have another question-
I want to update a column in my sql but I think I got the syntax wrong-

UPDATE `url` SET `destination`="http://"+`destination` WHERE `destination` NOT LIKE 'http%'

It sets destination as 0 instead of http://+destination..
:O

 

[Halcyon]

Use || for concatenating strings

UPDATE `url` SET `destination`='http://'||`destination` WHERE `destination` NOT LIKE 'http%'

 

[Lock Down]

You are welcome and for the update..
try this one:

UPDATE `url` SET `destination`=concat("http://",`destination`) WHERE `destination` NOT LIKE 'http%'

PS backticks are a pain and most systems work without them.

so it could be simply:

UPDATE url SET destination=concat("http://",destination) WHERE destination NOT LIKE 'http%'

BY the way when you use + mysql tries to add..

when you use || it means or not concat...

 

[Funny]

@ Halcyon- That didn't work.

@ Lock Down- It worked actually. Thanks a ton. +rep
Btw it was not working when there was double quotes in "http://", i changed it to 'http://' and it worked like a charm!

 

[Funny]

Also is there a way to do this in php-
If 'destination' is not like 'http://%' then concat 'http://' and destination and store it in destination itself, that is: destination=http://+destination

 

[jomasaco]

$destination = array('http://www.wjunction.com/92-development-area/128851-sql-help-2.htm#post1400928',
'URL2.com',
'URL3.com',
'http://url4.com',
'http://www.url5.com'
);
var_dump($destination);
echo '$destination by default <br />';
foreach($destination as $destine) {
if(!strstr($destine, 'http://')){
echo '</b>http://'.$destine.'</b> Not found so i included<br />';
$destination2[] = 'http://'.$destine;
}else{
echo 'YES - Found http:// in <b>'.$destine.'</b><br />';
$destination2[] = $destine; 
}
}
echo '<br />the new array whith http:// on all values <br/>';
var_dump($destination2);

 

[Funny]

@ jomasaco:

In your previous code-

if(!strpos($string, 'http://')) {
$string = 'http://'.$string;
}

It works, but it appends http:// to urls having http:// also.
For example url is-
www.example1.com
then it makes it http://www.example1.com
But when url is already like-
http://www.example2.com
then it makes it http://http://www.example2.com

Edit-
Nvm, i changed strpos to strstr and it works like a charm.. X)
Thank you +Rep

 

[Lock Down]

Also is there a way to do this in php-
If 'destination' is not like 'http://%' then concat 'http://' and destination and store it in destination itself, that is: destination=http://+destination

You are welcome.


DO you mean write a mysql query in php for that command?

 

[Funny]

@ Lock Down-
Actually the issue is already solved. Thanks for your interest./

 

[delandil]

first select column with Select (Column Name) from Table Name

then Order By default comes with ASC no need to type it.