Brugernavn:



Kodeord: Husk
Forside Forum Artikler Downloads Søg
 

Query indsætter to rows ?

Hej Rowl, sider og river håret ud på mig selv lige nu kan simpelt hen ikke finde ud at at rette denne fejl jeg har:

Når jeg køber et Ansigt i butikken så uploader min query 2 ansigter :O?

Lidt Kode:
  1. echo"<center><font color='#000000' face='Papyrus' size='2'>Confirm Purchase</font></center>";
  2.                     $get_face = mysql_query("SELECT * FROM vipfaceshop_faces WHERE id = ".$_GET['id']."")or die(mysql_error());
  3.                     $face = mysql_fetch_assoc($get_face);
  4.                         $credits = $ppfc - $face['price'];
  5.                         mysql_query("UPDATE users SET pfcredits = '$credits' WHERE user_id = '$pid'")or die(mysql_error());
  6.                         mysql_query("INSERT INTO user_faces(user_id, face_id, vipface) values('$pid', ".$face['id'].", 'Yes')")or die(mysql_error());
  7.                         echo "You have succesfully bought the face<br />";
  8.                         echo "<a href='VIPFaces'>Return</a>";

På forhånd tak Toli :)
Oprettet af:
toli

MySQL

Point afsat: 10

Åben
18:05 15/12/2009
det ligner os at din query vil udføres når din side åbner og så igen når du har postet. (sån ligner det ud fra din tekst)
Oprettet af:
danni

Kommentar
18:32 15/12/2009
Du er da nød til at hente nogle oplysninger fra din form evt.
Oprettet af:
m4rc

Kommentar
18:34 15/12/2009
Gørr jeg også m4rc :)


