random not working well!!

itworks

does anyone know what's wrong with this?

i'm trying to pull one row out of a database randomly but there's always one of the db entries that never shows up.

i have this:

$sql=mysql_query("SELECT * FROM news ORDER BY RAND() LIMIT 0,1);

thanks in advance.

urneegrux

You're missing a ".

$sql=mysql_query("SELECT * FROM news ORDER BY RAND() LIMIT 0,1");

itworks

yeah but that was a typing error it's ok though in the script but it has that problem.

WHY?! 😕

cdxrevvved

Why not just do something like this? This way at least your breaking it up more so if one particular headline doesnt show up, its in the rnd variable not the sql, or the other way around...

I dunno.. just a thought...

😉

$rnd = rand(); // or however your initializing your random #'s
$sql=mysql_query("SELECT * FROM news WHERE id LIKE $rnd");

PS: cant guarantee my sql query above is correct, but hey.. its an ex... 🙂

itworks

not a bad thought but it doesn't solve the problem.

anyone else?!

cdxrevvved

thats odd.. and its only this one headline that wont pull up?

Maybe try deleting that record from the db and recreating it?

itworks

i've tried deleting it and inserting another but the problem persisted, not in the new entry but in another.

so anything i do i can't get it to show all the entries, one just doesn't show.

it's not 'cause it is the first and is not only with a specific entry.

strange isn't it?! not a big problem 'cause i'll still have lot's of others to show but it's defenetly very annoying.

cdxrevvved

that would be irritating.. Im at a loss... maybe a bad table? I dont know.. that would be the last thing i can think of, drop the table and recreate it

but thats almost too much work for such a small annoyance..

itworks

yes i tried recreating the table and i inserted 6 entries and refreshed for like 1.000.000.000.000.... times and in those times 3 products showed an equal amount of times, a 4th showed only once and the other 2 never.

😕