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
Hent array key Af nemlig i PHP 3 17/05/202415:22 17/05/202416:30
iCal-feed og import til google kalender driller Af nemlig i PHP 11 09/05/202417:49 10/05/202421:28
Adgang til vandaflæsningsdata Af nemlig i PHP 4 22/04/202422:04 30/04/202421:08
Vælg post rækkefølge Af Mojo_dk i PHP 3 06/04/202418:40 07/04/202412:20
Hjælp til PHP Af Friis77 i PHP 5 11/02/202419:58 12/02/202407:55
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 går 00:30 Fejl i Ark Af Morten_Jepsen i Excel
06/0716:56 Kan min mobil hackes Af SBS i Mobiltelefoner
06/0712:56 Forskellige billeder til forskellige skærme ? Af snedker1 i Mac
06/0711:56 Om brug af funktionen sumprodukt Af Erik R i Excel
05/0722:41 Hjælp til at skrive opgave Af Needhelp i Småopgaver
White papers
Flere white papers »


Premium
Teaser billede
Trækker yderligere ud: Først klarhed over kæmpe GDPR-retssag mod Region Syddanmark om flere måneder
Læs mere »
Lovforslag til NIS2 i Danmark er klart: Så omfattende bliver loven - se hele forslaget her
Region Sjælland gør klar til at flytte sit Oracle-miljø i clouden: Søger leverandør til opgaven til 150 millioner kroner
Har købt sin platform fri fra hovedkunde efter færdig-udvikling - nu venter stor-ekspansion til udlandet
Se alle »
Computerworld
Teaser billede
Test: Endelig en skærm der er god til alt - lige fra gaming og underholdning til kontorbrug
Læs mere »
700.000 Linux-systemer kan været truet af ny alvorlig sårbarhed
Nørgaard: Derfor bruger fattigrøvene AI meget mere end de rige svin
Store sager fra BMW i5: Alt er bare perfekt afstemt her
Se alle »
CIO
Teaser billede
Russisk hack af Microsoft er meget større end først antaget
Læs mere »
Halter mange år bagefter: Langsom software-udvikling udfordrer kæmpe digitalt løft af Billund Lufthavn
Efter forbud fra Datatilsynet: Nu ændres data-håndteringen i din kørekort-app
Telmore har fået AI til at udvikle 600 forskellige versioner af sin hjemmeside: Ændrer sig alt efter, hvem du er
Se alle »
Job & Karriere
Teaser billede
Bo solgte sit software-system for et treciftret millionbeløb: Brugte pengene på at købe 80 medarbejdere til ny storsatsning
Læs mere »
Norlys skal splittes op i fem selskaber: Nu bliver flere ansatte og ledere fyret
Dansk top-profil trækker sig fra Microsoft: Skal være direktør i TDC Erhverv
IBM Danmark skifter ud i sin øverste ledelse - her er den nye direktion
Se alle »
White paper
Teaser billede
Sådan gør du: Elektronisk dokumentudveksling i praksis
Læs mere »
SASE: Træf det rette valg – første gang
Samlet platform sikrer sammenhæng, kontrol og sikkerhed i hybrid cloud
Guide: Sådan udvikler du en moderne netværksstrategi
Se alle »

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