mysql_num_row errors

Stu

Hi all.
I'm attempting a project that will allow me to display the fixtures of my football (English football) team for next season. I have the database set up as you can see from this screen shot: http://www.2312.co.uk/united/table2.gif

This screen shot shows the contents of the database table: http://www.2312.co.uk/united/content.gif

I have also populated the table with all the fixtures for next season and have created the following code which I had hoped would display the fixtures in a table with results if entered.

Here is the code I am using:

<?php

$dbhost = "localhost";
$dbusername = "sleyland";
$dbpassword = "GH78By";
$database = "sleyland";

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

$query = "SELECT id, game, opposition, venue FROM fixtures"; 
$result_= mysql_query($query) or die(mysql_error());

echo $query;

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, game, opposition, venue 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>';


?>

I would appreciate any help with this as it is now bugging me senseless!

Cheers
Stu

trooper

The image link does not work

what exactly is the problem?

leandro_sa

why all these extra underscores?!
$query= "SELECT id, game, opposition, venue FROM fixtures";

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

------^
while ($query_data = mysql_fetch_row($result))

{

$id = $query_data[0];

^ ^

Stu

Originally posted by leandro_sa
why all these extra underscores?!
$query= "SELECT id, game, opposition, venue FROM fixtures";

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

^
while ($query_data = mysql_fetch_row($result))

{

$id = $query_data[0];

^ ^

Sorry, that was the forum screwing with my copy and paste job! All fixed now 🙂

Originally posted by trooper
The image link does not work

what exactly is the problem?

GM

My apologies, I put contents.gif rather than content 🙁 The link is now fixed in the original post.

The error message is as follows:

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

This can be seen on the following page: http://www.2312.co.uk/united/displayfixtures4.php

The problem is that I can copy and paste the query directly into phpMyAdmin and it executes perfectly although I was at one time receiving the error that my query was empty 😕

Sorry for not exactly explaining very well!

Stu

DeltaRho2K

<?php 

$dbhost = "localhost"; 
$dbusername = "sleyland"; 
$dbpassword = "GH78By"; 
$database = "sleyland"; 

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

$query = "SELECT id, game, opposition, venue FROM fixtures";  

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

echo $query; 

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>'; 

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>'; 


?>

You have this in there twice:
$query = "SELECT id, game, opposition, venue FROM fixtures";

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

Get rid of the second one, like I have and give that a shot... There is no need to redifine the query, and it may be wreaking havoc... Also get rid of the underscore after the $result part in the one you keep.

Also, your select statement is only querying 4 items, but your array contains 5... You may want to check that too...

Stu

No luck with that code I'm afraid 🙁

The reason I only queried 4 items was to try and rule out any rows that might be causing the problem - obviously forgot to add it back in!

Anything else you can suggest?

khoang82

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

Look at the last line, you have redefine the value of your $result. $result no longer points to a mysql link. It is now a value.

Stu

Originally posted by khoang82
$id = $query_data[0];
$date = $query_data[1];
$opposition = $query_data[2];
$venue = $query_data[3];
$result = $query_data[4];

Look at the last line, you have redefine the value of your $result. $result no longer points to a mysql link. It is now a value.

You are absolutely fantastic!!! Thank you ever so much, that had been bugging me since last weekend. Oh you're a star 🙂

Thanks tons

Stu

DeltaRho2K

That's it! Man that was bugging me, I knew there was something odd about the 5 result array, but couldn't quite put my finger on it...