PHP - Not Putting In All Info?

Hello there,

I've been searching for the answer to this for a while but haven't got anywhere. I'm fairly new at the whole PHP scripting so I maynot be phrasing it correctly Basically I just want a couple of things to happen:

1) A user registers and is shown a page confirming successful registration. This page confirms there details, tells them an email is on the way and they may now login. The problem lies here, I have made it so it inputs the username into the url. For example we end up with something like www.xxxxx.com/login.php?user=Jacketh. I would like it so that username value is input into the Username: input type on the login page. I'm guessing there must be some coding as that link doesn't actually put anything into it, the input does have id and name both as user.

2) Pretty much the same for the email confirmation, the link does the same and creates a query string that inputs the info into the specific fields.

Is there a way to then click the submit button automatically or something? Hence if I input there username and password through the string and enforce automatic login? This would be nice if possible!

Thanks,
Jacketh

ok, this is a much shorter version, but

i have:
Code: [Select]
$val = "1";

then i have a function
Code: [Select]

function  include_function_name{

echo'
<ul><li>
<a href="index.php?pageID="{$val}"">page name</a>
<li/><ul/>';
}


i have tried all sorts of variations but i can get it to make pageID=1



plaease help
thanks
ricky

Guys/Gals;

This below block outputs a very simple progress bar, i'm curious if anyone would see a solution to perform a task when this bar reaches the end as you can see it's set to countinue until width<400 when that 400 is true I and in essence the process is done (even though nothing in reality) i want to display countinue but only when it's done

echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' bgcolor='#666666'><tr><td width='506' height='52' valign='top'><script type='text/javascript'>function progress(){if(document.images['bar'].width<400){document.images['bar'].width+=5;document.images['bar'].height=5; 
   }else{clearInterval(ID);}}var ID;window.onload=function(){ID=setInterval('progress();',$cpuspeed);}</script><img src='images/white.gif' name='bar'/><br /><font color='#ffffff'>Cracking....</font></td></tr></table>";

any dideas

Hi!

Im in need of some help.

I had a form built for me and im attempting to make it so some details are required eg name, cc number etc. But i cannot figure out how to do it. I only have dreamweaver cs4 and i attempted to do it through that but when i uploaded the form it didnt work.

The form is located he
https://eatatmenzies.com.au/catering_menu.php

and my code it as follows

