Greenguy's Board


Go Back   Greenguy's Board > Programming & Scripting
Register FAQ Calendar Today's Posts

 
 
Thread Tools Search this Thread Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 2007-10-19, 10:27 PM   #2
HowlingWulf
Me fail English? That's unpossible!
 
HowlingWulf's Avatar
 
Join Date: Dec 2003
Location: FL
Posts: 1,381
Send a message via ICQ to HowlingWulf
It shouldn't be too hard, especially if you have the script code which should have the db table names and cats etc.

You can create a table right from the mysql> prompt or write a simple script for it. Do a web search for basic mysql commands that's how I learned to do it.

Example php code:

if ($db= mysql_connect($YOURHOST, $MYSQLUSER, $MYSQLPWD)){
mysql_select_db($DATABASENAME, $db);
}
else echo 'database connection failure!';
$sql="CREATE TABLE items(
id int(11) DEFAULT '0' NOT NULL auto_increment,
name varchar(255) NOT NULL,
ip varchar(15) NOT NULL default '',
cat int(11) DEFAULT '0' NOT NULL,
pwd varchar(24) NOT NULL,
approved tinyint(4) NOT NULL default '0',
date int(11) NOT NULL default '0',
PRIMARY KEY (id))";

if (mysql_query($sql, $db)) echo "'items' table successfully installed<br>";
else $err.= "<b>items table: </b>".mysql_error()."<br>";
__________________
WordPress Porn directory theme => Maddos
Create a Porn Tube => Video Pornster
HowlingWulf is offline   Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:29 PM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc