Welcome to WebmasterWorld Guest from 188.8.131.52
$result = mysql_query("SELECT * FROM table_name WHERE active ='1'");
$row = mysql_fetch_array($result);
This is a very basic script, I'll add the bells and whistles later but first I need to get this part to work. When I go to this page with my browser, I get the meta title tag but nothing in the body of the browser (I just get a blank screen).
1. Yes, I have included the database information in an include.
2. Yes, there is a post in the db with active set to 1.
Also your print is trying to print an array and not a value. It should be something like:
My guess though is that the query is failing or you probably would have seen the word 'array' on the output.
Ah, yes... when I changed active to 1, it didn't "take". It works with the active part now. Sorry about that and thanks for the help!
Now I'm off to try to make a script that will generate an html table with this information in it... Shouldn't be too hard...