php/sql oddities?!

[Anon]

Hello all,
yes i'm still pretty much a novice at this, but my goal is to learn this as best as I can, and one way I am going about doing this, is through my little web application. but i'm running into a brick wall, and didn't see any problem like this (i didn't look extensively, and I apologize if this has been asked before).

I read the ol' book PHP Essentials, and modified some code from Julie's examples to do some of the things I want, but I run into a problem at a certain point. My site/project ( http://thematrix.cl.msu.edu/sneezer/ ) is set up to post news/rants/etc. on the front page for everyone to see. That's all fine and dandy you say, but the 10th story always winds up down by the #1 story. Why is that? Is there something wrong with my SELECT query? (SELECT * FROM news ORDER BY sid DESC) Anyone can view the source of this page using the site above, plus index.phps. Anyehelp would be highly appreciated!!!!! Thank you!

./brm

[Anon]

just a little side note, no more stories can be posted b/c of a shortcoming in my (newbie) programming, that I just figured out what was wrong with it (I think) but you can delete stories and add them to see if you can figure anything out =\ Thanks.

./brm

[brandonschnell]

its sorting as if the sid where a string and not a integer. check how you're creating the database and see if sid is type string or type int.

[Anon]

well, you were exactly right!! 🙂 It was a string and not an integer. smacks forehead Thanks Brandon!

./brm