Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jun 2005
    Posts
    41
    Thanks
    3
    Thanked 0 Times in 0 Posts

    select non empty row?

    How do i go about selecting from mysql the newest entry in table but all fields must not be empty, or a single declared row must not be empty?

    PHP Code:
    $q"select id from tab where thisrow (is not empty) order by name desc"
    I dont want to display from mysql if its empty...

  • #2
    Regular Coder sea4me's Avatar
    Join Date
    Jan 2009
    Location
    Damn, I don't know...
    Posts
    390
    Thanks
    11
    Thanked 28 Times in 27 Posts
    PHP Code:
    $q "SELECT `id` FROM `tab` WHERE `thisrow` IS NOT NULL order by name desc"
    Not tested...


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •