guZz. Mitglied
Angemeldet: 08.08.2004 Beitrge: 583
|
Verfasst am: 24.01.2005, 17:51 Titel:
php mysql Fehler |
|
|
|
|
Hi Leute wollte ma fragen was ich falsch mache
hier is meine pensions_add_do.php4 datei
Code: | <?
include('../global.php4');
#$date = date("j.m.y");
if($_POST['img_large'] != "no")
{
$bild = 'pension_pics/midi/' . $_POST['img_large'];
}
else
{
$bild = "";
}
if($_POST['img_small'] != "no")
{
$thumb = 'pension_pics/thumb/' . $_POST['img_small'];
}
else
{
$thumb = "";
}
$sql = "INSERT INTO
".$_MYSQL['suffx']."pension
(headline, img_large, img_small, strasse , plz, ort, tel, fax, url, bad, haustiere, vpen, hpen, fruehstck, fverleih, tv, message, KAT_ID)
VALUES
('".$_POST['headline']."', '".$bild."', '".$thumb."', '".$_POST['strasse']."', '".$_POST['plz']."', '".$_POST['ort']."', '".$_POST['tel']."', '".$_POST['fax']."', '".$_POST['url']."', '".$_POST['vpen']."', '".$_POST['hpen']."', '".$_POST['fruehstck']."', '".$_POST['fverleih']."', '".$_POST['tv']."', '".$_POST['message']."', '".$_POST['kat_id']."')
";
$q = new Query($sql);
if($q->error())
{
echo $q->getError();
}
else
{
header('Location: '.$_POST['site'].'');
}
?> |
und meine pension_add,php4
Code: |
<?
if(!defined("ACP"))
{
die("Error 1024 :<br>Dateien knnen nicht im einzelnen aufgerufen werden!");
}
if(!isset($_COOKIE['ADMIN']))
{
die("<br><br><br><div align='center'>bka</div>");
}
$sql = "SELECT
*
FROM
".$_MYSQL['suffx']."kat
WHERE
1
ORDER BY ID DESC";
$q = new Query($sql);
if($q->error())
{
echo $q->getError();
}
?>
<link href="../style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.Stil2 {
color: #FFFFFF;
font-size: 10px;
font-weight: bold;
}
-->
</style>
<script src="misc.js" language="Javascript1.2" type="text/javascript"></script>
<script src="stdform.js" language="Javascript1.2"></script>
<form name="frm" method="post" action="pension_add_do.php4">
<p> </p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#666666"><span class="Stil2">Pension Hinzufgen ... </span></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td bgcolor="F6F6F6">Kategorie</td>
<td bgcolor="F6F6F6"><select name="kat_id" class="forumform" id="kat_id" type="select">
<option selected >Bitte whlen</option>
<option >=============</option>
<?
while($row = $q->fetch())
{?>
<option value="<?=$row['ID']?>">
<?=$row['Name']?>
</option>
';
<?}?>
</select></td>
</tr>
<tr>
<td width="11%" bgcolor="F6F6F6">Pension Name: </td>
<td width="89%" bgcolor="F6F6F6"><input name="headline" type="text" class="forumform" id="headline"></td>
</tr>
<tr>
<td bgcolor="F6F6F6">Image Large: </td>
<td bgcolor="F6F6F6"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="94%"><select name="img_large" class="forumform" id="img_large">
<option value="no">Bitte Whlen</option>
<option value="no">=================</option>
<?
$dir = '../pension_pics/midi';
$arr = array();
$dir_handle = opendir($dir);
while ($file = readdir($dir_handle))
if ($file != '.' && $file != '..' && $file != 'thumbs' && $file !='midi')
$arr[] = $file;
closedir($dir_handle);
for ($i = 0; $i < count($arr); $i++)
echo '<option value="'.$arr[$i].'">'.$arr[$i].'</option>';
?>
</select></td>
<td width="6%"><input name="view" type="button" class="forumbtn" value="view!" onClick="window.open('<?=$dir?>/'+document.frm.img_large.value,'Bild','width=400, height=400')"></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="F6F6F6">Image Small </td>
<td bgcolor="F6F6F6"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="94%"><select name="img_small" class="forumform" id="img_small">
<option value="no">Bitte Whlen</option>
<option value="no">=================</option>
<?
$dir = '../pension_pics/thumb';
$arr = array();
$dir_handle = opendir($dir);
while ($file = readdir($dir_handle))
if ($file != '.' && $file != '..' && $file != 'thumbs' && $file !='midi')
$arr[] = $file;
closedir($dir_handle);
for ($i = 0; $i < count($arr); $i++)
echo '<option value="'.$arr[$i].'">'.$arr[$i].'</option>';
?>
</select></td>
<td width="6%"><input name="view" type="button" class="forumbtn" value="view!" onClick="window.open('<?=$dir?>/'+document.frm.img_small.value,'Bild','width=400, height=400')"></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="F6F6F6"><strong><u>Daten</u></strong></td>
<td bgcolor="F6F6F6"> </td>
</tr>
<tr>
<td bgcolor="F6F6F6">Vollpension</td>
<td bgcolor="F6F6F6"><input name="strasse" type="text" class="forumform" id="strasse">
Euro</td>
</tr>
<tr>
<td bgcolor="F6F6F6">Halbpension</td>
<td bgcolor="F6F6F6"><input name="plz" type="text" class="forumform" id="plz">
Euro </td>
</tr>
<tr>
<td bgcolor="F6F6F6">Hauptsaison</td>
<td bgcolor="F6F6F6"><input name="ort" type="text" class="forumform" id="ort">
Euro</td>
</tr>
<tr>
<td bgcolor="F6F6F6"> Nebensaison</td>
<td bgcolor="F6F6F6"><input name="tel" type="text" class="forumform" id="tel">
Euro</td>
</tr>
<tr>
<td bgcolor="F6F6F6"><p>Ermigt</p></td>
<td bgcolor="F6F6F6"><input name="fax" type="text" class="forumform" id="fax">
Euro</td>
</tr>
<tr>
<td bgcolor="F6F6F6">Gre</td>
<td bgcolor="F6F6F6"><input name="url" type="text" class="forumform" id="url">
m²</td>
</tr><tr>
<td bgcolor="F6F6F6"><strong>Bilder</strong></td>
<td bgcolor="F6F6F6"> </td>
</tr><tr>
<td bgcolor="F6F6F6">TV </td>
<td bgcolor="F6F6F6"><input name="url" type="text" class="forumform" id="tv" value="tv.gif">
<font color="#FF0000">ja</font> = <strong>tv.gif</strong> <font color="#00D900">nein</font>
= <strong>tv-no.gif</strong></td>
</tr><tr>
<td bgcolor="F6F6F6">Vollpension</td>
<td bgcolor="F6F6F6"><input name="url" type="text" class="forumform" id="vpen" value="vp.gif">
<font color="#FF0000">ja</font> = <strong>vp.gif</strong> <font color="#00D900">nein</font>
= <strong>vp-no.gif</strong></td>
</tr><tr>
<td bgcolor="F6F6F6">Halbpension</td>
<td bgcolor="F6F6F6"><input name="url" type="text" class="forumform" id="hpen" value="hp.gif">
<font color="#FF0000">ja</font> = <strong>hp.gif</strong> <font color="#00D900">nein</font>
= <strong>hp-no.gif</strong></td>
|
und hier diese fr mich nicht verstndliche fehlermeldung
Zitat: | Anfrage: INSERT INTO wm_pension (headline, img_large, img_small, strasse , plz, ort, tel, fax, url, bad, haustiere, vpen, hpen, fruehstck, fverleih, tv, message, KAT_ID) VALUES ('ff2', 'pension_pics/midi/muster_gross.jpg', 'pension_pics/thumb/muster_klein.jpg', 'fd', 'ff', 'f', 'ff', 'ff', 'fv-no.gif', '', '', '', '', '', '', '222') Antwort: Column count doesn't match value count at row 1 Fehlercode: Column count doesn't match value count at row 1 |
ich hab bei phpMyAdmin alle Felder (headline, img_large, img_small, strasse , plz, ort, tel, fax, url, bad, haustiere, vpen, hpen, fruehstck, fverleih, tv, message, KAT_ID)
hinzugefgt dennoch diese Meldung entdeckt jmd von euch den Fehler
bitte um Hilfe
danke im vorraus! |
|