Hallo
Ich mache eine ganz einfache MySQL Abfrage, bei der ich alle Einträge abfrage.
Diese möchte ich dann auflisten, doch es ignoriert einfach immer den ersten Eintrag.
Warum, weiss ich nicht.
Hier die Date, mit welcher die Abfrage duchgeführt wird:
PHP
<?php
$query = 'select * from seller';
$mysql = mysql_query($query);
$a_seller = mysql_fetch_array($mysql);
while($result = mysql_fetch_array($mysql, MYSQL_ASSOC)) {
echo '<option>'.$result['name'].'</option>';
}
?>Vielleicht die Verbindungsdatei auch noch, doch ich denke, der Fehler liegt nicht da drin.
PHP
<?php
error_reporting(0);
// MySQL Connecting-File
// by white-tiger.ch
$create_db = true;
$create_tb = true;
$fill_tb_with_standard = true;
$db_host = 'localhost';
$db_user = '*********';
$db_pw = '********';
$db_name = '*********';
mysql_connect($db_host, $db_user, $db_pw) or exit('MySQL Connecting Error.');
if($create_db) {
$sql1 = "CREATE DATABASE IF NOT EXISTS $db_name";
mysql_query($sql1) or exit('MySQL database creating error');
}
mysql_select_db($db_name) or exit('MySQL database selecting error');
if($create_tb) {
$sql2 = 'create table if not exists login (
id int primary key auto_increment not null,
user text not null,
password text not null,
rights int not null,
status int default null,
last_login int default null,
logins int default null
)';
mysql_query($sql2) or exit('MySQL couldn create table login');
$sql3 = 'create table if not exists surveys (
id int primary key auto_increment not null,
author int not null,
datum int not null,
shop int not null,
seller int not null,
hello bool not null,
sale text not null,
smile bool not null,
attention text not null,
say int not null,
grade int not null
)';
mysql_query($sql3) or exit('MySQL couldn create table surveys');
$sql4 = 'create table if not exists shops (
id int primary key auto_increment not null,
name text not null,
hub text not null,
area int not null
)';
mysql_query($sql4) or exit('MySQL couldn create table shops');
$sql5 = 'create table if not exists seller (
id int primary key auto_increment not null,
name text not null,
fname text not null,
shop int not null
)';
mysql_query($sql5) or exit('MySQL couldn create table seller');
}
if($fill_tb_with_standard and !file_exists('../conf/mysql')) {
$sql7 = 'INSERT INTO login (
id,
user,
password,
rights,
status,
last_login,
logins
)
VALUES (
NULL, \'admin\', \'0c7540eb7e65b553ec1ba6b20de79608\', \'1\', NULL, NULL, NULL
)';
mysql_query($sql7) or exit('MySQL couldnt fill table login with standard input<br /><br />'.mysql_error());
$handle = fopen('../conf/mysql', 'a+');
fwrite($handle, 'Hello World. xD');
fclose($handle);
}
?>Ausgabe:
<option>Scheidegger</option><option>Rohner</option>
