Mysql Fetch Problem?

[null123]

For some reason this code won't work:

if ($type != "") { 
$Link = mysql_connect($host, $username, $password); 
mysql_select_db('files'); 
$Query = "Select * from file_data WHERE type= '$type' "; 
$Result = mysql_query($Query, $Link); 

print("<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"98%\" id=\"AutoNumber1\">\n"); 
print("<tr>\n"); 
print("<td width=\"36%\" align=\"center\">File Title</td>\n"); 
print("<td width=\"35%\" align=\"center\">Author</td>\n"); 
print("<td width=\"29%\" align=\"center\">Download times</td>\n"); 
print("</tr>\n"); 

while ($Row = mysql_fetch_array ($Result)) { 
$id = $Row['id']; 
$Author = $Row['uname']; 
$dhits = $Row['dhits']; 
print("<td align=center valign=top width=\"36%\"><a href=\"files.php?id='$id'\">$ftitle</a></td>\n"); 
print("<td align=center valign=top width=\"35%\">$Author</td>\n"); 
print("<td align=center valign=top width=\"29%\">$dhits</td>\n"); 
print("</tr>\n"); 
} 
print("</table>\n"); 
exit(); 
}

[matt_4013]

What error are you getting? You need to provide more information than that when you post. Most people don't have time to sit here and read through your code trying to figure out what you're trying to do, then what's actually wrong with it.

Give us as much info as possible, and we'll help 🙂

My first suggestion: change $Result = mysql_query($Query, $Link); to

$Result = mysql_query($Query, $Link) or die(mysql_error());

[Moonglobe]

<?php
if ($type != "") { 
$Link = mysql_connect($host, $username, $password); 
mysql_select_db('files'); 
$Query = "Select * from file_data WHERE type= '$type' "; 
$Result = mysql_query($Query, $Link); 

print("<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"98%\" id=\"AutoNumber1\">\n"); 
print("<tr>\n"); 
print("<td width=\"36%\" align=\"center\">File Title</td>\n"); 
print("<td width=\"35%\" align=\"center\">Author</td>\n"); 
print("<td width=\"29%\" align=\"center\">Download times</td>\n"); 
print("</tr>\n"); 

while ($Row = mysql_fetch_array ($Result)) { 
$id = $Row['id']; 
$Author = $Row['uname']; 
$dhits = $Row['dhits']; 
print("<td align=center valign=top width=\"36%\"><a href=\"files.php?id='$id'\">$ftitle</a></td>\n"); 
print("<td align=center valign=top width=\"35%\">$Author</td>\n"); 
print("<td align=center valign=top width=\"29%\">$dhits</td>\n"); 
print("</tr>\n"); 
} 
print("</table>\n"); 
exit(); 
}
?>

w8 a sec...... checking w/colour..............

can't c nething wrong myself..............but do post the error plz.

[dalecosp]

And do some basic checking in your script. Goes a long way to helping the debug process.

Originally posted by Original Poster, heh

<?php
if ($type != "") {    // how 'bout an else down there, in case it is!! 
$Link = mysql_connect($host, $username, $password); 
if (!$Link) { echo "No link to db, dude!"; }  // check this stuff!!
$db=mysql_select_db('files') or die("couldn't select database!");  //this, too! 
$Query = "Select * from file_data WHERE type= '$type' "; 
$Result = mysql_query($Query, $Link); 
if (!$Result) { echo "Query failed or returned empty!"; } // get the idea??

print("<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"98%\" id=\"AutoNumber1\">\n"); 
print("<tr>\n"); 
print("<td width=\"36%\" align=\"center\">File Title</td>\n"); 
print("<td width=\"35%\" align=\"center\">Author</td>\n"); 
print("<td width=\"29%\" align=\"center\">Download times</td>\n"); 
print("</tr>\n"); 

while ($Row = mysql_fetch_array ($Result)) { 
$id = $Row['id']; 
$Author = $Row['uname']; 
$dhits = $Row['dhits']; 
print("<td align=center valign=top width=\"36%\"><a href=\"files.php?id='$id'\">$ftitle</a></td>\n"); 
print("<td align=center valign=top width=\"35%\">$Author</td>\n"); 
print("<td align=center valign=top width=\"29%\">$dhits</td>\n"); 
print("</tr>\n"); 
} 
print("</table>\n"); 
exit(); 
}
?>

[/B]

HTH,

[null123]

I do not get any error messages (even after I put on the mysql_error() ) which is why I did not provide an error message. It will no display the rules which I see as not going into the while loop. It will display the colums that is after the $type if statement and before the while loop.

[dalecosp]

Seems likely, then, that's the query produced an empty set result. You might try echoing out the value of the $type variable to make certain that it's actually a string that would be found in the type row of your db table....

Just a though 🙂

[null123]

After you said that thing about an empty query I went into the database looked at the row that I was asking it to find something in and founder out that it is suppose to be lookng up Dress Up ($type = "Dress Up"😉 instiead of du ($type = du);

Thanks for all your help and quick replys.