User Profile

Collapse

Profile Sidebar

Collapse
dinox
dinox
Last Activity: Nov 18 '07, 11:46 AM
Joined: Nov 17 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dinox
    replied to help with multiple order by conditions...with rand()
    in MySQL
    hey this is worked perfectly!!
    thanks alot dude!! you are a great help!

    i tried something exactly similar to this long ago but i got errors (i guess my bad) so i thought this is not the right way to begin with.... but in fact it is !...
    See more | Go to post

      Leave a comment:

    • dinox
      replied to Adding data to row without replacing existing data.
      in MySQL
      well i don't quite understand what do you mean by adding without rewriting but i guess you mean something you can use in mysql alone as shortcut ...

      for example for incrementing numbers columns...try..
      [CODE=mysql]UPDATE table SET column = column + 1 .. etc[/CODE]
      See more | Go to post
      Last edited by bartonc; Nov 17 '07, 10:31 PM. Reason: Added [CODE=mysql][/CODE] tags.

        Leave a comment:

      • dinox
        started a topic help with multiple order by conditions...with rand()
        in MySQL

        help with multiple order by conditions...with rand()

        hello, i tried searching for something similar to my situation but i haven't found so far..

        for example ...
        i have users table with 15 registered users and i want to show only 5 of them in front page...the table has (id) as unique value...
        and i want to make an sql query that shows the 5 users registered lately...

        ...how?
        by picking (random 5 ) users from the ( last 10 inserted users in table...)...
        See more | Go to post
        Last edited by mwasif; Nov 18 '07, 10:07 AM. Reason: Added [CODE=mysql]/[/CODE] tags
        No activity results to display
        Show More
        Working...