mysql_fetch_row() errors

[Stu]

Hiya folks.

I am trying to create a table containing a list of fixtures and results for the new Premiership season using a MySQL database. I am trying to output everything into a nice table but am getting the following error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.sites/146/site439/web/united/displayfixtures2.php on line 30

Here is the code I am using:

<?php

$dbhost = "***";
$dbusername = "***";
$dbpassword = "***";
$database = "***";

mysql_connect($dbhost, $dbusername, $dbpassword);
mysql_select_db($database);

echo '<table width="100%" border="1" cellpadding="0">';
echo '<tr>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Date';
echo '</td>';
echo '<td width="40%" align="center" bgcolor="FFFFFF">';
echo 'Opposition';
echo '</td>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Home/away';
echo '</td>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Score';
echo '</td>';
echo '</tr>';

$query = "SELECT id, date, opposition, venue, result FROM fixtures";
$result = mysql_query($query);

while ($query_data = mysql_fetch_row($result))

{
	$id = $query_data[0];
	$date = $query_data[1];
	$opposition = $query_data[2];
	$venue = $query_data[3];
	$result = $query_data[4];

echo '<tr>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $date;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $opposition;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $venue;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $result;
echo '</td>';
echo '</tr>';

}

echo '</td>';
echo '</tr>';
echo '</table>';


?>

As far as I can see, that should be working fine but it aint 🙁

If it helps at all, you can see the actual page here: http://www.2312.co.uk/united/displayfixtures2.php

I am willing to bet it is a stupid typo on my part but I can't see where 🙁

Edit: It may also help to note that the database does actually contain information 🙂

Ta for any help 🙂

Stu

[cgraz]

I believe 'date' is a reserved MySQL word, and you're using it as a field name. The problem is with your query, not with your call to mysql_fetch_row(). I'd change

$result = mysql_query($query); 

to

$result = mysql_query($query) or die(mysql_error());

And see what that outputs.

Cgraz

[Stu]

I'm now getting a parse error on that line 🙁

See here: http://www.2312.co.uk/united/displayfixtures2.php

[kevinsequeira]

try this

$query = "SELECT id, date, opposition, venue, result FROM fixtures";
$result = mysql_query($query); 
if(mysql_error()){
  echo mysql_error();
}
if(mysql_num_rows($result)<1){
  echo "no records ";
}

also what was the problem before u changed the code ?
reg
kevin

[stolzyboy]

post the current code you have now and tell us for sure what line the error is on

[Stu]

Error is now:

Parse error: parse error in /home/.sites/146/site439/web/united/displayfixtures2.php on line 27

Here is my current code:

<?php

$dbhost = "***";
$dbusername = "***";
$dbpassword = "***";
$database = "***";

mysql_connect($dbhost, $dbusername, $dbpassword);
mysql_select_db($database);

echo '<table width="100%" border="1" cellpadding="0">';
echo '<tr>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Date';
echo '</td>';
echo '<td width="40%" align="center" bgcolor="FFFFFF">';
echo 'Opposition';
echo '</td>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Home/away';
echo '</td>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Score';
echo '</td>';
echo '</tr>';

$query_=_"SELECT id, date, opposition, venue, result FROM fixtures"; 
$result_=_mysql_query($query)_or_die(mysql_error());

while ($query_data = mysql_fetch_row($result))

{
	$id = $query_data[0];
	$date = $query_data[1];
	$opposition = $query_data[2];
	$venue = $query_data[3];
	$result = $query_data[4];

echo '<tr>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $date;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $opposition;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $venue;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $result;
echo '</td>';
echo '</tr>';

}

echo '</td>';
echo '</tr>';
echo '</table>';


?>

Cheers folks 🙂

[RedDragon]

why are there _?

change

$query_=_"SELECT id, date, opposition, venue, result FROM fixtures";  

 $result_=_myql_query($query)_or_die(mysql_error());

to

$query = "SELECT `id`,`date`,`opposition`,`venue`,`result` FROM `fixtures`";  

 $result = mysql_query($query) or die(mysql_error());

[stolzyboy]

the "_"s are the forums way of screwing with the code

<?
$query = "SELECT id, date, opposition, venue, result FROM fixtures;";   

$result = mysql_query($query) or die(mysql_error());
?>

[trooper]

Are you still getting errors?

[Stu]

Not completely sure what happened the other night. I'm sure I posted but it doesn't seem to have appeared. Anyway, below is the code I am currently using which is giving the error:

Parse error: parse error in /home/.sites/146/site439/web/united/displayfixtures2.php on line 28

<?php

$dbhost = "***";
$dbusername = "***";
$dbpassword = "***";
$database = "***";

mysql_connect($dbhost, $dbusername, $dbpassword);
mysql_select_db($database);

echo '<table width="100%" border="1" cellpadding="0">';
echo '<tr>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Date';
echo '</td>';
echo '<td width="40%" align="center" bgcolor="FFFFFF">';
echo 'Opposition';
echo '</td>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Home/away';
echo '</td>';
echo '<td width="20%" align="center" bgcolor="FFFFFF">';
echo 'Score';
echo '</td>';
echo '</tr>';

$query_= "SELECT id, dateofgame, opposition, venue, result FROM fixtures"; 
$result_= mysql_query($query) or_die(mysql_error());

while ($query_data = mysql_fetch_row($result))

{
	$id = $query_data[0];
	$date = $query_data[1];
	$opposition = $query_data[2];
	$venue = $query_data[3];
	$result = $query_data[4];

echo '<tr>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $date;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $opposition;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $venue;
echo '</td>';
echo '<td width="25%" bgcolor="FFFFFF">';
echo $result;
echo '</td>';
echo '</tr>';

}

echo '</td>';
echo '</tr>';
echo '</table>';


?>

If it is of any help, here is a link to a screen shot I've taken of the table layout: http://www.2312.co.uk/united/table.gif

Thanks for your time

Stu

[trooper]

Is that page completely stand alone or do you include others

GM

[Stu]

Originally posted by trooper
Is that page completely stand alone or do you include others


GM

Completely stand alone 🙂

[Stu]

I've been tinkering with the code and added a or die(mysql_error()) bit to the $result variable and the error it displays is that the query is empty.

This is despite the fact that when I copy and paste the query into phpMyAdmin, it executes successfully!

What's wrong! 🙁