webdevdea Posted November 8, 2013 Share Posted November 8, 2013 Ok as you all know im still learning after hours of struggling over the sql code, I cannot get it to pull up in php. I have looked over books and sites. I cannot figure out what is wrong with the code. I am getting a 500 error Here is the code if you could give it a once over and see if anything sticks out to you professionals that would be greatly appreciated. $result = mysql_query("SELECT ( d.theCost + r.theCost + n.theCost ) AS TheBIll FROM doctor AS d, account AS a, room AS r, nurse AS n WHERE d.doctorID = a.doctorID AND r.roomID = a.roomID AND n.nurseID = a.nurseID"); echo "<table border='1'> <tr> <th>User Name</th> </tr>"; while($row = mysql_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['TheBill'] "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> Quote Link to comment Share on other sites More sharing options...
Solution webdevdea Posted November 8, 2013 Author Solution Share Posted November 8, 2013 Sorry I have figured this out.. :-) thanks for looking.. stay tuned, i know i will need some help on this big project. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.