[spiroth10]

please help me! I have a script that works,but I get an error when creating the database tables.it gives me "error when creating table". the script is below names have been changed for security.please tell me why I get this error.

--------------
the script
--------------

<?php
// PHP/MYSQL page.
//MySQL Variables.
require "function.php";
MySQL_connect("localhost","fake","fake","fake_db") ;
//Variables of Form
$id = $_POST['id'];
$name = $_POST['fname'];
$description = $_POST['description'];
$minpow = $_POST['minpow'];
$order = $_POST['order'];

//Connecting to MYSQL
MySQL_connect("localhost","fake","fake");

$sql=mysql_query("INSERT INTO forums ($id,$fname,$description,$minpow,$minpow,$minpow,0 ,0, , ,$order)");
$result = mysql_query($sql);

if ($result) {
echo("Table created successfully");
} else {
echo("error when creating table");
}

?>

[BdSBB]

$sql=mysql_query("INSERT INTO forums ($id,$fname,$description,$minpow,$minpow,$minpow,0
,0, , ,$order)"); // This is your problem right here
$result = mysql_query($sql);

Your $sql string has mysql_query() already outputting.

[spiroth10]

uhh what do I change it to?

[playtothebeat]

i think you need to get rid of $result

your $sql is ALREADY runnig mysql_query


if you want to keep $sql and $result, then do this:

$result="INSERT into forums (all your stuff here)";
$sql=mysql_query($result)

by the way, when you insert into table, raen't you supposed to do

insert into forum VALUES('first','second') etc? you're supposed to have the VALUES() arent you?

[HasansWeb]

playtothebeat, there are two ways. One in which you can define which row and then use VALUE to add to each (in order). In the other, you don't specify columns but you must specify a value for every single one (use NULL to skip).

But yeah, according to the manual and other references I've read, you use VALUE. That's a part of your problem.

$query = "INSERT INTO forums VALUES($id,$fname,$description,$minpow,$minpow,$mi npow,0 ,0, , ,$order)";
$result = mysql_query($query);

That's how I always do it. It should work fine...