CIO Tech Eksperten IT-JOB IT-Kurser Events Podcast Søg
Cookie ikon
Avatar billede darkstardk Nybegynder
16. marts 2007 - 21:35 Der er 6 kommentarer

tilføj eller slet 1 tal

okay prøver lige at omformulere mit tidligere spørgsmål..
jeg har min mysql database med nogle data, faktisk kun 1 tal, jeg har så trukket det tal ud på min hjemmeside, vedsiden af har jeg så en "plus" og en "minus" knap, skal have lavet det sån at når jeg trykker på "plus", så bliver tallet 1 tal større, og når jeg trykker på minus bliver tallet 1 tal mindre og den skal gerne opdatere siden med det samme, er dette muligt?
Har sån på fornemmelsen at det er noget med noget update, men kan simpelthen ik få det til at virke...
På forhånd tak
Avatar billede uzziuz Nybegynder
16. marts 2007 - 22:20 #1
Kan du ikke lave det med en form:

<?php
//Hent tingene fra databasen

if(isset($_GET['tjek'])){
if(!empty($_POST['knap-til-minus'])){
--$row['tal'];
}elseif(!empty($_POST['knap-til-plus'])){
++$row['tal'];
}else{
echo "Du valgte ingen ting.";
}
}
?>
<form action="plus_og_minus.php?tjek" method="post">
<Din FORM>
</form>

Håber det kan bruges. ;)
Avatar billede darkstardk Nybegynder
16. marts 2007 - 22:26 #2
prøver lige^^
Avatar billede jakobdo Ekspert
16. marts 2007 - 22:32 #3
Du kan også lave det sådan her:

<?php
//Hent tingene fra databasen

$offset = is_numeric($_GET['offset'])?intval($_GET['offset']):0;

//Lav et udtræk med $offset...

$plus  = $offset + 1;
$minut = $offset + 1;

echo '<a href="'.$_SERVER['PHP_SELF'].'?offset='.$minus.'"><--</a>&nbsp;|&nbsp;<a href="'.$_SERVER['PHP_SELF'].'?offset='.$plus.'">--></a>';
?>
Avatar billede showsource Seniormester
17. marts 2007 - 12:34 #4
et bud, utestet

<?php

$udregning =  array("plus" => "+1", "minus" => "-1");

if(isset($_POST["udregn"]) && isset($udregning[$_POST["udregn"]])) {

$sql = "UPDATE tabel SET tal = tal". $udregning[$_POST["udregn"]] ." WHERE id = 'noget'";

echo $sql;
echo"<p>";
}

?>
<form action="/index.php" method="post">
<input type="radio" name="udregn" value="minus"> Træk fra<br>
<input type="radio" name="udregn" value="plus"> Læg til<br>
<input type="submit">
</form>
Avatar billede darkstardk Nybegynder
17. marts 2007 - 13:53 #5
Okay, kan ligeså godt erkende det :) det der med at kode php på den måde i gør er jeg ik helt inde i, jeg bruger dreamweaver og dens interface, så det er lidt svært at få sat det i har skrevet derind i, hvis der er en venlig sjæl der vil kigge på min side og så komme med et forslag vil jeg blive meget glad..

<?php require_once('../Connections/mysqll.php'); ?>
<?php
mysql_select_db($database_mysqll, $mysqll);
$query_Recordset1 = "SELECT * FROM bank";
$Recordset1 = mysql_query($query_Recordset1, $mysqll) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>WoW Bank</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
    background-color: #333333;
}
body,td,th {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 12px;
    color: #0066CC;
}
-->
</style></head>

<body>
<div align="center">
  <table width="30%" height="500" align="left" >
    <tr>
      <td colspan="4"><h1>Bank:</h1></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_VoidCrystal.jpg" width="32" height="32"></div></td>
      <td width="180" rowspan="2" valign="bottom">Void Crystal: </td>
      <td width="47" rowspan="2" valign="bottom"><?php echo $row_Recordset1['Void Crystal']; ?></td>
      <td width="27">        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardPrismaticLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Large Prismatic Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Large Prismatic Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardPrismaticSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Small Prismatic Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Small Prismatic Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceArcaneLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Greater Planar Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Greater Planar Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceArcaneSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Lesser Planar Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Lesser Planar essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" height="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardNexusLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Nexus Crystal: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Nexus Crystal']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" height="32" rowspan="2"><div align="center"><img src="INV_Enchant_DustArcane.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Arcane Dust: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Arcane Dust']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardBrilliantLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Large Brilliant Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Large Brilliant Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceEternalLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Greater Eternal Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Greater Eternal Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardBrilliantSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Small Brilliant Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Small Brilliant Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><img src="INV_Enchant_EssenceEternalSmall.jpg" width="32" height="32"></td>
      <td rowspan="2" valign="bottom">Lesser Eternal Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Lesser Eternal Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardRadientLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Large Radiant Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Large Radiant Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceNetherLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Greater Nether Essence:</td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Greater Nether Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_DustDream.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Dream Dust: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Dream Dust']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardRadientSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Small Radiant Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Small Radiant Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceNetherSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Lesser Nether Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Lesser Nether Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceMysticalLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Greater Mystic Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Greater Mystic Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_DustVision.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Vision Dust: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Vision Dust']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardGlowingSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Small Glowing Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Small Glowing Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceMysticalSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Lesser Mystic Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Lesser Mystic Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardGlimmeringLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Large Glimmering Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Large Glimmering Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceAstralLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Greater Astral Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Greater Astral Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="2B2B2B">
      <td width="32" rowspan="2" bgcolor="#2B2B2B"><div align="center"><img src="INV_Enchant_DustSoul.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom" bgcolor="#2B2B2B">Soul Dust: </td>
      <td rowspan="2" valign="bottom" bgcolor="#2B2B2B"><?php echo $row_Recordset1['Soul Dust']; ?></td>
      <td bgcolor="#2B2B2B">
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_ShardGlimmeringSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Small Glimmering Shard: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Small Glimmering Shard']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceAstralSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Lesser Astral Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Lesser Astral Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceMagicLarge.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Greater Magic Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Greater Magic Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_EssenceMagicSmall.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Lesser Magic Essence: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Lesser Magic Essence']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"><img src="INV_Enchant_DustStrange.jpg" width="32" height="32"></div></td>
      <td rowspan="2" valign="bottom">Strange Dust: </td>
      <td rowspan="2" valign="bottom"><?php echo $row_Recordset1['Strange Dust']; ?></td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
  </table>
  <table width="30%" height="500" align="center" >
    <tr>
      <td colspan="4"><h1>&nbsp;</h1></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td width="52%" rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td width="11%">
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" height="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" height="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2"><div align="center"></div></td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="2B2B2B">
      <td width="32" rowspan="2" bgcolor="#2B2B2B">&nbsp;</td>
      <td rowspan="2" valign="bottom" bgcolor="#2B2B2B">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom" bgcolor="#2B2B2B">&nbsp;</td>
      <td bgcolor="#2B2B2B">
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr bgcolor="#2B2B2B">
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td bgcolor="#2B2B2B"><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td width="32" rowspan="2">&nbsp;</td>
      <td rowspan="2" valign="bottom">&nbsp;</td>
      <td width="47" rowspan="2" valign="bottom">&nbsp;</td>
      <td>
        <div align="center"><img src="plus.gif" width="15" height="14"></div></td>
    </tr>
    <tr>
      <td><div align="center"><img src="minus.gif" width="15" height="14"></div></td>
    </tr>
  </table>
</div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>


