Problem displaying query

Anon

I need to know why my query doesn't display properly....the query is correct but maybe the array is not displaying all of the records...I have looked at all of the help pages but still am lost on this.....any help would be great....

thanks


<!DOCTYPE HTML PUBLIC "-//SoftQuad Software//DTD HoTMetaL PRO 6.0::19990601::extensions to HTML 4.0//EN" "hmpro6.dtd">

  <HEAD> 
	 <TITLE>Fiche Database results</TITLE> 
  </HEAD> 
  <BODY> 
	 <P ALIGN="center"><IMG BORDER="0" SRC="FicheDatabase.jpg" WIDTH="632"
		HEIGHT="121"></P> 

<table border="0" width="98%" cellpadding="0">
<tr>
<td width="10%" bordercolor="#FFFFFF"> <img border="0" src="CaseName.jpg"
	 width="85" height="51"></td>
<td width="17% bordercolor="#FFFFFF"> <img border="0" src="casenumber.jpg"
	 width="77" height="51"></td>
<td width="11%" bordercolor="#FFFFFF"> <img border="0" src="DateFilied.jpg"
	 width="86" height="51"></td>
<td width="13%" bordercolor="#FFFFFF"> <img border="0" src="DateTerminated.jpg"
	 width="82" height="51"></td>
<td width="11%" bordercolor="#FFFFFF"> <img border="0" src="DateReOpened.jpg"
	 width="81" height="51"></td>
<td width="12%" bordercolor="#FFFFFF"> <img border="0" src="PartyName.jpg" 
 	 width="85" height="51"></td>
<td width="12%" bordercolor="3FFFFFF"> <img border="0" src="PartyType.jpg"
	 width="74" height="51">
</td>
<td width="12%" bordercolor="#FFFFFF">
<img border="0" src="JudgeInintals.jpg" width="79" height="51"></td>
</tr>
</table>	 


 <?PHP 

mysql_connect (localhost, user, password);

$database="fichedb";
@mysql_select_db("$database") or die("Unable to select database");


$result=mysql_query("Select case.CaseNo,case.CaseName,case.DateFiled,
case.DateTermed,case.DateReopen,judge.Initials,party.PartyName,party.PartyType
  from case, judge, party
  where (judge.Initials like '$Initials' or case.CaseNo like '$CaseNo' or party.PartyName like '$PartyName')
 and (case.aocode=judge.ao_code and case.CaseNo=party.CaseNum)");


if($row=mysql_fetch_row($result)) {

do {


print "<table border=2 width=98%>";
print "<tr><td width=10%>$row["CaseNo"]</td><td width=15%>$row["CaseName"]</td><td width=12%>$row["DateFiled"]</td><td width=12%>$row["DateTermed"]</td><td width=12%>$row["DateReopen"]</td><td width=9$>$row["PartyName"]</td><td width=13%>$row["PartyType"]</td><td width=13%>$row["Initials"]</td></tr></table>\n";



} while ($row=mysql_fetch_row($result));

} else {
print "there were no results";
} 



?>
<p>
<p align="center"><a href="Fische.html"><img border="0" src="NewQuery.jpg" width="446" height="125"></a></p>

<Center>Click if you would like to perform a new query</center>

<br>
<p>		 
</BODY>

Anon

Humm. may be

have you CR in your query ?
if yes it doesn't work sometimes

Anon

I am not familiar with CR?

Anon

Cariage return

have press ENTER between your 2 quote of the query

Anon

I tried that and now I get something on my result page however it is just blank cells.....

Anon

one

use mysql_db_query almost select base on query it (just my opinion)

two

use echo function and not print (i see somewhere it's better)

tree

when you do lot of echo, you can close the PhP tag ?>
so replace:
print "<table border=2 width=98%>";
print "<tr><td width=10%>$row["CaseNo"]</td><td width=15%>$row["CaseName"]</td><td width=12%>$row["DateFiled"]</td><td width=12%>$row["DateTermed"]</td><td width=12%>$row["DateReopen"]</td><td width=9$>$row["PartyName"]</td><td width=13%>$row["PartyType"]</td><td width=13%>$row["Initials"]</td></tr></table>\n";

by
?>
<table border=2 width=98%>
<tr>
<td width=10%><?echo $row["CaseNo"];?></td>
<td width=15%><?echo $row["CaseName"];?></td>
<td width=12%><?echo $row["DateFiled"];?></td>
<td width=12%><?echo $row["DateTermed"];?></td>
<td width=12%><?echo $row["DateReopen"];?></td>
<td width=9$><?echo $row["PartyName"];?></td><td width=13%><?echo $row["PartyType"];?></td>
<td width=13%><?echo $row["Initials"];?></td>
</tr>
</table>

easier to read

four

I thing that named cell in $row is not right,
mysql_fetch_row return array(i Use Php3).
i use number as it:
$row[0] for each cell