[[code]<?php

$teaandcoffee=$_POST['teaandcoffee'];



$teaandcoffeeallday=$_POST['teaandcoffeeallday'];



$orangejuice=$_POST['orangejuice'];



$mineralwater=$_POST['mineralwater'];



$cookies=$_POST['cookies'];



$slices=$_POST['slices'];



$minimuffins=$_POST['minimuffins'];



$texanmuffins=$_POST['texanmuffins'];



$bananaorcarrotcake=$_POST['bananaorcarrotcake'];



$minidanishes=$_POST['minidanishes'];



$assprtedsandwhiches4points=$_POST['assprtedsandwhiches4points'];



$assortedsandwhiches6points=$_POST['assortedsandwhiches6points'];



$c1=$_POST['c1'];



$c2=$_POST['c2'];



$c3=$_POST['c3'];



$c4=$_POST['c4'];



$c5=$_POST['c5'];



$Tandoorichickenskewers=$_POST['Tandoorichickenskewers'];



$Californiasushirolls=$_POST['Californiasushirolls'];



$Thaiprawnskewers=$_POST['Thaiprawnskewers'];



$Roastedvegetablefrittata=$_POST['Roastedvegetablefrittata'];



$Vegetablesamosas=$_POST['Vegetablesamosas'];



$Smokedsalmontarts=$_POST['Smokedsalmontarts'];



$Cocktailspringrolls=$_POST['Cocktailspringrolls'];



$DimSims=$_POST['DimSims'];



$c6=$_POST['c6'];



$Beefsatay=$_POST['Beefsatay'];



$Orangeandhoneydrumsticks=$_POST['Orangeandhoneydrumsticks'];



$Antipastoplatter=$_POST['Antipastoplatter'];



$Roastedvegandcumincouscous=$_POST['Roastedvegandcumincouscous'];



$Coleslaw=$_POST['Coleslaw'];



$Potatoandeggsaladwithchives=$_POST['Potatoandeggsaladwithchives'];



$Basilandcherrytomatofusilli=$_POST['Basilandcherrytomatofusilli'];



$greensalad=$_POST['greensalad'];



$ceasarsalad=$_POST['ceasarsalad'];



$freshfruitsaad=$_POST['freshfruitsaad'];



$breadrollsandbutter=$_POST['breadrollsandbutter'];



$freshseasonalfruitplatter=$_POST['freshseasonalfruitplatter'];



$cheeseplatter=$_POST['cheeseplatter'];



$Name=$_POST['Name'];



$deliveryaddress=nl2br($_POST['deliveryaddress']);



$DeliveryDate=$_POST['DeliveryDate'];



$DeliveryTime=$_POST['DeliveryTime'];



$ContactForm=$_POST['ContactForm'];



$comments=nl2br($_POST['comments']);



$totalamount=$_POST['totalamount'];



$gtotalamount=$_POST['gtotalamount'];



$gst=$_POST['gst'];



$discount=$_POST['discount'];



$ccno=$_POST['ccno1'].$_POST['ccno2'].$_POST['ccno3'].$_POST['ccno4'];



$CardExpiry=$_POST['CardExpiry'];



$ccv=$_POST['ccv'];







if($_POST['submit_2']==1)

{

$ipadd=$_SERVER['REMOTE_ADDR'];



$to      = 'derek@eatatmenzies.com.au';

$subject = 'New Catering Order';



$headers  = 'MIME-Version: 1.0' . "\r\n";



$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";



$headers .= 'From: mail@EatAtMenzies.com.au' . "\r\n" .



    'Reply-To: mail@EatAtMenzies.com.au' . "\r\n" .



    'X-Mailer: PHP/' . phpversion();









$mailbody=<<<EWURPO







          <table width="575" border="0" align="center" cellpadding="0" cellspacing="2">



            <tbody>



              <tr>



                <td colspan="3"><h2>



                  <hr color="#333333" noshade="noshade" size="1" />



                </h2></td>



                </tr>



              <tr>



                <td width="284"><h1>Refreshments</h1></td>



                <td width="122"><p>per person<br />



                </p></td>



                <td width="161"><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>Tea &amp; Coffee</p></td>



                <td><p>$2.50 </p></td>



                <td>$teaandcoffee



                </td>



              </tr>



              <tr>



                <td><p>Tea &amp; Coffee (all day)</p></td>



                <td><p>$8.50</p></td>



                <td>$teaandcoffeeallday</td>



              </tr>



              <tr>



                <td><p>Orange Juice</p></td>



                <td><p>$2.50</p></td>



                <td>$orangejuice</td>



              </tr>



              <tr>



                <td><p>Mineral Water</p></td>



                <td><p>$2.00</p></td>



                <td>$mineralwater</td>



              </tr>



              <tr>



                <td height="50"><br /></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><h1>Morning &amp; Afternoon Tea</h1></td>



                <td><p>per person<br />



                </p></td>



                <td><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>Cookies</p></td>



                <td><p>$2.50 </p></td>



                <td><p>



                  $cookies



                </p></td>



              </tr>



              <tr>



                <td><p>Slices</p></td>



                <td><p>$3.00</p></td>



                <td>$slices</td>



              </tr>



              <tr>



                <td><p>Muffins (mini)</p></td>



                <td><p>$1.50</p></td>



                <td>$minimuffins</td>



              </tr>



              <tr>



                <td><p>Muffins (Texan)</p></td>



                <td><p>$3.00</p></td>



                <td>$texanmuffins</td>



              </tr>



              <tr>



                <td valign="top"><p>Banana or Carrot cake</p></td>



                <td valign="top"><p>$2.50</p></td>



                <td valign="top">$bananaorcarrotcake</td>



              </tr>



              <tr>



                <td><p>Mini Danishes</p></td>



                <td><p>$1.50</p></td>



                <td>$minidanishes</td>



              </tr>



              <tr>



                <td height="50"><br /></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><h1>Sandwich Platters</h1></td>



                <td><p>per person<br />



                </p></td>



                <td><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>Assorted sandwiches (4 points)</p></td>



                <td><p>$5.00 </p></td>



                <td>



                $assprtedsandwhiches4points</td>



              </tr>



              <tr>



                <td><p>Assorted sandwiches (6 points)</p></td>



                <td><p>$6.80 per person</p></td>



                <td>



                $assortedsandwhiches6points</td>



              </tr>



              <tr>



                <td height="50"><br /></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><h1>Finger Food Platters</h1></td>



                <td colspan="2">�



                  <p>per person<br />



                  </p></td>



              </tr>



              <tr>



                <td colspan="3"><p>Items listed below are based on 2 pieces per serve



                  (minimum 8 people)</p></td>



              </tr>



              <tr>



                <td>&nbsp;</td>



                <td>&nbsp;</td>



                <td><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>Caramalised onion &amp; goats cheese tarts (V)</p></td>



                <td><p>$1.50 </p></td>



                <td>$c1</td>



              </tr>



              <tr>



                <td><p>Mini cottage pies</p></td>



                <td><p>$2.00</p></td>



                <td>$c2</td>



              </tr>



              <tr>



                <td><p>Canap�s with tomato &amp; basil salsa (V)</p></td>



                <td><p>$1.20</p></td>



                <td>$c3</td>



              </tr>



              <tr>



                <td><p>Canap�s with smoked salmon and cream cheese</p></td>



                <td><p>$1.80</p></td>



                <td>$c4</td>



              </tr>



              <tr>



                <td><p>Home made sausage rolls</p></td>



                <td><p>$1.60</p></td>



                <td>$c5</td>



              </tr>



              <tr>



                <td><p>Tandoori chicken skewers</p></td>



                <td><p>$2.00</p></td>



                <td>



                $Tandoorichickenskewers



                </td>



              </tr>



              <tr>



                <td><p>California sushi rolls</p></td>



                <td><p>$1.80</p></td>



                <td>$Californiasushirolls</td>



              </tr>



              <tr>



                <td><p>Thai prawn skewers</p></td>



                <td><p>$2.60</p></td>



                <td>$Thaiprawnskewers</td>



              </tr>



              <tr>



                <td><p>Roasted vegetable frittata</p></td>



                <td><p>$1.80</p></td>



                <td>$Roastedvegetablefrittata</td>



              </tr>



              <tr>



                <td><p>Vegetable samosas</p></td>



                <td><p>$1.50</p></td>



                <td>$Vegetablesamosas</td>



              </tr>



              <tr>



                <td><p>Smoked salmon tarts</p></td>



                <td><p>$1.80</p></td>



                <td>$Smokedsalmontarts</td>



              </tr>



              <tr>



                <td><p>Cocktail spring rolls</p></td>



                <td><p>$1.50</p></td>



                <td>$Cocktailspringrolls</td>



              </tr>



              <tr>



                <td><p>Dim Sims<br />



                </p></td>



                <td><p>$1.50</p></td>



                <td>$DimSims</td>



              </tr>



              <tr>



                <td><p>Cheese &amp; sun dried tomato puffs (V)</p></td>



                <td><p>$1.30</p></td>



                <td>$c6</td>



              </tr>



              <tr>



                <td><p>Beef satay</p></td>



                <td><p>$2.00</p></td>



                <td>$Beefsatay</td>



              </tr>



              <tr>



                <td><p>Orange and honey drumsticks</p></td>



                <td><p>$2.50</p></td>



                <td>$Orangeandhoneydrumsticks</td>



              </tr>



              <tr>



                <td height="50"><br /></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><h1>Antipasto Platter</h1></td>



                <td valign="top"><p>$8.00 per person</p></td>



                <td valign="top"><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>(minimum 4 people)</p></td>



                <td><p><br />



                </p></td>



                <td>$Antipastoplatter</td>



              </tr>



              <tr>



                <td colspan="3"><p>Including: Olives, prosciutto, salami, pesto salad with bocconcini and tomato &amp; roasted red capsicum</p></td>



              </tr>



              <tr>



                <td height="50"><br /></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><h1>Salads</h1></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><p>(minimum 4 people)</p></td>



                <td><p>per person<br />



                </p></td>



                <td><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>Roasted veg and cumin cous cous</p></td>



                <td><p>$2.50 </p></td>



                <td>



                $Roastedvegandcumincouscous</td>



              </tr>



              <tr>



                <td><p>Coleslaw</p></td>



                <td><p>$2.50</p></td>



                <td>$Coleslaw</td>



              </tr>



              <tr>



                <td><p>Potato and egg salad with chives</p></td>



                <td><p>$2.50</p></td>



                <td>



                $Potatoandeggsaladwithchives



                </td>



              </tr>



              <tr>



                <td><p>Basil and cherry tomato fusilli</p></td>



                <td><p>$2.50</p></td>



                <td>$Basilandcherrytomatofusilli</td>



              </tr>



              <tr>



                <td><p>Green salad</p></td>



                <td><p>$2.50</p></td>



                <td>$greensalad</td>



              </tr>



              <tr>



                <td><p>Caesar Salad</p></td>



                <td><p>$3.00</p></td>



                <td>$ceasarsalad</td>



              </tr>



              <tr>



                <td><p>Fresh fruit salad</p></td>



                <td><p>$3.80</p></td>



                <td>$freshfruitsaad</td>



              </tr>



              <tr>



                <td><p>Bread rolls and butter</p></td>



                <td><p>$1.00</p></td>



                <td>$breadrollsandbutter</td>



              </tr>



              <tr>



                <td height="50"><br /></td>



                <td colspan="2"><br /></td>



              </tr>



              <tr>



                <td><h1>Fresh Seasonal Fruit Platter</h1></td>



                <td valign="top"><p>$5.00 per person</p></td>



                <td valign="top"><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>(minimum 4 people)</p></td>



                <td><p><br />



                </p></td>



                <td>$freshseasonalfruitplatter</td>



              </tr>



              <tr>



                <td height="25"><p><br />



                </p></td>



                <td colspan="2"><p><br />



                </p></td>



              </tr>



              <tr>



                <td><h1>Cheese Platter</h1></td>



                <td valign="top"><p>$5.00 per person</p></td>



                <td valign="top"><p>QTY</p></td>



              </tr>



              <tr>



                <td><p>(minimum 4 people)</p></td>



                <td><p><br />



                </p></td>



                <td>$cheeseplatter</td>



              </tr>



              <tr>



                <td colspan="3"><p>A soft, a cheddar and a blue, served with fresh grapes &amp; biscuits</p></td>



                </tr>



              <tr>



                <td colspan="3"><br /></td>



                </tr>



            </tbody>



          </table>



          <table width="575" border="0" align="center" cellpadding="0" cellspacing="0">



            <tr>



              <td width="156"><p>Name:</p></td>



              <td width="419"><p>



                $Name



              </p></td>



            </tr>



            <tr>



              <td width="156"><p>Credit Card Number:</p></td>



              <td width="419"><p>



                $ccno



              </p></td>



            </tr>



            <tr>



              <td width="156"><p>Card Expiry:</p></td>



              <td width="419"><p>



                $CardExpiry



              </p></td>



            </tr>



            <tr>



              <td width="156"><p>Card Expiry:</p></td>



              <td width="419"><p>



                $ccv



              </p></td>



            </tr>



            <tr>



              <td><p>Delivery Address:</p></td>



              <td><p>



                $deliveryaddress



              </p></td>



            </tr>



            <tr>



              <td><p>Delivery Date:</p></td>



              <td><p>



               $DeliveryDate



              </p></td>



            </tr>



            <tr>



              <td><p>Aprrox Delivery Time:</p></td>



              <td><p>



                $DeliveryTime



              </p></td>



            </tr>



            <tr>



              <td><p>Contact Number:</p></td>



              <td><p>



                $ContactForm



              </p></td>



            </tr>



            <tr>



              <td><p>Comments:</p></td>



              <td>$comments</td>



            </tr>



            <tr>



              <td>&nbsp;</td>



              <td><h1>Sub Total: $totalamount</h1></td>



            </tr>



            <tr>



              <td>&nbsp;</td>



              <td><h1>Discounts: $discount</h1></td>



            </tr>



            <tr>



              <td>&nbsp;</td>



              <td><h1>GST: $gst</h1></td>



            </tr>



            <tr>



              <td>&nbsp;</td>



              <td><h1>Grand Total: $gtotalamount</h1></td>



            </tr>



          </table>



          <br /><br />



          This form was submitted by this IP ($ipadd)



         



EWURPO;



mail($to, $subject, $mailbody, $headers);



?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



<html xmlns="http://www.w3.org/1999/xhtml">



<head>



<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />



<title>Eat @  Menzies - Catering menu - Order Online</title>



<link href="style.css" rel="stylesheet" type="text/css" />







<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>



<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />



<style type="text/css">



<!--



body {



   background-color: #CCC;



}



#wrapper #container #content #menu table tr td #MenuBar2 li a{



   color: #000;



}



#wrapper #container #content #menu table tr td #MenuBar2 li a:hover{



   color: #FFF;



}



-->



</style></head>







<body>



<div id="wrapper">



<div id="container">



<div id="logo"><a href="index.html"><img src="images/logo.jpg" alt="eat at menzies" width="360" height="139" border="0" longdesc="http://www.eatatmenzies.com.au" /></a></div>



<div id="content">



  <div id="menu">

    <table width="573" border="0" cellspacing="0" cellpadding="0">

      <tr>

        <td width="6" height="67" align="center">&nbsp;</td>

        <td width="59" align="center"><a href="index.html">Home</a></td>

        <td width="57" align="center"><a href="menu.html">Menu</a></td>

        <td width="69" align="center"><a href="the_toad.html">The Toad</a></td>

        <td width="156" align="center">Catering &amp; Functions</td>

        <td width="158" align="center"><a href="meal_plans.html">Resident Meal Plans</a></td>

        <td width="54" align="center"><a href="contact.html">Contact</a></td>

        <td width="14" align="center">&nbsp;</td>

      </tr>

    </table>

  </div>



  <div id="left_content">



    <p>Menzies College<br />



      La Trobe University<br />



      Bundoora, 3086</p>



    <p>Tel: 03 9479 3289<br />



      Email: mail@EatAtMenzies.com.au</p>



  </div>



 <div id="right_content"><form method="post" action="catering_menu.php">



   <table width="696" border="0" cellspacing="0" cellpadding="0">



  <tr>



    <td><img src="images/right_top.jpg" width="696" height="51" /></td>



  </tr>



  <tr>



    <td bgcolor="#FFFFFF"><table width="690" border="0" cellspacing="0" cellpadding="0">



      <tr>



        <td width="28">&nbsp;</td>



        <td width="644"><h1>Catering Menu &amp; Order Form</h1>



       



         



         



          <p>&nbsp;</p>



          <p><strong>Your catering order was submitted successfully. <br />



To contact us, please email</strong> <a href="mailto:mail@EatAtMenzies.com.au">mail@EatAtMenzies.com.au</a> <strong>or call 9479 3289.</strong></p>



          <p><strong>Free delivery within campus for orders over $50.00. <br />



            Prices are subject to change without further notice.</strong></p>



          <p><strong><br />



          </strong></p>



