[RESOLVED] Having trouble with displaying the data...

Twilite_Kid_82

Hey,

Originally these files worked, but then I went to build a new template around them and now the data isnt being retrieved and show on the pages..

here are the two files

any ideas and help would be appreciated 🙂

NogDog

Can't be sure, but from the error messages on the 2nd link it looks like perhaps your mysql_connect() is failing. You might want to add some debugging info to it:

$link = mysql_connect($dbHost, $dbUser, $dbPwd) or die("DB connection failed. " . mysql_error());

Obviously, since we can't see your source code, I'm just using generic variables for the various values.

Twilite_Kid_82

hey that is the error I get with the pages,
here are 2 txt files with the code.. one for each page
i'll check out your debug code in a few.. If you need anything else let me know

thanks so much

ClarkF1

In the links file you are referencing a connection to the database called $dbh

$result = mysql_query($sql,$dbh);

but $dbh isn't defined anywhere else in the code

NogDog

If you're not opening up multiple DB connections, you can just leave out the 2nd parameter to mysql_query().

Twilite_Kid_82

thanks so much.. I was able to fix the both pages... I defined the $dbh.. I found out that calls for the login and password.. so both pages are working... 🙂

only other question I have is, the shows page I see has a If Statement.. and if there are no shows on the schedule then the page is blank.. is there anyway I can have it say something like "there are currently no shows" instead of it just being a blank page?

ClarkF1

You use another if clause like


$result = mysql_query($query);

if (mysql_num_rows($result) > 0)
{
//code for showing the shows
}
else
{
echo "There are currently no shows";
}

You'll need to do this for both queries on that page.

Twilite_Kid_82

thanks.. fixed up the code and now both issues are resolved... very much appreciated on this end.. thanks so much 🙂