What is wrong with it please?

Shygirl

<?----soooooo lost----------->

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ('".$POST[1]."', '".$POST[2]."',".$POST[3]."', ".$POST[4]."', ".$POST[5]."', ".$POST[6]."', ".$POST[7]."', ".$POST[8]."',)";

$result = mysql_query($sql)or die

<?---form starts here--->

<form action="<?php echo $PHP_SELF; ?>" method="post">

<?--------pray for a miracle--->

<input style="font-size:8pt;" type=submit name=cons value=Construct onClick="Go(1,this.form);">
/
<input style="font-size:8pt;" type=button name=dest value=Destroy onClick="Go(0,this.form);"> buildings to highlighted sector

<table border=1 bordercolor=#003399 cellspacing=0 width=95%>
<tr align=center bgcolor=#003399>
<td><font size=1>Name</td>
<td><font size=1>Hit<br>Point</td>
<td><font size=1>Armor</td>
<td><font size=1>Price<td wrap=><font size=1>Amount</td>
<td><font size=1>Description</td>
<td><font size=1>Dependency</td>
</tr>

<tr align=center>
<td><font size=1>Command Center</td>
<td><font size=1>2200</td>
<td><font size=1>25</td>
<td><font size=1>10000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(2,1);">

<img border=0 src=down.gif onClick="UpDown(2,0);">
</td>
<td><font size=1>Defensive structures and aircraft controlled by computer can attack enemy</td>
<td><font size=1> </td>

</tr>

<tr align=center>
<td><font size=1>Government Bldg.</td>
<td><font size=1>1500</td>
<td><font size=1>20</td>
<td><font size=1>9000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(3,1);">

	<img border=0 src=down.gif onClick="UpDown(3,0);">
</td>
<td><font size=1>Collect tax from residence, 100 credits per residence</td>
<td><font size=1> </td>

</tr>

<tr align=center>
<td><font size=1>Radar Station</td>
<td><font size=1>500</td>
<td><font size=1>25</td>
<td><font size=1>3000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(4,1);">
<input type=text name=3 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(4,0);">
</td>
<td><font size=1>Your wing radar while in base</td>
<td><font size=1>Power Plant/Nuclear Power Plant</td>
</tr>

<tr align=center>
<td><font size=1>Runway</td>
<td><font size=1>350</td>
<td><font size=1>5</td>
<td><font size=1>1000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(5,1);">
<input type=text name=4 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(5,0);">
</td>
<td><font size=1>Needed for your aircraft to take off</td>
<td><font size=1></td>
</tr>

<tr align=center>
<td><font size=1>Factory</td>
<td><font size=1>800</td>
<td><font size=1>10</td>
<td><font size=1>1000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(6,1);">
<input type=text name=5 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(6,0);">
</td>
<td><font size=1>Needed to buy defensive structures;<br>Produce aircraft controlled by computer automatically</td>
<td><font size=1>Residence, Highway, Power Plant/Nuclear Power Plant</td>
</tr>

<tr align=center>
<td><font size=1>Nuclear Plant</td>
<td><font size=1>500</td>
<td><font size=1>15</td>
<td><font size=1>5000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(7,1);">
<input type=text name=6 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(7,0);">
</td>
<td><font size=1>Supplies power for factory and radar station</td>
<td><font size=1>Residence, Highway</td>
</tr>

<tr align=center>
<td><font size=1>Residence</td>
<td><font size=1>500</td>
<td><font size=1>4</td>
<td><font size=1>1500</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(8,1);">
<input type=text name=7 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(8,0);">
</td>
<td><font size=1>Supplies workers for factory, oil refinery and (nuclear) power plant</td>
<td><font size=1></td>
</tr>

<tr align=center>
<td><font size=1>Power Plant</td>
<td><font size=1>700</td>
<td><font size=1>12</td>
<td><font size=1>1000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(9,1);">
<input type=text name=8 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(9,0);">
</td>
<td><font size=1>Supplies power for factory and radar station</td>
<td><font size=1>Residence, Oil Refinery, Highway</td>
</tr>