<p>&nbsp;</p></td>



        <td width="18">&nbsp;</td>



      </tr>



    </table></td>



  </tr>



  <tr>



    <td><img src="images/right_bottom.jpg" width="696" height="68" /></td>



  </tr>



</table>



 </form>



    </div>



  <div id="footer"><a href="http://www.tizzbizzdesign.com.au">Wesbite By Tizz Bizz Design</a></div>



</div>







</div>







</div>







</body>



</html>

<?}

else

{?>

   

   

   

   

   

   

   

   

   

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>



<script type="text/javascript" src="js/prototype.js"></script>

<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>

<script type="text/javascript" src="js/lightbox.js"></script>



<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />



<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Eat @  Menzies - Catering menu - Order Online</title>

<link href="style.css" rel="stylesheet" type="text/css" />



<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>

<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />

<style type="text/css">

<!--

body {

   background-color: #CCC;

}

#wrapper #container #content #menu table tr td #MenuBar2 li a{

   color: #000;

}

#wrapper #container #content #menu table tr td #MenuBar2 li a:hover{

   color: #FFF;

}

-->

</style>

<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />

</head>



<body>

<div id="wrapper">

<div id="container">

<div id="logo"><a href="index.html"><img src="images/logo.jpg" alt="eat at menzies" width="360" height="139" border="0" longdesc="http://www.eatatmenzies.com.au" /></a></div>

<div id="content">

  <div id="menu">

    <table width="573" border="0" cellspacing="0" cellpadding="0">

      <tr>

        <td width="7" height="67" align="center">&nbsp;</td>

        <td align="center"><table border="0" cellspacing="0" cellpadding="12">

          <tr>

            <td><a href="index.html">Home</a></td>

            <td><a href="menu.html">Menu</a></td>

            <td><a href="the_toad.html">The Toad</a></td>

            <td>Catering &amp; Functions</td>

            <td><a href="meal_plans.html">Resdient Meal Plans</a></td>

            <td><a href="contact.html">Contact</a></td>

          </tr>

        </table></td>

        <td width="12" align="center">&nbsp;</td>

      </tr>

    </table>

  </div>

  <div id="left_content">

    <p>Menzies College<br />

      La Trobe University<br />

      Bundoora, 3086</p>

    <p>Tel: 03 9479 3289<br />

      Email: mail@EatAtMenzies.com.au</p>

     

     

  </div>

  <div id="right_content">

  <form name="cform" method="post" action="catering_menu.php">

  <input type="hidden" name="teaandcoffee" value="<?=$teaandcoffee?>" />

  <input type="hidden" name="teaandcoffeeallday" value="<?=$teaandcoffeeallday?>" />

  <input type="hidden" name="orangejuice" value="<?=$orangejuice?>" />

  <input type="hidden" name="mineralwater" value="<?=$mineralwater?>" />

  <input type="hidden" name="cookies" value="<?=$cookies?>" />

  <input type="hidden" name="slices" value="<?=$slices?>" />

  <input type="hidden" name="minimuffins" value="<?=$minimuffins?>" />

  <input type="hidden" name="texanmuffins" value="<?=$texanmuffins?>" />

  <input type="hidden" name="bananaorcarrotcake" value="<?=$bananaorcarrotcake?>" />

  <input type="hidden" name="minidanishes" value="<?=$minidanishes?>" />

  <input type="hidden" name="assprtedsandwhiches4points" value="<?=$assprtedsandwhiches4points?>" />

  <input type="hidden" name="assortedsandwhiches6points" value="<?=$assortedsandwhiches6points?>" />

  <input type="hidden" name="c1" value="<?=$c1?>" />

  <input type="hidden" name="c2" value="<?=$c2?>" />

  <input type="hidden" name="c3" value="<?=$c3?>" />

  <input type="hidden" name="c4" value="<?=$c4?>" />

  <input type="hidden" name="c5" value="<?=$c5?>" />

  <input type="hidden" name="c6" value="<?=$c6?>" />



  <input type="hidden" name="Tandoorichickenskewers" value="<?=$Tandoorichickenskewers?>" />

  <input type="hidden" name="Californiasushirolls" value="<?=$Californiasushirolls?>" />

  <input type="hidden" name="Thaiprawnskewers" value="<?=$Thaiprawnskewers?>" />

  <input type="hidden" name="Roastedvegetablefrittata" value="<?=$Roastedvegetablefrittata?>" />

  <input type="hidden" name="Vegetablesamosas" value="<?=$Vegetablesamosas?>" />

  <input type="hidden" name="Smokedsalmontarts" value="<?=$Smokedsalmontarts?>" />

  <input type="hidden" name="Cocktailspringrolls" value="<?=$Cocktailspringrolls?>" />

  <input type="hidden" name="DimSims" value="<?=$DimSims?>" />

  <input type="hidden" name="Beefsatay" value="<?=$Beefsatay?>" />

  <input type="hidden" name="Orangeandhoneydrumsticks" value="<?=$Orangeandhoneydrumsticks?>" />

  <input type="hidden" name="Antipastoplatter" value="<?=$Antipastoplatter?>" />

  <input type="hidden" name="Roastedvegandcumincouscous" value="<?=$Roastedvegandcumincouscous?>" />

  <input type="hidden" name="Coleslaw" value="<?=$Coleslaw?>" />

  <input type="hidden" name="Potatoandeggsaladwithchives" value="<?=$Potatoandeggsaladwithchives?>" />

  <input type="hidden" name="Basilandcherrytomatofusilli" value="<?=$Basilandcherrytomatofusilli?>" />

  <input type="hidden" name="greensalad" value="<?=$greensalad?>" />

  <input type="hidden" name="ceasarsalad" value="<?=$ceasarsalad?>" />

  <input type="hidden" name="freshfruitsaad" value="<?=$freshfruitsaad?>" />

  <input type="hidden" name="breadrollsandbutter" value="<?=$breadrollsandbutter?>" />

  <input type="hidden" name="freshseasonalfruitplatter" value="<?=$freshseasonalfruitplatter?>" />

  <input type="hidden" name="cheeseplatter" value="<?=$cheeseplatter?>" />

  <input type="hidden" name="gtotalamount" value="<?=$gtotalamount?>" />

  <input type="hidden" name="totalamount" value="<?=$totalamount?>" />

  <input type="hidden" name="discount

I have a dropdown menu

<td width="148" height="35" valign="top"><b>Type: </b> </td>
            <td><select name ="tabledrop">
<option value="goggles">goggles</option>
<option value="headbands">headbands</option>
 <input type='hidden' id='tabledrop' name='tabledrop' value = ''/>
