jsk1gcc

Ignore last post, silly me, spelt them wrong Thanks dragon_sa, i'll try inserting them and let you know how it goes =)

Notice: Undefined variable: endprice1 on line 120 Notice: Undefined variable: endprice2 in p on line 121 It does not like them, I'm unsure what to to?

Where should I declare them, after $endPrice1= ($total1+$seatPrice1); $endPrice2= ($total2+$seatPrice2); ?? A look at the syntax and structure of the query would bea great help too =)

Hi, I could really do with some help putting the prices from two drop down boxes into sessions To start with the user can choose two seats one from each drop down box //DROP DOWN BOX ONE $extract =mysql_query("SELECT * FROM ride WHERE rideID ='1'"); $numrows = mysql_num_rows($extract); //start of form echo '<form method="post" name="f1" action="card.php">'; echo 'Please choose a seat: '; echo"<select name='seat' >"; while( $row = mysql_fetch_assoc($extract)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat'> $seatNumber </option>"; $_SESSION['extract']=$_POST['seat']; } echo '</select><br>'; //DROP DOWN BOX TWO $extract2 =mysql_query("SELECT * FROM ride WHERE rideID ='1'"); $numrows = mysql_num_rows($extract2); //start of form echo '<form method="post" name="f2" action="card.php">'; echo 'Please choose a seat: '; echo"<select name='seat2' >"; while( $row = mysql_fetch_assoc($extract2)) { $rideID = $row ['rideID']; $rideName = $row ['rideName']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat2'> $seatNumber </option>"; $_SESSION['extract2']=$_POST['seat2']; } echo '</select><br>'; at the moment I have this : $query =mysql_query("SELECT price FROM ride WHERE rideID ='1' LIMIT 1"); while ($row=mysql_fetch_array($query)) { echo $row['price']; echo "<br>"; $seatPrice1=($row['price']); $seatPrice2=($row['price']*2); $vat1=17.5; function vat($vat, $row['price']) { return sprintf("%01.2f", ($vat*$row['price]/ 100)); } $vatprice = vat(17.5, 2.50); $total1=($vatprice); $total2=($vatprice*2); $endPrice1= ($total1+$seatPrice1); $endPrice2= ($total2+$seatPrice2); What I need is $endPrice1 and $endPrice2 in $_SESSIONS so i an INSERT them in to the database 3 pages away from this query/VAT fucntion. Can anyone help?

sure check this one out: part1 http://www.youtube.com/watch?v=yuLpSospbBk part2 http://www.youtube.com/watch?v=LF5zTWthpn0&feature=channel hope they help =)

