php warning

[minotron]

Hi

I have this code:

Code: Select all

$sql = "SELECT game_id, rival_id, result, h_a, UNIX_TIMESTAMP(datum) AS datum FROM game ORDER BY datum ASC";
$result = mysql_query($sql, $db) or die(mysql_error($db));
if(mysql_num_rows($result) > 0)
{
echo '<table>';
echo '<tr><td>Dátum</td><td>Domáci</td><td>Hostia</td><td>Výsledok</td></tr>';
while($row = mysql_fetch_array($result))  //at this line is the warning
{
extract($row);

It writes me this error: "Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in H:\xampp\htdocs\rozpis.php on line 18"
I can't find problem in this code. Do you know what is bad? Thank you for reply.

[egami]

mysql_error($db)

this should not have any variables..

should be just die ("ERROR: ".mysql_error());

[minotron]

I have changed that, but it still writes the same warning.

[egami]

Code: Select all

$sql = "SELECT game_id, rival_id, result, h_a, UNIX_TIMESTAMP(datum) AS datum FROM game ORDER BY datum ASC";
$result = mysql_query($sql) or die(mysql_error());
$numrow = mysql_num_rows($result);
if($numrow > 0)
  $count = 0;
  while($row = mysql_fetch_array($result)) { 
    $++count;
    if ($count = 15) { // This is so we don't fill the page up.. who knows how many rows you have...
      break;
    }
    echo '<pre>'; print_r($row); echo '</pre>';
  }
} else { 
  echo "QUERY: $sql <br />";
  echo "Found $numrow entries..<br />";
  echo "Try running the above query in your phpMyAdmin or SQL Manager to see if the query works outright<br/>";
}

 

[minotron]

When I run query in phpmyadmin it shows correct values...but when I run it in localhost it shows this message and writes only first row from table...and when I changed it so how you have written it, it showed the same warning...it is very mysterious

[minotron]

and when I try to run:

Code: Select all

echo mysql_num_rows($result)

it writes right value

[egami]

show me your entire script please.

[minotron]

Code: Select all

<?php
include 'connect.inc.php';
include 'header.inc.php';



$mesiace = array("Január", "Február", "Marec", "Apríl", "Máj", "Jún", "Júl", "August", "September", "Október", "November", "December");

echo '<div id="rozpis">';
$sql = "SELECT game_id, rival_id, result, h_a, UNIX_TIMESTAMP(datum) AS datum FROM game ORDER BY datum ASC";
$result = mysql_query($sql, $db) or die("ERROR: ".mysql_error());
if(mysql_num_rows($result) > 0)
{
echo '<table>';
echo '<tr><td>Dátum</td><td>Domáci</td><td>Hostia</td><td>Výsledok</td></tr>';
while($row = mysql_fetch_array($result))
{
extract($row);
$prikaz = 'SELECT rival_id, name FROM rival WHERE rival_id = '. $rival_id;
$vystup = mysql_query($prikaz, $db) or die(mysql_error($db));
$rival = mysql_fetch_array($vystup);
echo '<tr>';
echo '<td>' .date("j. F Y", $datum). '</td>';
if ($h_a == 1)
{
echo '<td> Capitals </td>';
echo '<td>' .$rival['name']. '</td>';
}
else
{
echo '<td>' .$rival['name']. '</td>';
echo '<td> Capitals </td>';
}
echo '<td><a href="zapas.php?zapas='. $game_id.'">' .$result. '</td>';
echo '</tr>';
}
echo '</table>';
}
else
echo 'No matches';

echo '</div>';

include 'zahlavie.php';
?>

[egami]

first things first..
change the first mysql_fetch_array to mysql_fetch_assoc

You have two SQL calls, and you're trying to extract() names that don't exist.

So change the first one to assoc, and not array, and then try to run it again.. I want to see if the error is calling on the second SQL and not the first.

[minotron]

When I changed the first mysql_fetch_array($result) to mysql_fetch_assoc($result) it had written warning about mysql_fetch_assoc($result) so the problem is in the first one...

[egami]

$sql = "SELECT game_id, rival_id, result, h_a, UNIX_TIMESTAMP(datum) AS datum FROM game ORDER BY datum ASC";

change that to
$sql = "SELECT * FROM game ORDER BY datum ASC";

[minotron]

It writes the same error and now writes else problem with date: Notice: A non well formed numeric value encountered in H:\xampp\htdocs\rozpis.php on line 24 ...it's this line:

Code: Select all

echo '<td>' .date("j. F Y", $datum). '</td>';

[minotron]

I have solved it so, that I deleted: extract($row) and now it goes, thank you for your help