</select>
</td>

those 2 options are actually names of my tables.


I tried this and got some syntax error.


$type = $_POST['tabledrop'];
$item = $_POST['goggles_name'];
$price = $_POST['goggles_price'];
$file = $_FILES['goggles_image']['name'];

$query = "INSERT into $type SET [$type]_name = '$item' , [$type]_price = '$price' , [$type]_image = '$file'";

Hi,

I'm trying to create a simple BB code-type function, but I'm having trouble putting a function within preg_replace. Let me show you what I mean:

Code: [Select]
$bb_search = array
      (
            '/\[b\]/',
            '/\[\/b\]/',
            '/\[img\=(.*?)\]/',
      );

      $bb_replace = array
      (
            '<b>',
            '</b>',
            check_image( '\\1' ),
      );

      return preg_replace( $bb_search, $bb_replace, $text_string );

The first two (b and /b) work fine, even the function is recognised, but using \\1 doesn't put the bbcode value as the function value. I know that probably made no sense - I'm terrible at explaining these things, so sorry. If anyone can understand what I mean, even offer a solution, that would be great!

Cheers!

hello.

im having trouble putting an if statment in my loop

this is my loop.
Code: [Select]
  <div id="ddtabs3" class="solidblockmenu">
<ul>
<?PHP foreach($topNav as $topNavs): ?>
<li><a href="<?PHP echo $topNavs->title; ?>.php" id="<?PHP echo $topNavs->title; ?>"><?PHP echo $topNavs->title; ?></a></li>
<?PHP endforeach; ?>
</ul>
</div><!--  #ddtabs3-->

i what to add an if $pageName = '$topNavs->title';  then  <li class = selected>

any ideas

thanks
rick

i'm back again and i am not very good with tables as the <tr> and <td> tags confuse me 
i need to put 2 sets of links into 2 columns in the table and they come out jumbled up.

Code: [Select]
<table>
<tr>
<th>column 1</th>
<th>column 2</th>
</tr>
<?php

$sites = array_map('trim',file('websites.txt')); //read the whole file into an array & trim the newline character from the end of each line
foreach ($sites as $link) {
   echo "<tr><td><a href='$link'>$link</a></td>";
}


$sites = array_map('trim',file('websites2.txt')); //read the whole file into an array & trim the newline character from the end of each line
foreach ($sites as $link) {
   echo "<td><a href='$link'>$link</a></td></tr>";
}

?>

</table>

OK so i am having a little trouble putting guilds in my game, everything shows up but when you go to create a new guild it say can not update player stats, but it shows up that the guild has been created in the top guild list, it just doesnt let you use it here is the script could someone tell me if they see a problem

Code: [Select]
<?php
require 'connect.php';
include 'header.php';
include 'headin.php';
?>
<script type="text/javascript">
function stats()
{
  var no=document.getElementById("Name")
  var option=no.options[no.selectedIndex].value
  var y="guild.php?stats=1&&guild="+option
  window.open(y,"_blank","toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width=400, height=500")
}

function redirect()
{
  window.location="./guild.php"
}
</script>
<?php
if(!isset($_COOKIE['member_id']))
  die('Not logged in, please <a href=login.php>login</a>');
$Player=$_COOKIE['member_id'];
$Option=$_POST['option'];
$Create=$_POST['create'];
$Join=$_POST['join'];
$Submit=$_POST['submit'];
$Tax=$_POST['tax'];
$Guild=$_GET['guild'];
$Deny=$_GET['deny'];
$Add=$_GET['add'];
$Stats=$_GET['stats'];
$Kick=$_GET['kick'];
$Kickname=$_GET['kickname'];
$Addname=$_GET['addname'];
$Abandon=$_POST['abandon'];
$Coleader=$_GET['coleader'];
if(isset($Abandon))
  $Option="Abandon";
if($Option=="")
  $Option=$_GET['option'];
if(isset($Option))
{
  if($Option=='Create a guild')
  {
  ?>
<p>It costs 1,000,000 gold to create a Guild.<br /><br /></p>
<form method="post" action="guild.php">
Name:<input class="text" type="text" name="name" />
<input class="button" name="create" type="submit" value="submit" />
</form>
  <?php
  }
  elseif($Option=='Join a guild')
  {
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "<select class=\"select\" name='Name' id='Name' length='20' id='blah'>";
    $Guild="SELECT * from Guilds order by ID asc";
    $Guild2=mysql_query($Guild) or die("Could not select Guilds");
    while ($Guild3=mysql_fetch_array($Guild2))
    {
      $Name=str_replace(" ","%20",$Guild3['Name']);
      print "<option value=\"$Name\">$Guild3[Name]</option>";
    }
    print "</select><br />";
    print "<input class=\"button\" type='Submit' name='join' value='Join' /> ";
    ?><input class=button type="button" onclick="stats()" value="Stats" /></form> <?php
  }
elseif($Option=='Raise your guilds tax')
  {
        $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    if($Guild['Tax']>90){
    mysql_query("UPDATE Guilds SET Tax='90' WHERE Name='$Name'");
    }
    if($Guild['Owner']==$User['Playername'] || $Guild['Coleader']==$User['Playername']){
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "Amount: <input type=text class=\"select\" name='tax' id='tax' length='3' id='tax'>";
    print "<br /><br>";
    print "<input class=\"button\" type='Submit' name='submit' value='Raise' /></form> ";
    
}else{
echo"You may not edit your Guild Tax, since you are not a leader or co-leader.";
exit;
}
  }
  elseif($Option=='Guild stats')
  {

    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    $Query="SELECT * from Users where Guild='$Guild[Name]' order by Level desc";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    if($Guild['Name']!="")
    {
      print "<table class=\"table\" align=\"center\"><tr><td>";
      $AttackPower=number_format(pow($Guild['AttackPower']+10, 5));
      $DefenceStance=number_format(pow($Guild['DefenceStance']+10, 5));
      $Agility=number_format(pow($Guild['Agility']+10, 5));
      $Gold=pow($Guild['Gold']+12,3)*4;
      $Gold=number_format($Gold);
      $Exp=pow($Guild['Exp']+9, 4)+500;
      $Exp=number_format($Exp);
      $Itemfind=number_format(pow($Guild['Itemfind']+10, 5));
      $Itemquality=number_format(pow($Guild['Itemquality']+10, 5));
      print "Guild Name: $Guild[Name]<br />Guild Owner: $Guild[Owner]<br />Guild Co-Owner: $Guild[Coleader]<br />Guild Bank: $Guild[Bank]<br />Guild Tax: $Guild[Tax]%<br />Last Guild Battle: $Guild[LastFight]<br />Battles won: $Guild[Won]<br />Battles Lost: $Guild[Lost]<br />";
      
if($Guild['Owner']==$User['Playername'] || $Guild['Coleader']==$User['Playername'] || $User['Admin']==1){
echo "<form class=\"form\" method=\"post\" action=\"guildbonus.php\">";
      echo "Attack Power:".$Guild['AttackPower']."% <input class=\"button\" type='Submit' name='AttackPower' value='Increase' /> $AttackPower gold<br />";
      echo "Defence Stance:".$Guild['DefenceStance']."% <input class=\"button\" type='Submit' name='DefenceStance' value='Increase' /> $DefenceStance gold<br />";
      echo "Agility:".$Guild['Agility']."% <input class=\"button\" type='Submit' name='Agility' value='Increase' /> $Agility gold<br />";
      echo"Exp:".$Guild['Exp']."% <input class=\"button\" type='Submit' name='Exp' value='Increase' /> $Exp gold<br />";
      echo "Gold:".$Guild['Gold']."% <input class=\"button\" type='Submit' name='Gold' value='Increase' /> $Gold gold<br />";
      echo "Item Find:".$Guild['Itemfind']."% <input class=\"button\" type='Submit' name='Itemfind' value='Increase' /> $Itemfind gold<br />";      
      echo "Item Quality:".$Guild['Itemquality']."% <input class=\"button\" type='Submit' name='Itemquality' value='Increase' /> $Itemquality gold<br />";
}else{
echo "<form class=\"form\" method=\"post\" action=\"guildbonus.php\">";
      echo "Attack Power:".$Guild['AttackPower']."% <br />";
      echo "Defence Stance:".$Guild['DefenceStance']."% <br />";
      echo "Agility:".$Guild['Agility']."% <br />";
      echo "Experience".$Guild['Exp']."% <br />";
      echo "Gold:".$Guild['Gold']."% <br />";
      echo "Item Find:".$Guild['Itemfind']."% <br />";      
      echo "Item Quality:".$Guild['Itemquality']."% <br />";
}
      print "Donate:<input class=\"text\" type=\"text\" name=\"Amount\" value=\"$User[Gold]\" /><input class=\"button\" type='Submit' name='Donate' value='Donate' /></form><br />";
      if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
    print"<a href=\"attackguild.php\">Attack Other Guilds</a><br><br>";
    }
      if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1")
      {
        $Name=str_replace(" ","%20",$Guild['Name']);
        echo "<a href=\"guild.php?coleader=1&&Guild=$Name\">Assign coleader</a><br />";
      }
      print "</td></tr></table>";
    }
    else
      echo "You are not in a guild, below is a listing of all people not in a guild.";
    print "<table class=\"table\" align=\"right\"><tr><td>";
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "<table><tr><td>";
    print "Members:<br />To kick a member out the guild must pay half of what the User has donated.<br><br><table id=\"table\"><tr><td>Player</td><td>Level</td><td>Donated</td>";
     if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
      print "<td>Kick</td>";
     }
    print "</tr>";
    while($topplayer3=mysql_fetch_array($Query2))
    {
      print "<tr><td>$topplayer3[Playername]</td><td>$topplayer3[Level]</td><td>$topplayer3[GuildDonate]</td>";
       if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
      print "<td><a href=\"guild.php?kick=$topplayer3[ID]&&kickname=$Guild[ID]\">Kick</a></td>";
     }
      print "</tr>";
    }
    print "</table></form></td><td></td><td>";
    if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1")
    {
      $Name = $Guild['Name'];
      $Guild['Name' ]= str_replace(" ","%20",$Guild['Name']);
      $Query = mysql_query("select * from Users where Applied='$Name'");
      print "Requests:<br /><table id=\"table\"><tr><td>Name</td><td>Level</td><td>Accept?</td><td>Deny?</td></tr>";
      while($joinee = mysql_fetch_array($Query))
      {
        echo "<tr><td>$joinee[Playername]</td>";
        echo "<td>$joinee[Level]</td>";
        echo "<td><a href=\"guild.php?add=$joinee[ID]&&addname=$Guild[Name]\">Accept</a></td><td><a href=\"guild.php?deny=$joinee[ID]\">Deny</a></td></tr>";
      }
      print "</table>";
      print "</td></tr></table>";
    }
    print "</td></tr></table><br />";
    
  }
  elseif($Option=='Leave guild')
  {
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    if($Guild['Owner']==$User['Playername'])
    {
      echo "Are you sure you want to abandon and delete your guild?";
      echo "<form action=\"guild.php\" method=\"post\"><input type=\"hidden\" value=\"$Guild[Name]\" name=\"Guild\" /><input class=\"button\" type=\"submit\" name=\"abandon\" value=\"yes\" /><input class=\"button\" type=\"button\" value=\"no\" onclick=\"redirect()\" /></form>";
    }
    else
    {
      mysql_query("UPDATE Users SET GuildDonate='0' WHERE ID='$Player'");
      mysql_query("Update Users set Guild='' where ID='$Player'") or die("Could not update player stats");
      mysql_query("update Guilds set Members=Members-'1' where Name='$Guild[Name]'") or die("Could not decrease number of members");
      print "You have left the guild.";
    }
  }
  elseif($Option=="Abandon")
  {
    $Guild=$_POST['Guild'];
    $Query="Select * from Users where Guild='$Guild'";
    $Query2=mysql_query($Query) or die("Zomg");
    while($User=mysql_fetch_array($Query2))
    {
      $ID=$User['ID'];
      $Update="Update Users set Guild='' where ID='$ID'";
      mysql_query($Update) or die("No clan update.");
    }
    $Query="Delete from Guilds where Name='$Guild'";
    mysql_query($Query) or die("Can't delete guild.");
    echo "Clan deleted.";
  }
}
elseif(isset($Kick))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Querty="SELECT * from Users where ID='$Kick'";
    $Querty2=mysql_query($Querty) or die("Could not get user stats");
    $Kicking=mysql_fetch_array($Querty2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    $KickAmount=$Kicking['GuildDonate']/2;
    
   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot kick users because you are not the leader or coleader of this guild!";
   exit;
   }
   elseif($Kicking['Playername']==$Guild['Owner']){
   echo"You may not kick out the creator of this guild!";
   exit;
   }
   elseif($KickAmount>$Guild['Bank']){
   echo"You do not have enough gold to kick this player out. To kick out a member you must be able to pay half of what they have donated.";
   exit;
   }
   else{
 mysql_query("UPDATE Guilds SET Bank=Bank-'$KickAmount' WHERE ID='$Kickname'");
 mysql_query("UPDATE Guilds SET Members=Members-'1' WHERE Name='$Guild[Name]'");
 mysql_query("UPDATE Users SET Gold=Gold'$KickAmount' WHERE ID='$Kick'");
 mysql_query("UPDATE Users SET GuildDonate='0' WHERE ID='$Kick'");
 mysql_query("UPDATE Users SET Guild='' WHERE ID='$Kick'");
 echo"Player kicked from your guild! <a href='guild.php'>Back</a>";
   }
}
elseif(isset($Submit))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

