Forum Moderators: coopster
The variable that gets passed is like this :
<select name="quantity">
<option value="55.00">1 ticket</option>
<option value="110.00">2 tickets</option>
<option value="165.00">3 tickets</option>
<option value="220.00">4 tickets</option>
<option value="275.00">5 tickets</option>
</select> and what picks it up - and has worked flawlessly until now, in the next page is :
<p align="center" class="style9">Total Cost £ <?php echo "$quantity"?></p> Any suggestions would be welcome - I've about pulled all my hair out with it.
However...
Those values (along with others) should get passed into a mySQL db by the next page using :
<?
$date = date("Y-m-d G:i:s") ;
$db="databasename";
mysql_query ("INSERT INTO databasename (variable1, variable2, etc) VALUES ('$variable1','$variable2','$etc')");
?> which has also worked flawlessly until now. The two SQL generated fields, "id" and "date" (datetime) go into the DB okay, but the other eleven-odd fields do not, leaving me with aload of blank entries...
Again, i'm baffled because this has worked fine until now, and then just stopped in the last few days when the upgrade came.
You will need to go through all your scripts and replace the shortcut references.
...OR...the quick and dirty way
<?php
extract($_POST); // for forms
extract($_GET); // for query string variables
// Now you can leave the rest of the script intact...