r2ks

Code Post, <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("test_cal", $con); $result = mysql_query("SELECT * FROM patient,room,treatment WHERE room.idPatient = patient.idPatient "); echo "<table border='1'> <tr> <th>Firstname</th> <th>Lastname</th> <th>Room Number</th> <th>8:30 am</th> <th>9:30 am</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['PtFirstName'] . "</td>"; echo "<td>" . $row['PtLastName'] . "</td>"; echo "<td>" . $row['RoomNum'] . "</td>"; echo "<td>". $row ['TreatmentType']. "</td>"; echo "<td>" . $row ['TreatmentType']. "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?>

Nice Jessica, I did not ask you about Dreamweaver .... and what was this Statment you wrote "Also, in the future, answer ALL of the questions people ask you." Do not Correct me and then do the same thing.. if you do not want to help me or give me helpful information then do not repond to my post I did not come here for some one to Bust my Balls...I am looking for Help..

Good Evening,Jessica. I apologize I thought in my last Post I did reply. However it did not go thorough. Yes lemmin That is correct please see the attached screen shot. Jessica, I would past code however I am using Dreamweaver CS5 for the beging of this. I have 4 Tables patient room datetime Treatment My question would be that how would I go about getting said treatment to populate under a 9:30 Cell. PTid is the primary Key in the Patient Tabel and I am Linking all the Tabels back to that PtID Thank You I am not Asking any one to do this for me just point me in the right direction.. Please see Screen Shot

PtFirstName RoomNum 8:00 8:30 9:00 9:30 10:00 11:00 11:30 12:00 Dan,Mcnulty 303 Mike,Smith 304 Mike,Smith 304 Mike,jones 306

I have a Table. Name and Room Number is being pulled from a database, I would also like some other Placed in time cells where would I begin? so for example, Dan Dallas has Labs at 10:00 and CT at 12:00. I would like the word lab to appear in the 10:00 cell and CT in the 12:00 cell PtFirstName RoomNum 8:00 8:30 9:00 9:30 10:00 11:00 11:30 12:00 Dan,Dallas 303 Mike,Smith 304 Mike,Smith 304 Mike,jones 306

I am not sure were to begin I am not asking anyone to do this for me by all means. I just need a starting point I would like to create a program that has resources such as Rooms to the left and a time line at the top. Please see attachment. any help would to get me started would be great.