Again the dumb question. Sorry in advance and thanks for your responses in advance!
Here is my code after the DB connection:
$result = mysql_query( "SELECT * FROM overall WHERE profilename IS NOT NULL AND username = '$reguser'" )or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo $row['profilename'].$row['prodesc']."<br />";
}
What I am trying to do is to echo only those records that meet both criteria. My problem is this for example:
there are 10 records where the above is met and an additional 20 records where only one or the other is met. My echo results 30 rows, 20 empty and 10 with the data requested.
Tried what I could find, but all solutions seem to be aimed at surpressing individual records in the result, such as preventing the record in the row.
Again, thanks in advance for your help.