I fixed it by myself, no problems. code is here for anyone else who might have the same problem somewhere down the line update.php <?php require("connect.php"); $extractR = mysql_query("SELECT DISTINCT rideID, rideName FROM ride ORDER BY rideID " ); $numrows = mysql_num_rows($extractR); echo " Change the ride name: <form action='mysql_update.php' method='POST'> <select name='ride_name' >"; while ($row=mysql_fetch_assoc($extractR)) { $rideID = $row ['rideID']; $rideName = $row ['rideName']; #$seatNumber = $row ['seatNumber']; #$time = $row ['time']; #$price = $row ['price'];value='$rideID' echo $row; echo "<option value='$rideID'> $rideName </option>"; } echo "</select> <input type='text' name='tochangeRide'> <input type='submit' name='submit' value='change'> </form>"; ?> mysql_update.php <?php require ('connect.php'); $ride_name=$_POST['ride_name']; $tochangeRide=$_POST['tochangeRide']; if ($ride_name&&$tochangeRide) { $changeR = mysql_query("UPDATE ride SET rideName='$tochangeRide' WHERE rideID='$ride_name'"); } echo "You have updated the ride name to $tochangeRide"; ?>

hey can someone advice me on how to make my update script update multiple rows. here's what i've got so far: update.php <?php require('connect.php'); $update = mysql_query("SELECT DISTINCT rideName FROM ride ORDER BY rideName DESC" ); $numrows = mysql_num_rows($update); echo "<form action='mysql_update.php' method='POST'> <select name='updateRide' >"; while ($row=mysql_fetch_assoc($update)) { #$rideID = $row ['rideID']; $rideName = $row ['rideName']; #$seatNumber = $row ['seatNumber']; #$time = $row ['time']; #$price = $row ['price']; echo "<option value='$id'> $rideName </option>"; } echo "</select> <input type='text' name='tochange'> <input type='submit' name='submit' value='change'> </form>"; ?> and now the handler script: mysql_update.php <?php require ('connect.php'); $updateRide=$_POST['updateRide']; $tochange=$_POST['tochange']; if ($updateRide&&$tochange) { $change = mysql_query("UPDATE ride SET rideName='$tochange' WHERE $id='updateRide'"); } ?> When I try this I get nothing, no changes. In the table there is 3 distinct rideNames each have more than 20 rows. Is there a way using the drop down box and ext field like i Have to update all of the distinct rideNames in the table? Thanks.

Okay to start with, I apologise for the messy code. I have a table called ride with a column called price(it is 2.50). I need to query the table and then add VAT to it. the query I have at the moment is $query =mysql_query("SELECT price FROM ride WHERE rideID ='1' LIMIT 1"); while ($row=mysql_fetch_array($query)) { echo $row['price']; echo "<br>"; } The result of the echo is 2.50 The VAT function is $seatPrice2=($price*2); $seatPrice1=($price*1); $vat1=17.5; function vat($vat, $price) { return sprintf("%01.2f", ($vat*$price/ 100)); } $vatprice1 = vat(17.5, 2.50); $vatprice2 = vat(17.5, 2.50); $total2=($vatprice2*2); $endPrice2= ($total2+$seatPrice2); $total1=($vatprice1*1); $endPrice1= ($total1+$seatPrice1); echo"$endPrice1"; echo "<br>"; echo "$endPrice2"; endPrice1 is the value of one seat including VAT and endPrice2 is the value of 2 seats inc VAT. I have used echo during development, the endPrice1 and 2 could really do with being in a session, as they won't be posted back to the user on the same page and I would like to use them in an email script. [also to note, the user can choose one seat or two seats] I would really appreciate some help in turning what I have into a result that I can place into a session. Thanks =)

I had this problem when I first started out, I would suggest you look at these video tutorials I found. They really helped me, hope they do you too. =) http://www.youtube.com/user/phpacademy?blend=1&ob=4#g/p

Just a quick question I have a form, couple of drop down boxes, input fields etc.. at the end is the submit button. now my question is should my insert into database sqls go before the submit button inside the form? out side the form? after the button inside the form? If by any chance you could give me some advice on the best way to layout my sql that would be great. They are big and go into three tables, at the moment I have them as three seperate queries but I think they must be able to go into one. can someone please help me with the layout and syntax. here is what the queries look like at the moment: if ($IBselect=$_POST ['IBselect']); { //CUSTOMER $enterCust="INSERT INTO customer(username, password, title, firstName, lastName, address, town, country, postCode, phone, email, dateCust) VALUES ('$_POST[username]', '$_POST[password]', '$_POST[title]', '$_POST[firstName]', '$_POST[lastName]', '$_POST[address]', '$_POST[town]', '$_POST[country]', '$_POST[postCode]', '$_POST[phone]', '$_POST[email]', 'DATE: Auto CURDATE()', CURDATE()"; $enterCust_query=mysql_query($enterCust)or die(mysql_error()); //CARD $enterCard="INSERT INTO card(cardNumber, name, expDate, cardID) VALUES ('$_POST[cardNumber]','$_POST[name]', ' $_POST[expDate]', '$_POST[cardID]')"; $enterCard_query=mysql_query($enterCard); //BOOKING $RCenterBook=mysql_query("INSERT INTO booking (custNumber, cardID, rideName, seatNo1, seatNo2, price, price2, dateBook, ID_time_tbl) VALUES ('$custNumber', '$_POST[cardID]', '$rideName', '$_SESSION[iBextract]', '$_SESSION[iBextract2]', '$IBendPrice1', '$IBendPrice2', 'DATE: Auto CURDATE()', CURDATE()', '$_SESSION[iB_slot_Time]'"); $IBenterBooking_query=mysql_query($IBenterBook); if (!mysql_query($enterCard, $enterCust, $IBenterBook)) { die("Error:" .mysql_error()); } echo "1 record added IB"; } Thanks =)

I have two drop down boxes that give me the result $extract and $extract2. The user can not pick the same seat in each drop down box. I am having a problem getting my IF statement to work, well it is working but not as I would like. When the page loads both boxes are null and are therefore the the same and the 'else' statement is shown. Is there a way to say...IF button is NULL on the page load then ignore? //SUBMIT BUTTON echo "<br>"; echo "<br>"; echo "<input type='submit' name='select' value='Select Seats'>"; echo "</form>"; //IF TO SEE IF TWO SEATS ARE SAME if ($_POST['select']="") { echo "please choose seats"; } if ($_SESSION['extract']==$_SESSION['extract2']) { echo "You have choosen the same seat twice, please choose two different seats. <a href='confirm.php'> Go Back</a>"; } Thanks. =)

of course, so sorry. of course they are used. *dunce moment* I had them at values at one point when they where single drop down boxes but they got changed along the way when I need multiple selections. I used forms because I was using a tutorial as so how to create the drop down boxes. I didn't know I could live without them =) I will try that. the aim of the system is to be able to book two or more seats next to each other. I've tried many ways and I understand that using two boxes is messy but I don't have the knowledge to be able to try another way. anyway after you've chosen the two seats [seat] and [seat2] they get posted to the next page for confirmation, all is well there. what I wanted help on was how to get the price of both seats plus VAT in a session to be posted too. I've tried different variations and I can't seem to get anywhere. I hope this helps a little more, sorry if I'm being slow. I've been surviving on more coffee than sleep and I am shattered and finding it hard to see blatant errors. 0.o

That's weird, they work, I can call the seat variable and it comes, no problem. I didn't know about the form values, I will change them, But will it make any difference? I am not calling them in any other page. =)

This is the entire code =) <?php //connect include require("connect.php"); session_start(); #error_reporting(E_ERROR); //turn off error for session variables echo "your choosen ride is: " .$_SESSION ['result']; //extract data $extract =mysql_query("SELECT * FROM ride WHERE rideID ='3'"); $numrows = mysql_num_rows($extract); //start of form echo '<form method="post" name="f1" action="confirm.php">'; echo 'Please choose a seat: '; echo"<select multiple name='seat' size='2'>"; while( $row = mysql_fetch_assoc($extract)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat'> $seatNumber </option>"; $_SESSION['extract']=$_POST['seat']; # $_SESSION['result']=$_POST['ABC']; //wasc alling blank variable } echo '</select><br>'; ?> <?php require('connect.php'); $extract2 =mysql_query("SELECT * FROM ride WHERE rideID ='3'"); $numrows = mysql_num_rows($extract2); //start of form echo '<form method="post" name="f2" action="confirm.php">'; echo 'Please choose a seat: ';echo"<select multiple name='seat2' size='2'>"; while( $row = mysql_fetch_assoc($extract2)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat2'> $seatNumber </option>"; $_SESSION['extract2']=$_POST['seat2']; # $_SESSION['result']=$_POST['ABC']; //was calling blank variable } echo '</select><br>'; ?> <?php #$end =$_POST['endPrice']; $_SESSION['priceWvat']=$_POST['endPrice']; echo "<input type='submit' value='Submit'>"; echo "</form>"; //show time and price echo "The price of the ride is: £$price<br>The duration if of the ride is: $time minutes<br>" ; #$totalPrice=($_SESSION['extract']+$_SESSION['extract2']); #echo $totalPrice; //VAT function $seatPrice=($price*2); $vat=17.5; $priceXvat=0.300; function vat($vat, $priceXvat) { return sprintf("%01.2f", ($vat*$priceXvat/ 100)); } $vatprice = vat(17.5, 3.00); $total=($vatprice*2); $endPrice= ($total+$seatPrice); //Ftotal echo "<br>"; echo "The price including VAT is: £ ";echo $endPrice ; ?> Again messy code, what I am trying to do is add the VAT of two seats costing 3.00, The price is $price from the `ride` table. hope this is a little clearer =)

endPrice but when I use this, it comes up with Notice: Undefined index: