Please please please help?

Shygirl

 <?php
$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);







<?----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 ("Error. Could not do SQL query!");








<?---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);">

<input type=text name=1 size=3 maxlength=3 value=0></imput>

<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);">


<input type=text name=2 size=3 maxlength=3 value=0></imput>




	<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>
</form>

It keeps giveing me a grey screen!! Im going to scream......... pls help me 🙁

bretticus

Don't scream! Read your last post where I explained how to turn on error messages (or at least gave you a link to a how-to.)

Also, might have something to do with lines liek these:

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

I believe you meant

As you know <? is a php delimiter which is fine...if you have valid php code after it. However, there may be more than that, so refer to suggestion one also.

Good luck!

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);







<!----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 ("Error. Could not do SQL query!");








<!---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);">

<input type=text name=1 size=3 maxlength=3 value=0></imput>

<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);">


<input type=text name=2 size=3 maxlength=3 value=0></imput>




	<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>
</form>
?>

Please notice that the "ERROR ON" thing is in the top of the PHP code.

Still grey screeeen 🙁

NogDog

<!----soooooo lost----------->

is causing a parse error as it is not valid PHP (use PHP //...comment... or /...comment.../ comments, instead), which kills the script execution before your ini_set() ever gets executed to turn on error display. In other words, to see parse errors you need to have the display_errors option turned on in your php.ini config file or in a local .htaccess file (if on Apache and if allowed).

Alternatively, most of the better PHP editors/IDE's have automatic PHP parsing built in to help you find parse errors without even having to actually run the code on your web server.

djjjozsi

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

$username="151296";
$password="puppypuppy";
$database="151296";

$connect=mysql_connect(localhost,$username,$password) or die("error!! ".mysql_error());
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);


/*<!----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]);";

print "Test this sql query in PHPMYADMIN: ".$sql." <br>"; //
if(isset($_POST))
{
	$result = mysql_query($sql);
	if($result)
		print "Succesfully inserted into database";
		else
		die ("Insert failed: ".$sql." , mysql_error:".mysql_error());
}
/*<!---form starts here--->*/
?>

<form action="?" method="post">

<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);">

<input type=text name=1 size=3 maxlength=3 value=0></imput>

<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);">


<input type=text name=2 size=3 maxlength=3 value=0></imput>

<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>
</form>
</body></html>

Shygirl

Notice: Use of undefined constant localhost - assumed 'localhost' in /home/vhosts/planez.orgfree.com/inventory.php on line 8

Notice: Undefined index: 1 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 2 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 3 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 4 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 5 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 6 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 7 in /home/vhosts/planez.orgfree.com/inventory.php on line 24

Notice: Undefined index: 8 in /home/vhosts/planez.orgfree.com/inventory.php on line 24
Test this sql query in PHPMYADMIN: INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1) VALUES (, , , , , , , );
Error. Could not do SQL query!

This is with your code.

I think the problem is me though.

What i'm trying to do, is imput the data from the form into the database.

Basicly the user filles in the text fields with the numbers he wants. So, he presses 5 in the Command center text field, and 5 in Runways. Then he presses the "Construct" button.

After he pressed Construct, it would imput 5 into CC1, 0 into GB1, 0 into Radar1, and so on.

Any advice please?

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

This is the Construct button. Is there anyway I can hook the PHP up to this, so that it inserts the values from the text fields When the user presses this button?

djjjozsi

why don't you learn a basic form into database if you start this?

Shygirl

Is english your 1st language?

djjjozsi

No, that is Hungary.

Shygirl;10893677 wrote:
Is english your 1st language?

Shygirl

What i'm trying to do, is imput the data from the form into the database.

Basicly the user filles in the text fields with the numbers he wants. So, he presses 5 in the Command center text field, and 5 in Runways. Then he presses the "Construct" button.

After he pressed Construct, it would imput 5 into CC1, 0 into GB1, 0 into Radar1, and so on.

Any advice please?

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

This is the Construct button. Is there anyway I can hook the PHP up to this, so that it inserts the values from the text fields When the user presses this button?