Posted by Ian Davies on 10/26/05 02:43

Thanks everyone for your feedback. Ive used hidden fields and will read up
on sessions. Still need some good links to info about drop down lists though
Ian

"Ian Davies" <iandan.dav@virgin.net> wrote in message
news:fM57f.11467$6i4.9746@newsfe7-gui.ntli.net...
> Hello
> I am trying to run a few INSERT queries only if the user clicks 'continue'
> in a <a href> The queries takes variables created from SELECT queries. I
> have tried to acheive this by putting The INSERT queries into a function
at
> the top of my php file and having the SELECT queries below it. I have a
> message that pops up that includes a link to the function but I cant get
> this to work and am not sure of the best approach. Can anyone help?
> My striped down code is below. Im not even sure if you can just use a
> function to contain code that doesnt return a value. Mine just runs some
> INSERT INTO queries
>
> *******************************************************************
> <?php
> function PurchaseQuestions(){
>
> various INSERT INTO queries here
>
> <h1>Confirmation</h1><br>
> <p><a href="logout.php"> Logout</a> or return to <a href="Questions.php">
> Questions Database</a></p><br><br><br>
> Congratulations <b><?php echo $_SESSION[username] ?></b>, your order has
> been completed.</p>
>
> <?php
> }
> ?>
>
>
> <?php
> $OrderDate = date('d/m/Y');
>
> Three SELECT queries here which provides variables for the
> PurchaseQuestions() function
> ?>
> <h1>Order Status</h1>
> <p>You have requested <?php echo $QuestSel; ?> questions at a total cost
> of <strong>�<?php echo $QuestSel*.8; ?></strong>
> If you wish to proceed with the transaction click <a href=<?php echo
> PurchaseQuestions() ?>> Continue</a>.<br>
> <?php
>
> }
>
> ?>
> <?php
> mysql_close($conn);
> ?>
>
>

[Back to original message]