CREATE TABLE `bank` (
  `Large Brilliant Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Nexus Crystal` varchar(100) collate latin1_general_ci NOT NULL,
  `Small Brilliant Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Large Glimmering Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Large Radiant Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Greater Eternal Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Illusion Dust` varchar(100) collate latin1_general_ci NOT NULL,
  `Soul Dust` varchar(100) collate latin1_general_ci NOT NULL,
  `Greater Mystic Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Lesser Mystic Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Vision Dust` varchar(100) collate latin1_general_ci NOT NULL,
  `Dream Dust` varchar(100) collate latin1_general_ci NOT NULL,
  `Arcane Dust` varchar(100) collate latin1_general_ci NOT NULL,
  `Greater Planar Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Lesser Planar essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Large Prismatic Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Small Prismatic Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Dreaming Glory` varchar(100) collate latin1_general_ci NOT NULL,
  `Felweed` varchar(100) collate latin1_general_ci NOT NULL,
  `Ancient Lichen` varchar(100) collate latin1_general_ci NOT NULL,
  `Terocone` varchar(100) collate latin1_general_ci NOT NULL,
  `Nightmare Vine` varchar(100) collate latin1_general_ci NOT NULL,
  `Netherbloom` varchar(100) collate latin1_general_ci NOT NULL,
  `Ragveil` varchar(100) collate latin1_general_ci NOT NULL,
  `Mana Thistle` varchar(100) collate latin1_general_ci NOT NULL,
  `Fel Lotus` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Might` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Water` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Mana` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Life` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Fire` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Shadow` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Water` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Mana` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Life` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Fire` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Shadow` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Air` varchar(100) collate latin1_general_ci NOT NULL,
  `Mote of Earth` varchar(100) collate latin1_general_ci NOT NULL,
  `Glowcap` varchar(100) collate latin1_general_ci NOT NULL,
  `Netherweave Cloth` varchar(100) collate latin1_general_ci NOT NULL,
  `Runecloth` varchar(100) collate latin1_general_ci NOT NULL,
  `Flame Cap` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Earth` varchar(100) collate latin1_general_ci NOT NULL,
  `Primal Air` varchar(100) collate latin1_general_ci NOT NULL,
  `Void Crystal` tinyint(100) NOT NULL,
  `Lesser Eternal Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Greater Nether Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Small Radiant Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Lesser Nether Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Small Glowing Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Greater Astral Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Small Glimmering Shard` varchar(100) collate latin1_general_ci NOT NULL,
  `Lesser Astral Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Greater Magic Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Lesser Magic Essence` varchar(100) collate latin1_general_ci NOT NULL,
  `Strange Dust` varchar(100) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Avatar billede darkstardk Nybegynder
17. marts 2007 - 13:56 #6
self skal i ik gøre det for allesammen, kan jeg godt selv bare jeg forstår princippet, og mener os min database skal være INT måske da det jo er tal
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Webudvikling kurser
Vi tilbyder markedets bedste kurser inden for webudvikling
Se alle Webudvikling kurser

Flere spørgsmål fra PHP kategorien

Titel Indlæg Oprettet Seneste aktivitet
Datafordeler Af Lsk i PHP 2 01/11/202422:00 02/11/202409:30
Datoformat ved eksport til Excel Af dane022 i PHP 8 17/09/202414:48 30/09/202419:55
Hjælp til PHP ( mener jeg det hedder) Af lurup i PHP 0 12/09/202423:39 -
wp_delete_user virker ikke i Wordpress Af Ravnsen i PHP 2 21/08/202417:53 21/08/202422:03
php driller Af moscov i PHP 1 19/08/202415:09 20/08/202421:24
Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Opret Log ind

Du kan også logge ind via nedenstående tjenester



Alle kategorier på Eksperten
Seneste spørgsmål Seneste aktivitet
I dag 18:09 Billedoverførsel Af Laurids i iOS, iPhone & iPad
I dag 13:30 Hvordan ændres UniFi Dream Machine UDM til switch mode Af Kasper4450 i Internetforbindelser
I dag 13:01 Film går i stå midt i afspilningen Af ole falsted i Musik & videoafspillere
I dag 11:40 Fjerne mappe i stifinder Af Peter Olsen i Andet software
I dag 11:27 renteberegning Af Pil i Excel
White papers
Flere white papers »


Premium
Teaser billede
Vil købe tele-løsninger til det offentlige for 370 millioner kroner
Læs mere »
Efterspørgslen på AI-regnekraft er enorm - og det smitter af på priserne: "Vi kan sælge næsten alt, hvad vi får ind"
Nyt værtøj fra Microsoft: Snart kan du reparere nedbrudte Windows-enheder på distancen
Politiet skriver kontrakt på 75 millioner kroner med dansk it-firma: Medarbejdere skal flytte ind hos politiet
Se alle »
Computerworld
Teaser billede
Microsofts nye pc er ekstrem billig – men kan blive ekstrem sikker og fleksibel
Læs mere »
Test: Prøv kun disse B&O-hovedtelefoner, hvis du har råd
Kæmpe datalæk på hospital: 750.000 patienters fortrolige data lækket
Telegigant klar med AI-baseret mormor: Holder telefon-svindlere fast i røret med sniksnak og dumme spørgsmål
Se alle »
CIO
Teaser billede
Konsulenthus vil rulle Microsoft 365 Copilot ud til 200.000 ansatte
Læs mere »
Kæmpe-opgave for Danske Bank har banet vej for fuldautomatiseret migrering til cloud: Nu udbredes metoden i hele AWS
Microsofts store årlige event: De tre vigtigste nøglebudskaber fra Satya Nadella om Microsofts fremtid
Tre vigtige erkendelser, som Computerworld tog med hjem fra Gartners store topmøde i Barcelona
Se alle »
Job & Karriere
Teaser billede
Microsoft klar med ny direktion for den danske forretning: Her er de nye direktører
Læs mere »
Efter skelsættende møde med sportscoach: Stor dansk it-arbejdsplads indfører fredags-fri og isbade i arbejdstiden
Linus Torvalds giver russiske Linux-udviklere sparket: Vil ikke have noget med dem at gøre
Topchef Sara Green mener, at der er brug for et radikalt nyt syn på it-ledelse - særligt én ny trend hader hun som pesten
Se alle »
White paper
Teaser billede
Sikkerhed uden grænser: Cisco Hypershield
Læs mere »
MDR: Transparent sikkerhed og overvågning i realtid
SMB og cybertrusler: Brug sikkerhedsressourcerne optimalt
Er din cybersikkerhed klar til AI-revolutionen?
Se alle »

Events
Flere events »
White papers
Flere white papers »
IT-Kurser
Se alle vores it-kurser »