Hey everyone,

I'm new to the forum (as well as php), and I'm looking for a bit of help on a blog-like solution I'm trying to build up. On my front page I have three columns (technology, music, and movies) and I would like to have the php pull the content out of the mysql database and display it on my website.. Which I've been able to successfully do.

However I have a field in my mysql database called disclude_categories which is numeric and what I would like to have is when it is set to 1 it doesn't show up on my front page. I thought that maybe I could include it on my while loop, but can't seem to get it to work.

Here's the code that I have so far:

mysql_connect($host,$user,$pass) or die("ERROR:".mysql_error());
mysql_select_db($database) or die("ERROR DB:".mysql_error());
$query = "select * from blog WHERE categories='Technology' ORDER BY date DESC";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {         
            echo $row['content'];                                                                        }

like

PHP Code:

$query = "select * from blog WHERE categories='Technology' AND disclude_categories!='1' ORDER BY date DESC"; 


?? this doesn't even pull the row out if its set to 1

Not too sure what you mean by "?? this doesn't even pull the row out if its set to 1" but that worked perfectly.

Thank you

i just wasn't sure if you wanted to use the data is any other ways... the method above excludes all of the ones set to 1...

its the proper way so glad it works for you

disclude_categories!='1' would be searching for a STRING value NOT a numeric value

I don't plan on using the data in any other way (at least on this page). But thank you for looking out for that.

Originally Posted by chrishirst

disclude_categories!='1' would be searching for a STRING value NOT a numeric value

what would be searching for a numerical value? Using quotation marks instead?

using nothing around the value

Ohhhh, that makes sense now that I think about it. I'll change it.

Originally Posted by chrishirst

disclude_categories!='1' would be searching for a STRING value NOT a numeric value

my apologies so disclude_categories!=1