...

View Full Version : Mysql not giving everthing



Atrhick
09-19-2011, 07:02 PM
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
// 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.

Old Pedant
09-19-2011, 07:25 PM
Get rid of your WHERE clause.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum