Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Mysql not giving everthing
09-19-2011, 06:02 PM #1
- Join Date
- Aug 2011
- 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.
// 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.
09-19-2011, 06:25 PM #2
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.