[SOLVED] Vanishing Variables

cry of war · December 20, 2007

I was in the middle of testing when i found a weird bug or something in my codeing I know its not a syntax error like it says it is but i dont know what else to call it. I know I have the var set but it says its not when i try to make the table and it happens when i Declare the 45th or 46th variable.

This is the code i am using if you look near the bottom it say """"$table45 = "Casdfasdf";"""" so i know it is set but it gives me this saying it isnt """"45Query: CREATE TABLE (ID INT(30) NOT NULL)

Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ID INT(30) NOT NULL)' at line 1""""

<?php
function sqlQuery( $mysqlQuery, $link, $debug ) {			
        if ( $debug ){
                echo "Query: $mysqlQuery<br />";
			 $result = mysql_query( $mysqlQuery, $link );
        if ( !$result ) {
                if ( $debug )
                        die('Invalid query: ' . mysql_error());
                print "Query failed, please try again.";
                die;
        }
	}
        return;
}
/*Do not I repeat do not change the Var Name just the Value*/
$table  = "IP_logger";
$result = mysql_query("SELECT * FROM `$tableIPlogger`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $tableIPlogger (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table1		 = "Affinity_Name_Des";
$result = mysql_query("SELECT * FROM `$table1`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table1 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table2		 = "Affinity_Bonus";
$result = mysql_query("SELECT * FROM `$table2`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table2 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table3		 = "Affinity_Alignment";
$result = mysql_query("SELECT * FROM `$table3`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table3 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table6		 = "Ingredient";
$result = mysql_query("SELECT * FROM `$table6`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table6 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table7		 = "Primary_Skill";
$result = mysql_query("SELECT * FROM `$table7`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table7 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table8		 = "Secondary_Skill";
$result = mysql_query("SELECT * FROM `$table8`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table8 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table9		 = "Unique_Attribute";
$result = mysql_query("SELECT * FROM `$table9`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table9 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table10	 = "Feat";
$result = mysql_query("SELECT * FROM `$table10`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table10 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table11	 = "Trait";
$result = mysql_query("SELECT * FROM `$table11`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table11 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table5		 = "Book";
$result = mysql_query("SELECT * FROM `$table5`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table5 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table33	 = "Magic";
$result = mysql_query("SELECT * FROM `$table33`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table33 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table34	 = "Money";
$result = mysql_query("SELECT * FROM `$table34`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table34 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table35	 = "Monster";
$result = mysql_query("SELECT * FROM `$table35`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table35 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table12	 = "Arrow";
$result = mysql_query("SELECT * FROM `$table12`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table12 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table13	 = "Axe";
$result = mysql_query("SELECT * FROM `$table13`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table13 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table14	 = "Blunt";
$result = mysql_query("SELECT * FROM `$table14`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table14 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table15	 = "Bow";
$result = mysql_query("SELECT * FROM `$table15`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table15 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table41	 = "Spear";
$result = mysql_query("SELECT * FROM `$table41`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table41 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table42	 = "Staff";
$result = mysql_query("SELECT * FROM `$table42`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table42 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table43	 = "Sword";
$result = mysql_query("SELECT * FROM `$table43`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table43 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table24	 = "Gem";
$result = mysql_query("SELECT * FROM `$table24`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table24 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table27	 = "Grip";
$result = mysql_query("SELECT * FROM `$table27`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table27 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table22	 = "Boot";
$result = mysql_query("SELECT * FROM `$table22`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table22 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table23	 = "Wrist";
$result = mysql_query("SELECT * FROM `$table23`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table23 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table16	 = "Cape";
$result = mysql_query("SELECT * FROM `$table16`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table16 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table17	 = "Chest";
$result = mysql_query("SELECT * FROM `$table17`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table17 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table25	 = "Glove";
$result = mysql_query("SELECT * FROM `$table25`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table25 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table31	 = "Helmet";
$result = mysql_query("SELECT * FROM `$table31`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table31 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table32	 = "Pant";
$result = mysql_query("SELECT * FROM `$table32`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table32 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table36	 = "Necklace";
$result = mysql_query("SELECT * FROM `$table36`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table36 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table40	 = "Sholder";
$result = mysql_query("SELECT * FROM `$table40`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table40 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table39	 = "Ring";
$result = mysql_query("SELECT * FROM `$table39`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table39 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table21	 = "Eye_Color";
$result = mysql_query("SELECT * FROM `$table21`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table21 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table26	 = "God";
$result = mysql_query("SELECT * FROM `$table26`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table26 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table28	 = "Hair_Color";
$result = mysql_query("SELECT * FROM `$table28`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table28 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table29	 = "Hair_Length";
$result = mysql_query("SELECT * FROM `$table29`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table29 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table30	 = "Hair_Style";
$result = mysql_query("SELECT * FROM `$table30`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table30 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table37	 = "Path";
$result = mysql_query("SELECT * FROM `$table37`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table37 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table38	 = "Race";
$result = mysql_query("SELECT * FROM `$table38`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table38 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table4		 = "Body_Type";
$result = mysql_query("SELECT * FROM `$table4`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table4 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table18	 = "City";
$result = mysql_query("SELECT * FROM `$table18`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table18 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table19	 = "Country";
$result = mysql_query("SELECT * FROM `$table19`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table19 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table20	 = "Continent";
$result = mysql_query("SELECT * FROM `$table20`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table20 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table44	 = "Realm";
$result = mysql_query("SELECT * FROM `$table44`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table44 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table45	 = "Casdfasdf";
$result = mysql_query("SELECT * FROM `$table45`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table45 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table46	 = "Weapon";
$result = mysql_query("SELECT * FROM `$table46`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table46 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table47	 = "Arrow";
$result = mysql_query("SELECT * FROM `$table47`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table47 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table48	 = "Magic2";
$result = mysql_query("SELECT * FROM `$table48`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table48 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
$table49	 = "Monster2";
$result = mysql_query("SELECT * FROM `$table49`");
if (!is_resource($result)){sqlQuery("CREATE TABLE $table49 (ID INT(30) NOT NULL) ", $link, $debug);echo $i; $i++;} 
/**50**/
?>

revraz · December 20, 2007

Put a single quote around your variables

CREATE TABLE '$table45' (ID INT(30) NOT NULL)

cry of war · December 20, 2007

this is the out put of what the about does its like $table45 just doesnt get set for some reason

Query: CREATE TABLE IP_logger(ID INT(30) NOT NULL) 
1Query: CREATE TABLE Affinity_Name_Des(ID INT(30) NOT NULL) 
2Query: CREATE TABLE Affinity_Bonus(ID INT(30) NOT NULL) 
3Query: CREATE TABLE Affinity_Alignment(ID INT(30) NOT NULL) 
4Query: CREATE TABLE Ingredient(ID INT(30) NOT NULL) 
5Query: CREATE TABLE Primary_Skill(ID INT(30) NOT NULL) 
6Query: CREATE TABLE Secondary_Skill(ID INT(30) NOT NULL) 
7Query: CREATE TABLE Unique_Attribute(ID INT(30) NOT NULL) 
8Query: CREATE TABLE Feat(ID INT(30) NOT NULL) 
9Query: CREATE TABLE Trait(ID INT(30) NOT NULL) 
10Query: CREATE TABLE Book(ID INT(30) NOT NULL) 
11Query: CREATE TABLE Magic(ID INT(30) NOT NULL) 
12Query: CREATE TABLE Money(ID INT(30) NOT NULL) 
13Query: CREATE TABLE Monster(ID INT(30) NOT NULL) 
14Query: CREATE TABLE Arrow(ID INT(30) NOT NULL) 
15Query: CREATE TABLE Axe(ID INT(30) NOT NULL) 
16Query: CREATE TABLE Blunt(ID INT(30) NOT NULL) 
17Query: CREATE TABLE Bow(ID INT(30) NOT NULL) 
18Query: CREATE TABLE Spear(ID INT(30) NOT NULL) 
19Query: CREATE TABLE Staff(ID INT(30) NOT NULL) 
20Query: CREATE TABLE Sword(ID INT(30) NOT NULL) 
21Query: CREATE TABLE Gem(ID INT(30) NOT NULL) 
22Query: CREATE TABLE Grip(ID INT(30) NOT NULL) 
23Query: CREATE TABLE Boot(ID INT(30) NOT NULL) 
24Query: CREATE TABLE Wrist(ID INT(30) NOT NULL) 
25Query: CREATE TABLE Cape(ID INT(30) NOT NULL) 
26Query: CREATE TABLE Chest(ID INT(30) NOT NULL) 
27Query: CREATE TABLE Glove(ID INT(30) NOT NULL) 
28Query: CREATE TABLE Helmet(ID INT(30) NOT NULL) 
29Query: CREATE TABLE Pant(ID INT(30) NOT NULL) 
30Query: CREATE TABLE Necklace(ID INT(30) NOT NULL) 
31Query: CREATE TABLE Sholder(ID INT(30) NOT NULL) 
32Query: CREATE TABLE Ring(ID INT(30) NOT NULL) 
33Query: CREATE TABLE Eye_Color(ID INT(30) NOT NULL) 
34Query: CREATE TABLE God(ID INT(30) NOT NULL) 
35Query: CREATE TABLE Hair_Color( ID INT(20) NOT NULL) 
36Query: CREATE TABLE Hair_Length(ID INT(30) NOT NULL) 
37Query: CREATE TABLE Hair_Style(ID INT(30) NOT NULL) 
38Query: CREATE TABLE Path(ID INT(30) NOT NULL) 
39Query: CREATE TABLE Race(ID INT(30) NOT NULL) 
40Query: CREATE TABLE Body_Type(ID INT(30) NOT NULL) 
41Query: CREATE TABLE City(ID INT(30) NOT NULL) 
42Query: CREATE TABLE Country(ID INT(30) NOT NULL) 
43Query: CREATE TABLE Continent(ID INT(30) NOT NULL) 
44Query: CREATE TABLE Realm(ID INT(30) NOT NULL) 
45Query: CREATE TABLE (ID INT(30) NOT NULL) 
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ID INT(30) NOT NULL)' at line 1

And I changed it so the vars have a quote around them but it didnt change anything

revraz · December 20, 2007

Weird, maybe it is something with a copy/paste.

Try to have a page with just those 3 lines and manually type them instead. Maybe there is a hidden character in there somewhere.

Also, try to set the variable to something different to see if it has a problem with that string.

kenrbnsn · December 20, 2007

Why don't you simplify your coding by putting all the tablenames in an array. Doing this would let you use a loop:

<?php
$tables = array('IP_logger','Affinity_Name_Des','Affinity_Bonus'); // add the rest of your tables to this array
for ($i=0;$i<count($tables);$i++) {
    $result = mysql_query("SELECT * FROM `{$tables[$i]}`");
    if (!is_resource($result)) {
        sqlQuery("CREATE TABLE {$tables[$i]} (ID INT(30) NOT NULL) ", $link, $debug);
        echo $i . "<br>\n";}
}?>

Ken

cry of war · December 20, 2007

ok retyped it and changed some of the last var names but it still does it and Ken i would do that but i need them to stay like this because each of these tables are going to be different and so i can go back later and change it......

cry of war · December 20, 2007

BUMP!

PFMaBiSmAd · December 20, 2007

Because your echo $i and $i++ code is inside of the if(){} statement, you are getting misleading output when a table name already exists. And in the code you posted there are two or three duplicates. I also suspect you have multiple sets of this code executing or it is in an overall loop.

You get the CREATE TABLE (ID INT(30) NOT NULL) query any time the table name variable does not exist due to a typo.

The first set of code for the $table and $tableIPlogger variables don't match and produce the CREATE TABLE (ID INT(30) NOT NULL) query error.

I suspect that you have multiple sets of this code being executed and/or you have some existing tables and some not, and you are getting output up to the point that any typo or variable name mis-match occurs, such as the $table and $tableIPlogger.

I discovered this by having php error reporting set to E_ALL (a notice message due to the $table and $tableIPlogger mismatch immediately followed by the query with no table name.)

I recommend turning on full php error reporting to get php to help you find where exactly in your code the empty table name query is getting generated.

Ninjakreborn · December 20, 2007

Ken got to it before I could. My thoughts exactly you could turn those 50 something lines of programming into more like 5-5 lines of programming.

cry of war · December 21, 2007

I dont know what i did but what ever i did it solved it heres the final page its part of an include from my brain.php file that i dont want to put on here but for some reason the below works now dont know why the above didnt. Thanks for all the hlep guys.

<?php
/*Do not I repeat do not change the Var Name just the Value*/
$i=1;
$debug=1;
$tableIPlogger  = "IP_logger";
$result=mysql_query("SELECT * FROM `$tableIPlogger`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $tableIPlogger(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table1		 = "Affinity_Name_Des";
$result=mysql_query("SELECT * FROM `$table1`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table1(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table2		 = "Affinity_Bonus";
$result=mysql_query("SELECT * FROM `$table2`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table2(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table3		 = "Affinity_Alignment";
$result=mysql_query("SELECT * FROM `$table3`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table3(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table6		 = "Ingredient";
$result=mysql_query("SELECT * FROM `$table6`");
if (!is_resource($result)){
sqlQuery("CREATE TABLE $table6(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;
}

$table7		 = "Primary_Skill";
$result=mysql_query("SELECT * FROM `$table7`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table7(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table8		 = "Secondary_Skill";
$result=mysql_query("SELECT * FROM `$table8`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table8(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table9		 = "Unique_Attribute";
$result=mysql_query("SELECT * FROM `$table9`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table9(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table10	 = "Feat";
$result=mysql_query("SELECT * FROM `$table10`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table10(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table11	 = "Trait";
$result=mysql_query("SELECT * FROM `$table11`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table11(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table5		 = "Book";
$result=mysql_query("SELECT * FROM `$table5`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table5(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table33	 = "Magic";
$result=mysql_query("SELECT * FROM `$table33`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table33(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table34	 = "Money";
$result=mysql_query("SELECT * FROM `$table34`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table34(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table35	 = "Monster";
$result=mysql_query("SELECT * FROM `$table35`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table35(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table12	 = "Arrow";
$result=mysql_query("SELECT * FROM `$table12`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table12(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table13	 = "Axe";
$result=mysql_query("SELECT * FROM `$table13`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table13(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table14	 = "Blunt";
$result=mysql_query("SELECT * FROM `$table14`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table14(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table15	 = "Bow";
$result=mysql_query("SELECT * FROM `$table15`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table15(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table41	 = "Spear";
$result=mysql_query("SELECT * FROM `$table41`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table41(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table42	 = "Staff";
$result=mysql_query("SELECT * FROM `$table42`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table42(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table43	 = "Sword";
$result=mysql_query("SELECT * FROM `$table43`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table43(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table24	 = "Gem";
$result=mysql_query("SELECT * FROM `$table24`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table24(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}


$table27	 = "Grip";
$result=mysql_query("SELECT * FROM `$table27`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table27(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table22	 = "Boot";
$result=mysql_query("SELECT * FROM `$table22`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table22(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table23	 = "Wrist";
$result=mysql_query("SELECT * FROM `$table23`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table23(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table16	 = "Cape";
$result=mysql_query("SELECT * FROM `$table16`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table16(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table17	 = "Chest";
$result=mysql_query("SELECT * FROM `$table17`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table17(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table25	 = "Glove";
$result=mysql_query("SELECT * FROM `$table25`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table25(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table31	 = "Helmet";
$result=mysql_query("SELECT * FROM `$table31`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table31(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table32	 = "Pant";
$result=mysql_query("SELECT * FROM `$table32`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table32(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table36	 = "Necklace";
$result=mysql_query("SELECT * FROM `$table36`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table36(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table40	 = "Sholder";
$result=mysql_query("SELECT * FROM `$table40`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table40(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table39	 = "Ring";
$result=mysql_query("SELECT * FROM `$table39`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table39(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table21	 = "Eye_Color";
$result=mysql_query("SELECT * FROM `$table21`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table21(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table26	 = "God";
$result=mysql_query("SELECT * FROM `$table26`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table26(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table28	 = "Hair_Color";
$result=mysql_query("SELECT * FROM `$table28`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table28(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table29	 = "Hair_Length";
$result=mysql_query("SELECT * FROM `$table29`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table29(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table30	 = "Hair_Style";
$result=mysql_query("SELECT * FROM `$table30`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table30(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table37	 = "Path";
$result=mysql_query("SELECT * FROM `$table37`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table37(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table38	 = "Race";
$result=mysql_query("SELECT * FROM `$table38`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table38(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table4		 = "Body_Type";
$result=mysql_query("SELECT * FROM `$table4`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table4(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table18	 = "City";
$result=mysql_query("SELECT * FROM `$table18`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table18(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table19	 = "Country";
$result=mysql_query("SELECT * FROM `$table19`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table19(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table20	 = "Continent";
$result=mysql_query("SELECT * FROM `$table20`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table20(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$table44	 = "Realm";
$result=mysql_query("SELECT * FROM `$table44`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $table44(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$try1	 = "Casdfasdf";
$result=mysql_query("SELECT * FROM `$try1`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $try1(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$try2	 = "Weapon";
$result=mysql_query("SELECT * FROM `$try2`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $try2(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$try3	 = "Arrow2";
$result=mysql_query("SELECT * FROM `$try3`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $try3(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$try4	 = "Magic2";
$result=mysql_query("SELECT * FROM `$try4`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $try4(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}

$try5	 = "Monster2";
$result=mysql_query("SELECT * FROM `$try5`");
if (!is_resource($result))
{sqlQuery("CREATE TABLE $try5(ID INT(30) NOT NULL)", $link, $debug);echo $i; $i++;}
/**50**/
?>

Sign In

[SOLVED] Vanishing Variables

Recommended Posts

cry of war

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

cry of war

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

kenrbnsn

Link to comment

Share on other sites

cry of war

Link to comment

Share on other sites

cry of war

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

Ninjakreborn

Link to comment

Share on other sites

cry of war

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information