2 replies to this topic

[porgeet]

Hello there I am unbelivabily new to PHP and MySQL. I'm learning Flash at the moment, but the thing is I want to put a shoutbox on my site. Just for a little more interactivity.So I followed this tutorial
I'm fine with creating all the PHP files, I think.

But here's the part I don't get...

Then goto your mysql console or php my admin and execute this.

CREATE TABLE `shouts` ( `autoID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 85 ) ,
`message` TEXT,
PRIMARY KEY ( `autoID` )
);

I'm using 1ASP host, and from what I can understand, they use ASP. But does that mean I need to find another host that has a "mysql console or php my admin" ?

Where would I write this peice of code ?

[Wolfe]

Yes, you need one that supports PHP/MySQL

They may support it, you just need to ask them to activate it. They may have ASP and PHP servers seperated.

Hosts all do different things, just ask and if not change hosts.

You could always find an ASP shoutbox tutorial or something

[Indigo]

If they support, create a new file and name it whatever.php
Insert this code in it:

<?php
mysql_query("
CREATE TABLE `shouts` ( `autoID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 85 ) ,
`message` TEXT,
PRIMARY KEY ( `autoID` )
);
)"
?>

This will install your table. Just check out php.net for more about the mysql_query()-function, you might want to run an error check with it too. Hope this helps