Help needed - getting info out of db(newbie)

Stinos

Okay, i have a tabel videos with the fields: ID, name, style, place, size, image, download

I know how to do sql queries, but this is what i want to manage:

I take ID and name from the database.

Then i want to create a page where all the names are sorted from A-Z and after everyname there is a link 'Click here',but it needs to contain the id, for example, showvideo.php?id=1

So the page should be like this:
Video-section
Name Click Here(showvideo.php?id?=12)
Name Click here(showvideo.php?id=2)

Can someone help me? I know it's quite easy but i'm a newb 🙂

rincewind456

Something like this :

<?php

if (isset($_GET['id'])){

$id = mysql_real_escape_string($_GET['id']);

$sql = "
SELECT download 
FROM videos 
WHERE id =".$id;

$result = mysql_query($sql);
// code here for doing whatever you want to do next

} else {

$sql = "SELECT id, name
FROM videos";
	$result = mysql_query($sql);

while ($row = mysql_fetch_row($result)) {

	foreach ($row as $id => $name)
	print '<a href="showvideo.php?id='.$id.'">'.$name.' Click Here</a>';
}
}
?>

Stinos

i didn't explain it good.

The ID isn't send through url.
I just have a tabel with the fields id and name. So i take a query of those two fields.

I want a list of those names sorted from A-Z. I guess that needs to be done with a if construction.

But after every name, there is a link 'Click here' that need to contains the id, for example showvideo.php?id=1

Any help is appreciated!