Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $szerver = "localhost";
- $felh = "root";
- $jelsz = "usbw";
- mysql_connect($szerver, $felh, $jelsz);
- @mysql_select_db("hiroldal") or die(mysql_error);
- /* max szo */
- $sqlmaxszo = "SELECT cim, cikk, datum, MAX(szoszam) AS max FROM hirek";
- $kiszed1 = mysql_query($sqlmaxszo);
- if (!$kiszed1)
- {
- $message = 'Invalid query: ' . mysql_error() . "\n";
- $message .= 'Whole query: ' . $kiszed1;
- die($message);
- }
- while ($sor = mysql_fetch_assoc($kiszed1))
- {
- echo "Cím: " . $sor["cim"]. " Cikk: " . $sor["cikk"]. " " . $sor["datum"]. "<br>";
- }
- mysql_free_result($kiszed1);
- /*napi karakter atlag*/
- $sqlnapikaratlag = "SELECT AVG(karakter) AS atlagkar, DATE(datum) AS datum FROM hirek GROUP BY DATE(datum) ORDER BY datum";
- $kiszed2 = mysql_query($sqlnapikaratlag);
- /*if (!$kiszed2)
- {
- $message = 'Invalid query: ' . mysql_error() . "\n";
- $message .= 'Whole query: ' . $kiszed2;
- die($message);
- }*/
- if ($kiszed2->num_rows > 0)
- {
- while ($sor2 = mysql_fetch_assoc($kiszed2))
- {
- echo "Nap: " . $sor2["datum"]. " Átlag karakter: " . $sor2["atlagkar"]. "<br>";
- }
- }
- mysql_free_result($kiszed2);
- /*napi cikkszám*/
- $sqlnapicikkszam = "SELECT COUNT(*) AS napicikkszam, DATE(datum) AS datum FROM hirek GROUP BY DATE(datum) ORDER BY datum";
- $kiszed3 = mysql_query($sqlnapicikkszam);
- if ($kiszed3->num_rows > 0)
- {
- while ($sor3 = mysql_fetch_assoc($kiszed3))
- {
- echo "Nap: " . $sor3["datum"]. " Napi cikkszám: " . $sor3["napicikkszam"]. "<br>";
- }
- }
- mysql_free_result($kiszed3);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement