Working with PHP and MYSQL

johntp · July 31, 2008

Hey guys,

I'm trying to pull all data from a few tables, and running into a problem, here is my code:

<?php 
else
{
$query30 = "SELECT * FROM clean.users WHERE clean.users.Username = '$user'";
$query31 = "SELECT * FROM clean.medical WHERE clean.medical.EmployeeID = '$Employee'";
$query32 = "SELECT * FROM clean.vehicle1 WHERE clean.vehicle1.EmployeeID = '$Employee'";
$query33 = "SELECT * FROM clean.vehicle2 WHERE clean.vehicle2.EmployeeID = '$Employee'";
$query34 = "SELECT * FROM clean.vehicle3 WHERE clean.vehicle3.EmployeeID = '$Employee'";
$query35 = "SELECT * FROM clean.vehicle4 WHERE clean.vehicle4.EmployeeID = '$Employee'";
$result30 = mysql_query($query30);
$result31 = mysql_query($query31);
$result32 = mysql_query($query32);
$result33 = mysql_query($query33);
$result34 = mysql_query($query34);
$result35 = mysql_query($query35);
while($row30 = mysql_fetch_array($result30, MYSQL_ASSOC) or 
$row31 = mysql_fetch_array($result31, MYSQL_ASSOC) or
$row32 = mysql_fetch_array($result32, MYSQL_ASSOC) or
$row33 = mysql_fetch_array($result33, MYSQL_ASSOC) or
$row34 = mysql_fetch_array($result34, MYSQL_ASSOC) or
$row35 = mysql_fetch_array($result35, MYSQL_ASSOC))
{
echo "<table width='795' border='0' align='center'>
  <tr>
    <td colspan='2'><div align='center'>
      <p><strong>Please remember that all information will be viewed only by HR, and Saftey Supervisors.    </strong></p>
      <p>   </p>
    </div>      </td>
  </tr>
  <tr>
    <td width='421' valign='top'><table width='406' border='0'>
      <tr>
        <td colspan='2'><div align='left'><strong>Basic Information </strong></div></td>
      </tr>
      <tr>
        <td width='158'><div align='left'>First Name: </div></td>
        <td width='238'><div align='left'>{$row30['Firstname']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Last Name: </div></td>
        <td><div align='left'>{$row30[Lastname]}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Supervisor:</div></td>
        <td><div align='left'>{$row30['Supervisor']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Employee Status: </div></td>
        <td><div align='left'>{$row30['Status']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Employee Number: </div>         </td>
        <td><div align='left'>{$row30['EmployeeID']}</div></td>
      </tr>
      <tr>
        <td colspan='2'><div align='left'><br></div></td>
      </tr>
      <tr>
        <td colspan='2'><div align='left'><strong>Medical/Emergency Information </strong></div></td>
      </tr>
      <tr>
        <td><div align='left'>Medical Issues / Meds:</div></td>
        <td><div align='left'>{$row31['Issues']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Medications:</div></td>
        <td><div align='left'>{$row31['Medications']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Allergies:</div></td>
        <td><div align='left'>{$row31['Allergies']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Emergency Contact::</div></td>
        <td><div align='left'>{$row31['Contact1Name']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number::</div></td>
        <td><div align='left'>{$row31['Contact1Phone']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number 2:</div></td>
        <td><div align='left'>{$row31['Contact1Phone2']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Emergency Contact - 2:</div></td>
        <td><div align='left'>{$row31['Contact2Name']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number:</div></td>
        <td><div align='left'>{$row31['Contact2Phone']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number 2:</div></td>
        <td><div align='left'>{$row31['Contact2Phone2']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Emergency Contact 3:</div></td>
        <td><div align='left'>{$row31['Contact3Name']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number:</div></td>
        <td><div align='left'>{$row31['Contact3Phone']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number  2:</div></td>
        <td><div align='left'>{$row31['Contact3Phone2']}</div></td>
      </tr>
      
      

    </table></td>
    <td width='364'><table width='349' border='0' align='left'>
      <tr>
        <td colspan='2'><div align='left'><strong>Vehicle Information</strong> </div></td>
        </tr>
      <tr>
        <td width='117'><div align='left'><strong>Car #1:</strong></div></td>
        <td width='222'><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'>License:</div></td>
        <td><div align='left'>{$row32['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Make:</div></td>
        <td><div align='left'>{$row32['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Color:</div></td>
        <td><div align='left'>{$row32['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Model:</div></td>
        <td><div align='left'>{$row32['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Year:</div></td>
        <td><div align='left'>{$row32['Year']}</div></td>
      </tr>
      
      <tr>
        <td><div align='left'><strong>Car #2</strong></div></td>
        <td><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'>License:</div></td>
        <td><div align='left'>{$row33['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Make:</div></td>
        <td><div align='left'>{$row33['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Color:</div></td>
        <td><div align='left'>{$row33['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Model:</div></td>
        <td><div align='left'>{$row33['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Year:</div></td>
        <td><div align='left'>{$row33['Year']}</div></td>
      </tr>
      
      <tr>
        <td><div align='left'><strong>Car #3</strong></div></td>
        <td><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'> License:</div></td>
        <td><div align='left'>{$row34['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Make:</div></td>
        <td><div align='left'>{$row34['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Color : </div></td>
        <td><div align='left'>{$row34['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Model:</div></td>
        <td><div align='left'>{$row34['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Year:</div></td>
        <td><div align='left'>{$row34['Year']}</div></td>
      </tr>
      
      <tr>
        <td><div align='left'><strong>Car #4</strong></div></td>
        <td><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'> License:</div></td>
        <td><div align='left'>{$row35['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Make:</div></td>
        <td><div align='left'>{$row35['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Color:</div></td>
        <td><div align='left'>{$row35['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Model:</div></td>
        <td><div align='left'>{$row35['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Year:</div></td>
        <td><div align='left'>{$row35['Year']}</div></td>
      </tr>
      

    </table></td>
  </tr>
</table>";
}
}
?>

Instead of it displaying in one HTML table, it duplicates the HTML table and each of the mysql tables are in seperate html tables. I really suck at explaining but what i need is for this to include all the tables and if there is no information in them, then skip it. I thought the or would work, wich it kinda does, but everything isn't together like it should be.

trq · July 31, 2008

In the tutorial section of our main site is a tutorial on JOINS, Id suggest you have a read.

Sign In

Working with PHP and MYSQL

Recommended Posts

johntp

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information