ich habe ein Problme mit einer Abfrage. Die Abfrage liest die Daten richtig aus, aber springt nicht aus der Schleife, wenn er die Tabbelle vollständig ausgelesen hat
ich verstehe nicht wieso, es sollte eigentlich nicht so sein
- Code: Select all
while ($firstQueryResult = mysql_fetch_object(mysql_query("SELECT * FROM building_inst WHERE `planet_id`='$planetId'"))){
debugDebug("building", "Auslesen der Werte:" );
$building_inst_id = $firstQueryResult->id;
debugDebug("building", "BuildingInstID : $building_inst_id" );
$owner_id = $firstQueryResult->owner_id;
debugDebug("building", "OwnerID : $owner_id" );
$secondQueryResult = mysql_fetch_object(mysql_query("SELECT `player_name` FROM `player` WHERE `user_id`='$owner_id'"));
$owner_name = $secondQueryResult->player_name;
debugDebug("building", "OwnerName : $owner_name " );
$building_id = $firstQueryResult->building_id;
debugDebug("building", "BuildingID : $building_id" );
$secondQueryResult = mysql_fetch_object(mysql_query("SELECT * FROM `building` WHERE `id`='$building_id'"));
$building_name = $secondQueryResult->name;
debugDebug("building", "BuildingName : $building_name" );
$product_id = $secondQueryResult->product_id;
debugDebug("building", "ProductID : $product_id" );
$query = mysql_fetch_object(mysql_query("SELECT `merchandise_id` FROM `product` WHERE `id`='$product_id'"));
$merchandise_id = $query->merchandise_id;
debugDebug("building","Merchandise ID = $merchandise_id");
$secondQueryResult = mysql_fetch_object(mysql_query("SELECT `name` FROM `merchandise` WHERE `id`='$merchandise_id'"));
$product_name = $secondQueryResult->name;
debugDebug("building", "ProductName : $product_name" );
$ausgabe = $ausgabe.("building_inst=$building_inst_id::owner=$owner_name::buidling_type=$building_name::product=$product_name");
debugDebug("building", "Ausgabe : $ausgabe" );
}
debugInfo("building", "$Case von $username geladen" );
exit ($ausgabe);
versteht von euch einer wo das Problem liegt?