Hello,
I'm new to mysql and php but installed it in my linux
mandrake 8.2 box php is working hence the fact that if i call
through my webbrowser a script it gives the good output.
did a urpmi mod_php MySql php_mysql
for my website i have a script for a guestbook the deliverd
install won't create the database so i made it manualy (
webmin ) if i want to create the tables 7 in total there is a
illigal output and won't create the table :(
could someone help me started with if i did a proper setup of
the mysql and or how to get this thing going.
thnx in advance,
kind regards,
here is the php installation source.
@mysql_db_query($OPTION[mysqldb],"CREATE TABLE myGUESTBOOKmessages (
MessageID INT UNSIGNED NOT NULL AUTO_INCREMENT,
Comment MEDIUMTEXT,
byName CHAR(50) NOT NULL,
byEmail CHAR(50) NOT NULL,
HowFoundUs CHAR(150) NOT NULL,
HomepageName CHAR(100) NOT NULL,
HomePageUrl CHAR(100) NOT NULL,
date INT UNSIGNED NOT NULL,
PRIMARY KEY(MessageID)
)");
@mysql_db_query($OPTION[mysqldb],"INSERT INTO myGUESTBOOKmessages VALUES
('NULL','','','','','','','')");
$result = @mysql_db_query ($OPTION[mysqldb],"SELECT MessageID FROM
myGUESTBOOKmessages");
if(@mysql_fetch_row($result)) {
?>
<B>DONE</B><BR>
<?php
} else {
?>
<B>ERROR</B><BR>
<?php
}
@mysql_db_query ($OPTION[mysqldb],"DELETE FROM myGUESTBOOKmessages");
?>
Creating database table myGUESTBOOKipcomments:
<?php
@mysql_db_query($OPTION[mysqldb],"CREATE TABLE myGUESTBOOKipcomments (
ipaddress CHAR(20) NOT NULL,
date INT UNSIGNED NOT NULL
)");
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
