createtables.php to sql file?

duchaine · 02:14 AM

Hi!!

This file does not work

yadayada.com/createtables.php (goes on end of url)

BUT, can the file (a portion shone here) be made into a sql file that I can import?

That would solve my problem,
Thanks, duchaine

Code:

<html>
<head>
<title>Powerline Site - Creat Tables</title>
</head>
<body>
<center>
<HR>

<TABLE BORDER="1" CELLPADDING="0" CELLSPACING="0" WIDTH="85%">
 <tr>
  <td>
<font face="Verdana" size=2 color="navy">
<b>
<center>Creation of Tables for Powerline Site</center><HR>
<?php
  // CONNECTING TO DATABASE
 include "dbconfig.php";

$sql="create table users
(
   ID int unsigned not null auto_increment primary key,
   Name varchar(75),
   Address varchar(175),
   City varchar(75),
   State varchar(75),
   Zip varchar(15),
   Country varchar(75),
   Email varchar(75),
   Username varchar(75),
   Password varchar(75),
   active int unsigned not null,
   ref_by varchar(75),
   IP varchar(25),
   Date datetime,
   status int unsigned not null,
   Total float(8,2),
   Unpaid float(8,2),
   Paid float(8,2),
   RDate datetime
)";
if(mysql_query($sql))
{
 print " Table Created : users <br>";
}
else

there's more code.

Zentharus · 09-26-2011, 01:43 AM

Duchaine
Use
<CODE>
</CODE> but instead of <> use []

duchaine · 09-26-2011, 02:04 AM

Zentharus,

Like so?

Thanks,
duchaine

Zentharus · 09-26-2011, 02:05 AM

Yea And then paste he entire code in the box and remove the part that says it's too long to post etc

duchaine · 09-26-2011, 02:17 AM

...gotta say there is more to it.

I eventually catch on. :/

duchaine