Forums
This topic is locked
Issue connecting to a mysql database. white screen
Posted 29 Apr 2007 19:38:19
1
has voted
29 Apr 2007 19:38:19 Nelson Cardoso posted:
Hi all,I've been connecting to databases for the past 4 years using dreamweaver behaviours. i.e. Create a recordset, add variables to my pages.... upload page and connection document and voila!
This last week someone asked me to create a registration section for a site... as a part of that I created a list page that should show all the records of a table. When I try to test it, I get back a white page with nothing. This is a first for me. This isn't on my usual server... any chance that something could be shut off on the server? I did a phpinfo() and things seem to be running right.
So then I created a connection manually like this:
<?
mysql_pconnect ('server', 'user', 'pw');
mysql_select_db (post_db_ca);
$result = mysql_query ("SELECT * FROM postings"
if ($row = mysql_fetch_array($result)) {
echo mysql_field_name($result, 5);
}
?>
this connection doesn't use an external connection document or error checking like dreamweaver's version... this works!!!!
Does anyone know why the other one doesn't?
Thanks a million!!
Nelson