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
    Aug 2011
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mysql not giving everthing

    Hello guys I have a problem here I am trying to get php to give everything in a table in my database.. but its only giving me the rows with numbers and not the ones with words in it. here is the code.

    PHP Code:

    <?php 
    // Fetch all needed records
    // But fetch *ONLY* the FIELDS that are needed!
    $strQuery "SELECT * "
    " FROM lead_partners_pages "
    " WHERE partner_id_buyer ";
    $result mysql_query($strQuery) or die(mysql_error());
    while(
    $ors mysql_fetch_array($result)) 
    {
    echo 
    "<li class=\"FLeft\" style=\"list-style-type:none\">" $ors['partner_id_buyer'] . "</li>";
    }
    ?>

    I I know should not have numbers and words in a column but I will be changeling this soon. I just don't understand why I cant see them both when I do the query.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,339 Times in 4,305 Posts
    Get rid of your WHERE clause.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

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