Hele koden :
  1. <?php session_start(); include("includes/config.php"); php?>
  2. <!DOCTYPE html PUBLIC "-// W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml">
  4. <head><style type="text/css">
  5. .menutitle{
  6. cursor:pointer;
  7. margin-bottom: 5px;
  8. background-color:#ECECFF;
  9. color:#000000;
  10. width:140px;
  11. padding:2px;
  12. text-align:center;
  13. font-weight:bold;
  14. /*/*/border:1px solid #000000;/* */
  15. }

  17. .submenu{
  18. margin-bottom: 0.5em;
  19. }
  20. </style>

  22. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  23. <title>Project Fansite - v1.0 By Toli & Joe</title>
  24. <link href="../global.css" rel="stylesheet" type="text/css" />
  25. </head>

  27. <body>
  28. <div id="container">
  29.     <div id="banner">
  30.         <?
  31.         include("includes/banner stats.php");
  32.         ?>
  33.     </div>

  35.     <div id="djsays">
  36.         <?
  37.         include("includes/menu.php");
  38.         ?>
  39.     </div>

  41.     <div id="middle">
  42.         <div id="left">
  43.             <div id="navigation_top"></div>
  44.             <div id="small_middle" style="width: 231; height: 24">
  45.             <div id="masterdiv">
  46.             <?
  47.             include("includes/user_menu.php");
  48.             ?>
  49.             </div>
  50.             </div>
  51.             <div id="small_bottom"></div>
  52.             
  53.             <div id="online_top"></div>
  54.             <div id="small_middle" style="width: 231; height: 16">
  55.             <?
  56.             include("includes/online.php");
  57.             ?>
  58.             </div>
  59.             <div id="small_bottom"></div>
  60.             
  61.             <div id="radio_top"></div>
  62.             <div id="small_middle" style="width: 231; height: 16">
  63.             <?
  64.             include("includes/radio.php");
  65.             ?>
  66.             </div>
  67.             <div id="small_bottom"></div>

  69.             <div id="disclaimer_top"></div>
  70.             <div id="small_middle" style="width: 231; height: 12">
  71.               <div align="left">
  72.               <?
  73.               include("includes/adds.php");
  74.               ?>
  75.               </div>
  76.               <div align="left">
  77.               </div>
  78.               &nbsp;</div>
  79.             <div id="small_bottom"></div>
  80.         </div>

  82.         <div id="centre">
  83.             <div id="content_top"></div>
  84.             <div id="content_middle" style="width: 428; height: 27">
  85.             <?
  86.             // Checks if user is logged on
  87.             if($_SESSION['project_user'] === "yes"){
  88.                 if($pvip == 1){
  89.                 ?>
  90.                 <center><font color="#000000" face="Papyrus" size="2">Vip Face Shop</font></center>
  91.                 <br />
  92.                 Welcome to the VIP face shop, here you can buy special faces only buyable to VIP's.
  93.                 The VIP Face Shop is always open, and is owned buy Project Fansite.
  94.                 </div>
  95.                 <div id="content_bottom"></div>
  96.                 <br />
  97.                 <div id="content_top"></div>
  98.                 <div id="content_middle" style="width: 428; height: 27">
  99.                 <?
  100.                 if(empty($_GET['buy'])){ ?>
  101.                 <center><font color="#000000" face="Papyrus" size="2">Faces:</font></center>
  102.                 <table width="99%" cellpadding="0" cellspacing="0" style="border1px solid #000000">
  103.                 <?
  104.                 $color1 = "#EAEAEA";
  105.                 $color2 = "#F0F0F0";
  106.                 $row_count = 0;
  107.                 $get_faces= mysql_query("SELECT * FROM vipfaceshop_faces ORDER BY id ASC")or die(mysql_error());
  108.                 while($faces = mysql_fetch_assoc($get_faces)){
  109.                     $row_color = ($row_count % 2) ? $color1 : $color2;
  110.                     ?>
  111.                     <tr>
  112.                     <td width="50px"><img src="<? echo $faces['path']; ?>" /></td><td style="background-color:<? echo $row_color; ?>">Name: <? echo $faces['name']; ?> &nbsp;Price: <? echo $faces['price']; ?><a href="faceshopvip.php?buy=yes&id=<? echo $faces['id']; ?>" style="float:right;">» Buy</a></td>
  113.                     </tr>
  114.                     <?
  115.                     $row_count++;
  116.                     }
  117.                     ?>
  118.                     </table>
  119.                 <?
  120.                 } else {
  121.                     
  122.                     echo"<center><font color='#000000' face='Papyrus' size='2'>Confirm Purchase</font></center>";
  123.                     $get_face = mysql_query("SELECT * FROM vipfaceshop_faces WHERE id = ".$_GET['id']."")or die(mysql_error());
  124.                     $face = mysql_fetch_assoc($get_face);
  125.                         $credits = $ppfc - $face['price'];
  126.                         mysql_query("UPDATE users SET pfcredits = '$credits' WHERE user_id = '$pid'")or die(mysql_error());
  127.                         mysql_query("INSERT INTO user_faces(user_id, face_id, vipface) values('$pid', ".$face['id'].", 'Yes')")or die(mysql_error());
  128.                         echo "You have succesfully bought the face<br />";
  129.                         echo "<a href='VIPFaces'>Return</a>";
  130.                     }
  131.                               } else {
  132.                     echo"<meta http-equiv='refresh' content='0;URL=index.php'>";
  133.                 }
  134.             } else {
  135.                 // if he/she isnt, then send them to index.php
  136.                 echo"<meta http-equiv='refresh' content='0;URL=../index.php'>";
  137.             }
  138.             ?>
  139.             </div>
  140.             <div id="content_bottom"></div>
  141.         </div>

  143.         <div id="right">
  144.             <div id="news_top"></div>
  145.             <div id="small_middle" style="width: 231; height: 19">
  146.             <?
  147.             include("includes/news.php");
  148.             ?>
  149.             </div>
  150.             <div id="small_bottom"></div>

  152.             <div id="status_top"></div>
  153.             <div id="small_middle" style="width: 231; height: 22">
  154.             <?
  155.             include("includes/articles.php");
  156.             ?>
  157.             </div>
  158.             <div id="small_bottom"></div>

  160.             <div id="featured_top"></div>
  161.             <div id="small_middle" style="width: 231; height: 25">
  162.             <?
  163.             include("includes/forum.php");
  164.             ?>
  165.             </div>
  166.             <div id="small_bottom"></div>
  167.         </div>
  168.     </div>
  169. <div id="footer"></div>
  170. <? include("Includes/bottom.php"); ?>
  171. </div>
  172. </body>
  173. </html>
Oprettet af:
toli

Kommentar
18:58 15/12/2009
Får du ikke en fejl ved linie 1 ? Tænker på den måde du afslutter dit php
Oprettet af:
danni

Kommentar
19:12 15/12/2009
nej for ingen fejl, har det sådan på alle mine filer og ingen af dem giver fejl.
Oprettet af:
toli

Kommentar
19:14 15/12/2009
okay, normalt startes og lukkes php sån her: <?php ?>

Har ikke lige set din "metode" før med php?>
Oprettet af:
danni

Kommentar
19:17 15/12/2009
når men er det ikke lidt lige meget vis det ikke giver fejl ??
Oprettet af:
toli

Kommentar
19:51 15/12/2009
er der slet ingen der ved hvad jeg gør galt?

og har tænkt lidt over om det måske kan være min mysql tabel?
Oprettet af:
toli

Kommentar
18:55 20/12/2009
Du skal være oprettet og logget ind for at svare på en tråd
Copyright © Rowl.dk v/ Michael Raagaard | 2005-12 | Alle rettigheder forbeholdes