<tr align=center>
<td><font size=1>Oil Refinery</td>
<td><font size=1>700</td>
<td><font size=1>8</td>
<td><font size=1>1000</td>
<td nowrap>
<img border=0 src=up.gif onClick="UpDown(10,1);">
<input type=text name=9 size=3 maxlength=3 value=0></imput>
<img border=0 src=down.gif onClick="UpDown(10,0);">
</td>
<td><font size=1>Produces fuel for power plant, enables cheaper fuel</td>
<td><font size=1>Residence, Highway</td>
</tr>

</p>

</body></html>

Please, can someone help? I can't get it to work. All I ever get is that annoying grey screen.... It makes me want to scream!

rokchik

Shygirl;10893547 wrote:
<?----soooooo lost----------->

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ('".$POST[1]."', '".$POST[2]."',".$POST[3]."', ".$POST[4]."', ".$POST[5]."', ".$POST[6]."', ".$POST[7]."', ".$POST[8]."',)";

$result = mysql_query($sql)or die

<?---form starts here--->

<form action="<?php echo $PHP_SELF; ?>" method="post">

<?--------pray for a miracle--->

<input style="font-size:8pt;" type=submit name=cons value=Construct onClick="Go(1,this.form);">
/
<input style="font-size:8pt;" type=button name=dest value=Destroy onClick="Go(0,this.form);"> buildings to highlighted sector

Please, can someone help? I can't get it to work. All I ever get is that annoying grey screen.... It makes me want to scream!

First of all, try to make your post as short as possible and use the 'php' button from the toolbar that looks like a Word toolbar. That means you cut out all of the unnecessary code.

Second, look at this:

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ('".$POST[1]."', '".$POST[2]."',".$POST[3]."', ".$POST[4]."', ".$POST[5]."', ".$POST[6]."', ".$POST[7]."', ".$POST[8]."',)";

That should be:

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ($_POST[1], $_POST[2], $_POST[4], ... $_POST[8]);";

No dots in your values, commas only when you have something else to put in afterwards and always finish your SQL statement with a semicolon (😉 and then quotemarks and your PHP statement with another semicolon.

Third, how will you know if your script dies because of this statement?

$result = mysql_query($sql)or die

That should be:

$result = mysql_query($sql)or die ("Error. Could not do SQL query!");

Fourth, then you jump right into html and javascript without exiting PHP and confuse the issue with <?.

<?---form starts here--->

<form action="<?php echo $PHP_SELF; ?>" method="post">

<?--------pray for a miracle--->

<input style="font-size:8pt;" type=submit name=cons value=Construct onClick="Go(1,this.form);">
/

This should be:


?>
<script type="text/javascript">....</script>
<!---form starts here--->

<form action="<?php echo $PHP_SELF; ?>" method="post">



<!--------pray for a miracle--->



<input style="font-size:8pt;" type=submit name=cons value=Construct onClick="Go(1,this.form);">
/

djjjozsi

$PHP_SELF ?

is that has a value?

you might use: $_SERVER["PHP_SELF"]

try to print those values.

katsurace

first of all ur query seems too messy. try not to use such query, make it readable,
then if anything goes wrong with sql statement then print that statement n run query............... for now u have done numerous mistakes in single quote( ' ) in inserting posted values

katsurace

try this

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ('".$POST[1]."', '".$POST[2]."','".$POST[3]."', '".$POST[4]."', '".$POST[5]."', '".$POST[6]."', '".$POST[7]."', '".$POST[8]."')";

Shygirl


<?php
ini_set('display_errors','On');

$username="151296";
$password="puppypuppy";
$database="151296";
mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$last = $_COOKIE['ID_my_site']; 

$query = "SELECT * FROM wings, users where wings.Numero = users.Wing AND users.username = '" . $last ."'";
$query2 = "SELECT Wing From users where users.Wing = 0";
$result = mysql_query($query);
$result2 = mysql_query($query2);


$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1) 
            VALUES ($_POST[amout1], $_POST[amount2], $_POST[amount3], $_POST[amount4], $_POST[amount5], $_POST[amount6], $_POST[amount7], $_POST[amount8], $_POST[amount9]);";  
}
$result = mysql_query($sql)or die ("Error. Could not do SQL query!");
?>

I have the form on the other page. Then when you press the button it takes me to this. "construct.php" and i get a grey screen, and the info isnt submitted.

Any ideas as to why please?

katsurace

as far i have found there is extra semicolon in ur last sql query and better use die(mysql_error())

which explains you about error more clearly