2 Query Problems Need Help

[tuf-web_co_uk]

1. i have a news system on my site and i wanted to know how you make it only show the last 10 posted, so that my main page doesn't get cramped!

$sql = "select * from stories ORDER BY id desc";
$result = mysql_query($sql, $conn);

what will i need to add to my query?!

2. i have a mobile phone tones on my website and would like to show only the tones which have an artists initial as a, then b, so that they are categorised.

what would i need to add to my query?!

Thanks Inadvanced, I Appreciate It!

[rIkLuNd]

1.
$sql = "select * from stories ORDER BY id desc limit 0,10";
$result = mysql_query($sql, $conn);

2.
$sql = "select * from tones ORDER BY name asc";
$result = mysql_query($sql, $conn);

[tuf-web_co_uk]

the first bit of help is what i needed thanks 😃

but the second will show all of the results from the database in alphabetical order when i only want to show the a's, then on say the page tones.php?letter=b it shows only the b results

Thanks

[rIkLuNd]

try this:

$query = "select * from tones where (name LIKE '".$_GET['char']."%d')";
$sql = mysql_query($query) or die(mysql_error());

I am not sure about this, but let me know if it was correct...

[tuf-web_co_uk]

yeah that worked great thanks very much man

[rIkLuNd]

you're welcome!