if($Tax<0 || $Tax>90){
echo"Do you want people leaving your guild?";
exit;
}else{
mysql_query("Update Guilds set Tax='$Tax' where Name='$Name'");
echo "Tax set to $Tax!";
}
}
elseif(isset($Create))
{
  if(isset($_POST['name']))
  {
    $Name=$_POST['name'];
    $Player=$_COOKIE['member_id'];
    $Query=mysql_query("select * from Users where ID='$Player'") or die("Could not query Users");
    $User=mysql_fetch_array($Query);
    $check="SELECT * from Guilds where Name='$Name'";
    $check2=mysql_query($check) or die("Could not query guilds");
    while($check3=mysql_fetch_array($check2))
    {
      $Clan=$check3['Name'];
    }
    if($Clan)
       print "Sorry there is already a guild of that name.";
    elseif($User['Guild'] != "")
      echo "You have to leave your clan before you can create your own.";
    elseif($User['Gold']>=1000000)
    {
      $Query="INSERT into Guilds(Name, Owner) VALUES ('$Name', '$User[Playername]')";
      mysql_query($Query) or die("could not create clan");
      $Update="Update Users set Guild='$Name', Applied='', Gold=Gold-'1000000' where ID='$Player'";
      mysql_query($Update) or die("Could not update player stats");
      print "Clan created.";
    }
    else
      print "You do not have enough gold.";
  }
}



elseif(isset($Join))
{
  if(isset($_POST['Name']))
  {
    $Name=$_POST['Name'];
    $Player=$_COOKIE['member_id'];
    $Name=str_replace("%20"," ",$Name);
    $Query=mysql_query("SELECT * FROM Guilds where Name='$Name'") or die("Could not fetch guild stats");
    $Guild=mysql_fetch_array($Query);
    $Query=mysql_query("Select * from Users where ID='$Player'");
    $User=mysql_fetch_array($Query);
    if($User['Guild'] != "")
      echo "Leave your other guild first before you join a new one.<br /><a href=\"guild.php\">Go back</a>";
    elseif($Guild[Members]==15){
    echo "Guild is full, sorry, go pick another. <a href=fight.php>Go</a>";
    }else
    {
      mysql_query("update Users set Applied='$Name' where ID='$Player'");
      if($Guild['Members'] >= 15)
        echo "You are accepted, but the guild is currently full. you may have to wait an extended amount of time before you are accepted.";
      else
        echo "You applied for the clan. Now wait until either the owner or the coleader accepts you.";
    }
  }
}
elseif(isset($Deny)){
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    
   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot deny users because you are not the leader or coleader of this guild!";
   exit;
   }else{
    $Update="Update Users set Applied='' where ID='$Deny'";
    mysql_query($Update) or die("Could not update player stats");
    print "Player denied.<br /><a href=\"guild.php\">Go back</a>";
   }

}
elseif(isset($Add))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    
   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot add users because you are not the leader or coleader of this guild!";
   exit;
   }else{

  $Addname=str_replace("%20"," ",$Addname);
  $Query=mysql_query("SELECT * from Guilds where Name='$Addname'") or die("Could not get guild stats");
  $Guild=mysql_fetch_array($Query);
  if($Guild['Members'] <= 15)
  {
    $Query2=mysql_query("SELECT * FROM Users where ID='$Add'") or die("Could not get player stats");
    $User=mysql_fetch_array($Query2);
    mysql_query("Update Guilds set Members=Members+'1' where Name='$Addname'") or die("Could not update guilds");
    $Update="Update Users set Guild='$Addname', Applied='' where ID='$Add'";
    mysql_query($Update) or die("Could not update player stats");
    print "Player accepted.<br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
  }
  else
    print "Clan is full, cannot accept player.<br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
  }
}
elseif(isset($Guild))
{
  $Query="SELECT * from Guilds where Name='$Guild'";
  $Query2=mysql_query($Query) or die("Could not get guild stats");
  $Guild=mysql_fetch_array($Query2);
  $Query3="SELECT * from Users where Guild='$Guild[Name]'";
  $Query4=mysql_query($Query3) or die("Could not get user stats");
  print "Guild name: $Guild[Name]<br />Guild Owner: $Guild[Owner]<br />Clan bank: $Guild[Bank]<br />";
  echo "Exp:".number_format($Guild['Exp'])."%<br />";
  echo "Gold:".number_format($Guild['Gold'])."%<br />";
  print "Members:<br /><table id=\"table\"><tr><td>Player</td><td>Level</td></tr>";
  while($topplayer3=mysql_fetch_array($Query4))
  {
    print "<tr><td>$topplayer3[Playername]</td><td>$topplayer3[Level]</td></tr>";
  }
  print "</table>";
}
elseif($Coleader==1)
{
  $Guild=str_replace("%20"," ",$_GET['Guild']);
  $Query="SELECT * from Users where Guild='$Guild' order by Level desc";
  $Query2=mysql_query($Query) or die("Could not get user stats");
  $Guild1="SELECT * from Guilds where Name='$Guild'";
  $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
  $Guild=mysql_fetch_array($Guild2);
  print "<table><tr><td>";
  print "Members:<br /><table id=\"table\"><tr><td>Player</td><td>Level</td></tr>";
  while($Member=mysql_fetch_array($Query2))
  {
    if($Member['Playername']!=$Guild['Owner'])
    {
      $Name=str_replace(" ","%20",$Member['Playername']);
      $Guild=str_replace(" ","%20",$_GET['Guild']);
      print "<tr><td><a href=\"guild.php?coleader=$Name&&Guild=$Guild\">$Member[Playername]<a></td><td>$Member[Level]</td></tr>";
    }
  }
  print "</table><br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
}
elseif($Coleader)
{
  $Name=str_replace("%20"," ",$Coleader);
  $Guild=$_GET['Guild'];
  $Query="Update Guilds set Coleader='$Name' where Name='$Guild'";
  mysql_query($Query) or die("Could not set coleader.");
  echo "Coleader assigned. <a href=\"guild.php?option=Guild%20stats\">Go back</a>";
}
else
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

