Messages

It seems to have cleared up now.

Having problems connecting to my database on mysql5.freepgs.com

It's been working fine for the last few weeks now it's suddenly gone down. Any news on the situation? Or where do I go to find general downtime announcements?

Well don't I feel silly.

You'd think I would've been able to suss that one myself. I just relooked through the code and this thread, and I remember saying that 'homepage' was the name of the database. Whoops.

I replaced this with 'member', (the name of the table), and everything works. I should slap myself about now. It's been a long time since I programmed anything.

OK. How do I fix that?

Using the code:

Code Select Expand

<?php

include 'config.php';
include 'opendb.php';

@mysql_select_db($dbname) or die("Couldn't connect to DB");

$query="SELECT * FROM homepage";
$result= (mysql_query($query));
$num=mysql_numrows($result);

$i=0;
while ($i < $num) {
$var=mysql_result($result,$i,"mname");

if ($var=="")
{ echo "Result is blank"; }
else
{ echo $var; }

}

mysql_close($conn);

?>

I get the following error message:

"Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in \\nas27ent\domains\e\egclan.co.uk\user\htdocs\viewdata.php on line 10"

Thanks guys, I'll try those now...

I am having trouble accessing information from a database which I created. I am learning how to interact with a MySQL database using PHP. I created the database using PHP code, and then checked here to see if the database had been added, which it had. Then I added a few entries to a table, which went in no problem.

Now I am trying to access the information, but am getting no results. I am using the same code on each page to open the database and config, so this isn't the problem. I am using the following code to try and troubleshoot the problem:

Code Select Expand

@mysql_select_db($dbname) or die("Couldn't connect to DB");

$query="SELECT * FROM homepage";
$result=mysql_query($query);

if ($result=="")
{ echo "Result is blank"; }
else
{ echo $result; }

'homepage' is the name of my database. The result keeps coming out "Result is blank". I've tried replacing the '*' with the fieldnames, but still I get the same result. Can anyone tell me where I'm going wrong?