Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: BCA on July 22, 2002, 04:13:43 PM

Title: mysql_connect - PHP and MYSQL !
Post by: BCA on July 22, 2002, 04:13:43 PM

Hi there !

Sme server 5.12 installed and IMP 3.0 with requirded modules etc.

I'm trying to get Eguest book to work on my server... and to work on a homepage !!

I can sign the guestbook with no probs...write etc. - But I can not VIEW it..??

The problem is in my showguest book php file...:


$link = mysql_connect ('localhost', '$sqlname', '$sqlpw') or die ("Could not connect");   # connect mySQL
mysql_select_db('$sqldb');         # select database

The variables are okay..I've replaced the variable with specific entries as well..did not help... - I simply can't connect to  mysql via HTTP...!??!

Do I have to do something before I can connect to mysql via http..?? any settings on the SME server...?!?!

Thank you in advance

/B

Title: Re: mysql_connect - PHP and MYSQL !
Post by: Rok Debeljak on July 22, 2002, 05:24:40 PM

change the second line.
mysql_select_db('dbname') or die ( "Could not select db." );

If you get "Could not select db." then you have to create it. (use phpMyAdmin or sth)

Title: Re: mysql_connect - PHP and MYSQL !
Post by: BCA on July 22, 2002, 08:13:53 PM

Hi Rok

I did...but no help...still says could not connect....so it is connection to mysql that doesnt work

I started with creating a database in mysql by typing create database syntax and afterwards creating a table...and I can se my database in mysql..so it should be there.... and I could also sign my guestbook..

Any other suggestions..??

thanks