print"<form method=\"post\" action=\"guild.php\">";
print"<select class=\"select\" name=\"option\">";

if($Guild['Name']!=""){

print"<option>Guild stats</option>";
print"<option>Raise your guilds tax</option>";
print"<option>Leave guild</option>";

}else{

print"<option>Create a guild</option>";
print"<option>Join a guild</option>";

}

print"</select>";
print"<input class=\"button\" type=\"submit\" value=\"submit\" name=\"guild\">";
print"</form>";
print"</body>";
}
?>

Hi,

I am still learning php and I've been racking my brain to get some field data
from the mysql database and put the results into variables to use.

I need to do a query to get the data from two fields and place them in a variable.

I have this field from a form: $_REQUEST['linkurl']

So i need to check this form field against (tablename, fieldname) alldomain.domain_name

when the match is found I need to store the value of tablename, fieldname) domain.manual_approve into $x_manual_approve

and then check that rows userid field: (tablename, fieldname) alldomain.userid and equals (tablename, fieldname) register.id

the userid and id are matching from two different tables (tables alldomain and register).

When I get that match I need to get (tablename, fieldname) register.username and store the value into $x_username

Thanks much for any help,

Gibs

Hi Everyone,

I'm trying to figure out a way to put my MySql data into a table. I'm close to getting this completed by I'm having some trouble. The data I'm inserting isn't being put into the correct tables. I'm not quite sure what I'm doing wrong. Any help?

http://whatsmyowncarworth.com/practice/table.php

Code: [Select]
<?php
include('init.php');


$result = mysql_query("SELECT * FROM info")
or die(mysql_error());


echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Last Name</th> <th>Address</th> <th>City</th> </tr>";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) 

{
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['first_name'];
echo "</td><td>"; 
echo $row['last_name'];
echo "</td></tr>"; 

echo "<tr><td>"; 
echo $row['address'];
echo "</td><td>"; 
echo $row['city'];
echo "</td></tr>"; 
} 

echo "</table>";
?>

Hi guys,
 
I've got quite a few fields in my tables that i've serialised to keep the number of fields down. For everything else that works perfect as it stores the data and when needed I can use the following as an example:

$dateofbirth = unserialize($row['dateofbirth']);
$dobday = $dateofbirth[0];
$dobmonth = $dateofbirth[1];
$dobyear = $dateofbirth[2];

 

 
Date of birth is stored as dd,mm,yyyy and for everything else I can call it fine. My issue is now that i'm trying to use fputcsv to create a csv file using the following:

$result = mysqli_query($con, 'SELECT u.user_id, b.dateofbirth FROM Users u INNER JOIN Basic b USING (user_id) ORDER BY user_id DESC');


$fp = fopen('latest.csv', 'w');
 
fputcsv($fp, array('User ID', 'DOB' ));

 
 
 
The CSV generates, but for the date of birth column in the csv it outputs as "a:3:{i:0;s:2:"03";i:1;s:2:"02";i:2;s:4:"1986";}" because it's obviously still serialised. What is my best and or easiest way of handling these fields?
 
Many thanks in advance.
Edited by Kristoff1875, 21 January 2015 - 05:24 AM.

Hi, I have an array key whose value is a line of html in quotes, the problem is , I don't know how to do it. Lol. Any help greatly appreciated because the below code is generating an error in my editor. Thank you. Derek

here is the line.

Code: [Select]
'level_1'=>"<img src='<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>'",
EDIT:

actually I managed to fix the error adding a semicolon after the parenthesis. Is this array correct please?

Code: [Select]
$currentLocation = array
(
'teardrop_ocean_bg' => array
(
'level_1'=>"<img src='<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>'"



)

);

it's not finished yet.

Well, the title pretty much says it all. I'm trying to extract data from an array, put it into a 2D array and then sort it. Then I need to put it's "place" in the order into the table.

I've sort of got something so far but it seems like my while loop isn't working correctly.

$q="SELECT COUNT(*), horseID, total FROM enteredHorses";
$r = mysqli_query ($dbc, $q) or trigger_error(mysqli_error($dbc));
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

        $count = $row['COUNT(*)'];
        $horse_id = $row['horseID'];
        $total = $row['total'];
        

        

for ($counter = 1; $counter <= $count; $counter += 1) {

$i = 0;

$id[$i] = $horse_id;

$total[$i] = $total;


$i = $i+1;

}

} //end while

array_multisort($total, SORT_DESC, $id);


while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

for ($counter = 1; $counter <= $count; $counter += 1) {

$i = 0;
$place = '1';

$q = "INSERT INTO enteredHorses (place) VALUES ('$place') WHERE horse_id='$id[$i']'";
$r = mysqli_query ($dbc, $q) or trigger_error(mysqli_error($dbc));

$i = $i + 1;
$place = $place + 1;

}

}

 

I'm getting this error:

"array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag "

I'm really baffled. Any help?

I'm trying to take a number of items from a database using a while loop and put the results into a variable so that I can send one email with all the results.  I'm having trouble figuring this out though.  Can anyone please give me any ideas as to how to make this work?  Here's what I've done so far... all it does is result in an email with the first set of results in the while loop, not all of them.

Code: [Select]
<?php
include("conf.inc.php");


$result = mysql_query("SELECT `to`,`from`,`subject`,`message`,`date` FROM allmsgs WHERE reported = 'n' ORDER BY `messid` ASC");
$row = mysql_fetch_row($result);

$cdate = date('m-d-Y');

$sendto = "List@emails.here";
$emailsubject = "Webstats Report For $cdate.";

while ($row = mysql_fetch_row($result)) {

$to = $row[0];
$from = $row[1];
$subject = $row[2];
$message = $row[3];
$datetime = $row[4];

$eachmessage = "<p>
<table width=\"400\">
<tr>
<td>
<hr width=\"400\">
To: $to<br>
From: $from<br>
On $datetime<br>&nbsp;<br>
$subject<br>&nbsp;<br>
$message
</td>
</tr>
</table>
</p>";

}

$emailmessage = "<html>
<body>
<p>Here is a list of the messages that have been exchanged in the last 24 hours using the webstat system system.</p>
$eachmessage
</body>
</html>";

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers

$headers .= 'From: Webstats <reports@webstats.com>' . "\r\n";

// Mail it
mail($sendto, $emailsubject, $emailmessage, $headers);


?>