PHP / MySQL Problem

murraywl

I am experiencing problems with I guess linking to the database and displaying data. I'm running Apache 1.3.27, PHP 4.3.1 and MySQL 3.23.49 on a Windows 2000 machine. I can execute php statements like display dates and other things, i.e.

<?php echo "Ordered Processed"; ?>

but when it comes to displaying information from database, it renders nothing; The page is rendered BLANK. It's like the code disappears. Even the code above disappears from view and it worked a minute ago. i.e.

@ db = mysql_pconnect("localhost", "root", "password");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
}

What have I done wrong or what am I doing wrong? By the way, IIS is still running on my machine along with Apache. Apache is running on Port 8080.

Help!!!

Warren

morgan

unless I'm missing something, you need to put "$" in front of your DB variable to turn it in to a variable. The "@" turns off php errors, correct? At this stage, you'll want to see any errors that come up, so I'd exclude that.

what you have:

@ db = mysql_pconnect("localhost", "root", "password");

what I'm suggesting:

$db = mysql_pconnect("localhost", "root", "password");

-Morgan

jimson

there are 2 mistake here... from my eyes...
first,
db is variable because you are assigning something it so it must start with $ otherwise it is a define constant...

second,
about the @, this is to escape the error for a process.
you put it before the @$db . I don't think actually perform...
put the @ in front of the mysql_pconnect("localhost", "root", "password");

so you will got
$db = @mysql_pconnect("localhost", "root", "password");

third,
why use persistent connection ? mysql_pconnect ?
you can simply use mysql_connect().