how to make a table in mysql

[Liberated]

Hi all
Does anyone know how to make atable in mysql
thanks
Bye

[tbonekkt]

Was there really a need to start a new thread when you asked the same exact question here: http://forum.powweb.com/showthread.php?s=&threadid=27289 ?

[RocketJeff]

Here's the manual pages for mySQL's create table (http://www.mysql.com/doc/en/CREATE_TABLE.html) command.

You'll either have to write a script to execute the command or use one of the mySQL admin tools (like mySQL-Front) to execute it.

[Liberated]

Thanks a lot for replying. I think its very complicated for me to do it manually and my sql front doest work here coz of the firewall.

Anyhow i am getting thise messages, do u guys know what it is?

http://www.onlinemuslims.com/chat/chat/setup.php3

bye

[B&T]

Originally posted by Liberated
I think its very complicated for me to do it manually and my sql front doest work here coz of the firewall.

Use phpmyadmin. It is PHP script driven and works from your website so you can use it anywhere. I love it.

And mysqlfront is out of development (or "stabilized" as we call it in the IT world), so you will have to move on at some point anyway.

[Liberated]

Thanks for replying b and t but where can i get copy of phpadmin

Thanks
Bye

[B&T]

http://www.phpmyadmin.net/

Download the last stable version, not the release candidate.

[Liberated]

Thanks a lot B&T, i m finally done with the phpmyadmin software. Now the question is how to make tables in it?
Thanks
Bye

[B&T]

In the left pane you see your DB name. Click on that.

Then in the right pane you will see 5 tabs. The first one is structure. In that pane you will see create table. You enter the table name and the number of fields you want to start with.

[Liberated]

Thanks again B&T but i think something is wrong, i am trying to install a chatroom that requires making a table if doing it manually. I m getting this error

Database error: Invalid SQL: DELETE FROM c_messages WHERE m_time < 1065842836
MySQL error: 1054 (Unknown column 'm_time' in 'where clause')
Session halted.

If doing the setup automatically i am getting this error
http://www.onlinemuslims.com/chat/chat/setup.php3

I reallydont know what to do, i have spent more than 6 hours on it now and its not working.

[tbonekkt]

Originally posted by Liberated
If doing the setup automatically i am getting this error
http://www.onlinemuslims.com/chat/chat/setup.php3
Did you follow the instructions as stated on that error page? Did you CHMOD the files stated in the chat's readme/install instructions?

[Liberated]

Thanks for replying tbonekkt but i did give full permission to it and still its giving me the same error, i was wondering if powweb had disabled it.

http://www.onlinemuslims.com/chat/chat/setup.php3

thanks

[HalfaBee]

You can only set the perms. to 755 max.
644 should be ok for most scripts.

HalfaBee

[Liberated]

You can only set the perms. to 755 max.
644 should be ok for most scripts.

HalfaBee

Yea but its not working on any of the values