[RESOLVED] mysql_fetch_array($result) returns no values

Dragoon1

I've been staring at this code all night, and I can't see what I'm messing up on, its working fine until

	while($row = mysql_fetch_array($result)){

the $row doesn't return any value from what I've tried.

for example I would take it out of the while loop and then try to echo $row['Date'] and nothing is outputted.

i wish i could be more specific in what was going wrong, but I can't seem to find my error.

Thanks in advance for the help

<?php

session_start();

require("./database.php");

$db = new database();

$user = $_GET['user'];
$inout = $_GET['inout'];
$page = $_GET['page']-1;

if($page = 0)
	$start = 0;
else
	$start = $page + 4;

$rpp = 5;

if($inout == 'Reciever')
	$other = 'sender';
else
	$other = 'reciever';

if($inout == 'Reciever'){
	echo $inout;
	echo $user;
	$result = mysql_query("SELECT * FROM Vir.PM WHERE Reciever='$user' ORDER BY TimeStamp DESC LIMIT $start, $rpp");
	$countresult = mysql_query("SELECT COUNT(*) FROM vir.PM WHERE Reciever='$user'");
}
if($inout == 'Sender'){
	echo $inout;
	echo $user;
	$result = mysql_query("SELECT * FROM Vir.PM WHERE Sender='$user' ORDER BY TimeStamp DESC LIMIT $start, $rpp");
	$countresult = mysql_query("SELECT COUNT(*) FROM vir.PM WHERE Sender='$user'");
}

$issue = mysql_query("SELECT * FROM Vir.users WHERE Alias = '$_SESSION[Alias]'");


$countrow = mysql_fetch_array($countresult);
$col = mysql_fetch_array($issue);

$count = $countrow['COUNT(*)'];

if($_SESSION['LoggedIn'] != TRUE) {
	header('Location: ./login.php');
}

if($_SESSION['LoggedIn'] == TRUE && $col['Admin'] == TRUE) {

echo ("
		<a href='./info.php?user=$user&inout=Reciever&page=1'>Recieved</a> |
		<a href='./info.php?user=$user&inout=Sender&page=1'>Sent</a>
	");

while($row = mysql_fetch_array($result)){

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Info</title>
</head>
<body>
<?php
echo ("<table border=0>
			<tr>
           		<td width=100>$row[$other]</a></td>
				<td width=150>$row[Date]</td>
			</tr>
		</table>	
		<table border=0>
			<tr>
				<td width=250>$row[Subject]</td>
			</tr>
		</table>
		<table border=1>
			<tr>

			<td width=250>$row[Message]</td>
		</tr>
  </table>

  <br>
  <br>
  ");
?>
</body>
<?php
	}
}
if($count/$rpp > 1){
if($_GET['page'] > 1)
	echo "<a href='info.php?user='$user'&inout='$inout'&page=".($_GET['page']-1)."'>prev</a> | ";
for($i = 1; $i <= $count / $rpp + 1; $i ++){
    echo "<a href='info.php?user='$user'&inout='$inout'&page=$i'>$i</a>";
    echo " | ";
}
echo " <a href='info.php?user='$user'&inout='$inout'&page=".($_GET['page']+1)."'>next</a>";
}
?>
</html>

scrupul0us

your table output should be:

echo ('
<table border="0">
	<tr>
		<td width="100"><a href="">'.$row['other'].'</a></td>
		<td width="150">'.$row['date'].'</td>
	</tr>
</table>    

<table border="0">
	<tr>
		<td width="250">'.$row['subject'].'</td>
	</tr>
</table>
<table border="1">
	<tr>
		<td width="250">'.$row['message'].'</td>
	</tr>
</table>
<br/>
<br/>
');

Dragoon1

While I appreciate your input, and changed my table, the problem is that nothing is being outputted past the while statement.

while($row = mysql_fetch_array($result)){

Weedpacket

One thing I can see is that you're trying to output an entire HTML document (doctype, <html>, <head> and all) for every single row, instead of outputting the doctype, <html>, <head>, <body>, and <table> and then starting the loop. In the loop you'd output one row of the table, and after the loop, end the table, add those echo statements, then the </body> and </html> tags.

I've also just looked and you're also attempting to echo some other links before you've added the doctype.

Basically, the HTML you're trying to generate and display is so badly broken at present that it's no wonder it's not displaying properly. Get that sorted out and you'll be able to make progress.

scrupul0us

$issue = mysql_query("SELECT * FROM Vir.users WHERE Alias = '$_SESSION[Alias]'");

try

$issue = mysql_query("SELECT * FROM Vir.users WHERE Alias = '".$_SESSION['Alias']."'");

im also willing to bet all error reporting is off so:

 error_reporting(E_ALL);
 ini_set("display_errors", 1);

at the top of your script

bradgrafelman

scrupul0us;10915605 wrote:

$issue = mysql_query("SELECT * FROM Vir.users WHERE Alias = '$_SESSION[Alias]'");

try

$issue = mysql_query("SELECT * FROM Vir.users WHERE Alias = '".$_SESSION['Alias']."'");

Both are identical in function; if one didn't work, why would the other?

Dragoon1

I've reorganized my code, and applied all suggestions and its still not working. Here it is again. Thanks for the help.

<?php

session_start();

require("./database.php");

$db = new database();

$user = $_GET['user'];
$inout = $_GET['inout'];
$page = $_GET['page']-1;

if($page = 0)
	$start = 0;
else
	$start = $page + 4;

$rpp = 5;

if($inout == 'Reciever')
	$other = 'sender';
else
	$other = 'reciever';

if($inout == 'Reciever'){
	echo $inout;
	echo $user;

	$result = mysql_query("
						  SELECT *
						  FROM Vir.PM 
						  WHERE Reciever='$user' 
						  ORDER BY TimeStamp DESC 
						  LIMIT $start, $rpp");

	$countresult = mysql_query("
								SELECT COUNT(*) 
								FROM vir.PM
								WHERE Reciever='$user'
								");

}
if($inout == 'Sender'){
	echo $inout;
	echo $user;

	$result = mysql_query("
						  SELECT *
						  FROM Vir.PM
						  WHERE Sender='$user'
						  ORDER BY TimeStamp DESC
						  LIMIT $start, $rpp
						  ");

	$countresult = mysql_query("
								SELECT COUNT(*)
								FROM vir.PM
								WHERE Sender='$user'
								");
}

$issue = mysql_query("
					 SELECT *
					 FROM Vir.users
					 WHERE Alias = '$_SESSION[Alias]'
					 ");


$countrow = mysql_fetch_array($countresult);
$col = mysql_fetch_array($issue);

$count = $countrow['COUNT(*)'];

if($_SESSION['LoggedIn'] != TRUE)
	header('Location: ./login.php');

if($_SESSION['LoggedIn'] == TRUE && $col['Admin'] == TRUE) {

	echo ('
			<a href=./info.php?user='.$user.'&inout=Reciever&page=1>Recieved</a> |
			<a href=./info.php?user='.$user.'&inout=Sender&page=1>Sent</a>
		');

?>
<html>
<head>
<title>Info</title>
</head>
<body>
<?php
		while($row = mysql_fetch_array($result)){

		echo 'test';

		echo ('
			  <table border=0>
					<tr>
						<td width=100>'.$row[$other].'</a></td>
						<td width=150>'.$row['Date'].'</td>
					</tr>
				</table>	
				<table border=0>
					<tr>
						<td width=250>'.$row['Subject'].'</td>
					</tr>
				</table>
				<table border=1>
					<tr>

						<td width=250>'.$row['Message'].'</td>
					</tr>
			  </table>

			  <br>
			  <br>
			  ');
	}
}
?>

</body>

<?php

if($count/$rpp > 1){

	if($_GET['page'] > 1)
		echo '<a href=info.php?user='.$user.'&inout='.$inout.'&page='.($_GET['page']-1).'>prev</a> | ';

	for($i = 1; $i <= $count / $rpp + 1; $i ++){

		echo '<a href=info.php?user='.$user.'&inout='.$inout.'&page='.$i.'>'.$i.'</a>';
		echo ' | ';

	}
	echo '<a href=info.php?user='.$user.'&inout='.$inout.'&page='.($_GET['page']+1).'>next</a>';
}
?>
</html>

Dragoon1

Still can't spot my error, any help is appreciated

scrupul0us

im willing to bet it has something todo with all the foolishness you are using to get the row count

just do this:

$count = mysql_num_rows($result);

[man]mysql_num_rows[/man]

then you can get rid of:

-all those $countresult queries
-$countrow = mysql_fetch_array($countresult);
-$count = $countrow['COUNT(*)'];

laserlight

scrupul0us, that will not work since the aim is to find the total number of rows. Selecting COUNT(*) is also usually the correct way to obtain such a count unless one will already be retrieving the rows anyway.

Dragoon1

thanks scrupul0us for all your suggestions

Still having troubles, spare a min and see if you can spot my error plz.

_Si_

Hiya. Stupid question, but are you sure the query is returning any rows? You could try putting a check above your while loop or just running the sql through phpmyadmin or the like.

Well it's worth a look, right? 🙂

Dragoon1

So, I guess I couldn't fetch the $result array outside of the if loop that i defined it in. I just nested my while loop inside of the if loop and have it that way for each if that I made, one for sender, one for receiver

thanks everyone for taking the time to look at it