php - MySQL List all entries and sort by ID -


somehow can't list mysql entries id. result error if try sort id:

notice: undefined variable: url_bild in /users/fatih/sites/phpform/neu/adressen-anzeigen.php on line 66` notice: undefined variable: title in /users/fatih/sites/phpform/neu/adressen-anzeigen.php on line 68`

my code:

<?php require_once ('konfiguration.php'); // nutzen von datenbank (name ist hinterlegt in konstante mysql_datenbank $db_sel = mysql_select_db( mysql_datenbank ) or die("auswahl der datenbank fehlgeschlagen"); $sql = " select * adressbuch order id asc"; $db_erg = mysql_query( $sql ); if ( ! $db_erg ) { die('ungültige abfrage: ' . mysql_error()); } while ($zeile = mysql_fetch_array( $db_erg, mysql_assoc)) { $title = $zeile['title']; $description = $zeile['description']; $applepart = $zeile['applepart']; $partnumber = $zeile['partnumber']; $productcode = $zeile['productcode']; $compatibility = $zeile['compatibility']; $url_bild = $zeile['url_bild']; $price = $zeile['price']; } mysql_free_result( $db_erg ); echo "<table id=\"products\" border=\"0\">"; echo "<tr>"; if ( $url_bild <> "" ) { echo "<td class=\"thumbnail\"><img src=\"$url_bild\" /></td>"; } echo "<td class=\"description\"><h1>$title</h1>"; echo "<p>$description</p>"; echo "<table border=\"0\">"; echo "<tr>"; echo "<td class=\"applepart\">apple part#:</td>"; echo "<td class=\"first\">$applepart</td>"; echo "<td class=\"second\">&nbsp;</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"partnumbers\">part numbers:</td>"; echo "<td class=\"first\">$partnumber</td>"; echo "<td class=\"second\">&nbsp;</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"productcode\">product code:</td>"; echo "<td class=\"first\">$productcode</td>"; echo "<td class=\"second\">&nbsp;</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"compatibility\">compatibility:</td>"; echo "<td class=\"first\">$compatibility</td>"; echo "<td class=\"second\"></td>"; echo "</tr>"; echo "</table>"; echo "</td>"; echo "<td class=\"price\"><h1>$price</h1></td>"; echo "</tr>"; echo "</table>"; ?>

if set select * adressbuch last entry.

fixed:

echo "<table id=\"products\" border=\"0\">"; while ($zeile = mysql_fetch_array( $db_erg, mysql_assoc)) { $title = $zeile['title']; $description = $zeile['description']; $applepart = $zeile['applepart']; $partnumber = $zeile['partnumber']; $productcode = $zeile['productcode']; $compatibility = $zeile['compatibility']; $url_bild = $zeile['url_bild']; $price = $zeile['price']; echo "<tr>"; if ( $url_bild <> "" ) { echo "<td class=\"thumbnail\"><img src=\"$url_bild\" /></td>"; } echo "<td class=\"description\"><h1>$title</h1>"; echo "<p>$description</p>"; echo "<table border=\"0\">"; echo "<tr>"; echo "<td class=\"applepart\">apple part#:</td>"; echo "<td class=\"first\">$applepart</td>"; echo "<td class=\"second\">&nbsp;</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"partnumbers\">part numbers:</td>"; echo "<td class=\"first\">$partnumber</td>"; echo "<td class=\"second\">&nbsp;</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"productcode\">product code:</td>"; echo "<td class=\"first\">$productcode</td>"; echo "<td class=\"second\">&nbsp;</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"compatibility\">compatibility:</td>"; echo "<td class=\"first\">$compatibility</td>"; echo "<td class=\"second\"></td>"; echo "</tr>"; echo "</table>"; echo "</td>"; echo "<td class=\"price\"><h1>$price</h1></td>"; echo "</tr>"; } echo "</table>"; mysql_free_result( $db_erg ); ?>

Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

c++ - Accessing inactive union member and undefined behavior? -

i under impression accessing union member other last 1 set ub, can't seem find solid reference (other answers claiming it's ub without support standard). so, undefined behavior? the confusion c explicitly permits type-punning through union, whereas c++ ( c++11 ) has no such permission. c11 6.5.2.3 structure , union members 95) if member used read contents of union object not same member last used store value in object, appropriate part of object representation of value reinterpreted object representation in new type described in 6.2.6 (a process called ‘‘type punning’’). might trap representation. the situation c++: c++11 9.5 unions [class.union] in union, @ 1 of non-static data members can active @ time, is, value of @ 1 of non-static data members can stored in union @ time. c++ later has language permitting use of unions containing struct s common initial sequences; doesn't permit type-punning. to determine whether union type-punning is allowe...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more