I have a web page form that writes to a database and it has been working
just fine for a couple
weeks now, and all of a sudden it's not working today. The fail to connect
message doesn't even
come up.
<?
if(isset($submit)):
if (!$db = mysql_connect("localhost","root")):
print("<h1>Can't connect to database</h1>\n");
else:
mysql_select_db("todaysnews", $db);
endif;
$date = date("Y-m-d");
$sql = "insert into bulletin
values(null,'$heading','$body','$date','$author_name','$author_email','$bulletin_number','$bulletin_subject',
'$bulletin_from1','$bulletin_date','$bulletin_from2')";
mysql_query($sql);
print("<h2>The Data has been entered!</h2>\n");
print("<strong>You can add another Dealer Bulletin below</strong><br /><hr>\n");
endif;
?>
I have purposely changed the name todaysnews to be incorrect and the page, on submit,
will just
continue to the next web page as if all is well and good.
I can add data from the mysql command line, and also from within webmin, just not from
the web page.
Is it a permissions problem, or access rights problem, or something like that?
The only change made recently was to the web server, apache, it now listens on port
8080 rather than
port 80. This should have no effect on mysql though, right?
Chip Wiegand
Computer Services
www.simradusa.com
[EMAIL PROTECTED]
Simrad, Inc
Lynnwood, WA
425-712-1138
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment Corp.,
1977
(-- Then why do I have nine? Somebody help me!)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
