Also, the Request_Number field is in both tables (foreign key)
Code: Select all
<?php
$query="SELECT * FROM invoiced_activity, reimbursement_requests WHERE Request_Number='90'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close($link);
$i=0;
while ($i < $num) {
$Name=mysql_result($result,$i,"Name"); // from [invoiced_activity}
$Number=mysql_result($result,$i,"Number"); // from [invoiced_activity}
$unique_ID=mysql_result($result,$i,"unique_ID"); // from [invoiced_activity}
$Total_Invoiced_Amount=mysql_result($result,$i,"Total_Invoiced_Amount"); // from [reimbursement_requests]
$Contractor_Name=mysql_result($result,$i,"Contractor_Name"); // from [reimbursement_requests]
<HTML>
<TABLE BORDER="0">
<TR>
<TH>Name</TH>
<TD><input type="text" name="Name" value="<?php echo $Name; ?>"/></TD>
<TH>Number</TH>
<TD><input type="int" name="Number" size="4" value="<?php echo $Number; ?>" /></TD>
<TH>Unique ID</TH>
<TD><Input type="int" name="Unique_ID" value="<?php echo $Unique_ID; ?>" /></TD>
<TH>Total Invoiced Amount</TH>
<TD><Input type="text" name="Total_invoiced Amount" value="<?php echo $Total_invoiced_Amount; ?>"size="10"/></TD>
<TH>Contractor Name</TH>
<TD><Input type="text" name="Contractor_Name" value="<?php echo $Contractor_Name; ?>"size="10"/></TD>
</TR>
</TABLE>
</HTML>
<?php
++$i;
}
?>
Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in C:\wamp\www\update_test.php on line 4
It should return 3 records(invoices) When I query only on one table only it's fields, it works fine. But wen I try to get data from another, I receive that error.