Change data color based on a particular search result or value

[eramge11]

Hello everyone,

I want to first apologize for being new to PHP coding. I work for a police department in Ohio and we are currently in the process of coding a database for keeping records of people, property, vehicles, and warrant information. We have attached the database to our personal website so Officer's can access it. Currently it is setup to have a username and password to log into the database. You will then be redirected to a search window in which you can search for all of the data imputed into the system. We found someone who could give us free code and with the permission of the owner altered the code to work for our database. What we need help with that is past my small amount of knowlage in PHP is what to enter into the code to do the following:

1. Officer logs into the system and inputs the search value of social security number "012-34-5678"
2. the person that SSN belongs to in our database we have already entered in has an outstanding arrest warrant with our office.
3. I would like to have the search result show up in "red" instead of "black lettering" or have a red background to alert the officer of the person.

I don't know if this will help but I will attach the search page code below. Any help would be greatly appreciated!!

CODE:

<tr>
		<td align="right">&nbsp;</td>
		<td align="left">&nbsp;</td>
		<td align="right">&nbsp;</td>
		<td align="left">&nbsp;</td>
		<td align="right">&nbsp;</td>
		<td align="right"><br><?php echo $hm->Button(
			array( '<>'=>'</>',
			'name'=>"_sc=_this/search_pb&",
			'src'=>'search',
			'value'=>RSTR_SEARCH,
		) ); ?><br></td>
<td align="right"><br><input name="_sc=_this/search_pxy&amp;_ssc=reg_init&amp;" value="Add New" title="Add New" src="images/buttons/eng/btn_addnew.png" onmouseover="javascript:this.src='images/buttons/eng/btn_addnew_ro.png'" onmouseout="javascript:this.src='images/buttons/eng/btn_addnew.png'" type="image"><br>
	</tr>
<center><B><span style="color:red"</<?php echo $hm->zb('NOTICE TO PEACE OFFICER:'); ?></span></B><span style="color:black"</<?php echo $hm->zb(' A RED DISPLAY WILL APPEAR FOR ANY OF THE FOLLOWING:<br> <b>STOLEN VEHICLE</b> | <b>ARREST WARRANT</b> | <b>ACTIVE PAPER SERVICE</b> | <b>SUBJECT WITH KNOWN VIOLENT TENDENCIES</b>'); ?></span><br><br><br></center>

</table>
</div>

<?php echo $hm->SectEnd(); ?>
<!-- [END] Search Criteria-->

<!-- [BEGIN] Search Result -->
<?php if ( $hm->Zb("def:display?") ) { ?>

<?php echo $hm->SectBegin( RSTR_SEARCH_RESULT ); ?>

<div style='overflow:auto;'>
<table class='data_table'>

	<tr class='data_table_caption'>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:mpd_data_id'); ?>
			<?php echo RSTR_MPD_DATA_ID; ?></th>
		<th><?php include(INC_SR_SELREC_HEADER); ?></th>
		<th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
		<th><?php echo RSTR_ACTIVE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:ssn'); ?> <?php echo RSTR_SSN; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:license_number'); ?> <?php echo RSTR_LICENSE_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:phone_number'); ?> <?php echo RSTR_PHONE_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:license_plate'); ?> <?php echo RSTR_LICENSE_PLATE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:warning_number'); ?> <?php echo RSTR_WARNING_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:citation_number'); ?> <?php echo RSTR_CITATION_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:reporting_officer'); ?> <?php echo RSTR_REPORTING_OFFICER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:date_of_birth'); ?> <?php echo RSTR_DATE_OF_BIRTH; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:call_type'); ?> <?php echo RSTR_CALL_TYPE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:call_nature'); ?> <?php echo RSTR_CALL_NATURE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:vehicle_vin_'); ?> <?php echo RSTR_VEHICLE_VIN_; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_street'); ?> <?php echo RSTR_HOME_STREET; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:p_o_box_apt_'); ?> <?php echo RSTR_P_O_BOX_APT_; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_city'); ?> <?php echo RSTR_HOME_CITY; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_state'); ?> <?php echo RSTR_HOME_STATE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_zip_code'); ?> <?php echo RSTR_HOME_ZIP_CODE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:report_number'); ?> <?php echo RSTR_REPORT_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:date_added'); ?> <?php echo RSTR_DATE_ADDED; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:mpd_paper_service'); ?> <?php echo RSTR_MPD_PAPER_SERVICE; ?></th>
	</tr>

	<?php while( $hm->zb('@rs:def:begin_table') ) { ?>
	<tr>
                <td style='text-align:right;'><?php echo $hm->Zb('rs:def:mpd_data_id'); ?></td>
		<?php include(INC_SR_ID_PARAM); ?>
		<?php include(INC_SR_SELREC); ?>
		<?php include(INC_SR_EDIT_BTN); ?>
		<td style='text-align:center;'><?php echo $hm->Zb('rs:def:active'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:first_name'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:last_name'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:ssn'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:license_number'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:phone_number'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:license_plate'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:warning_number'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:citation_number'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:reporting_officer'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:date_of_birth'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:call_type'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:call_nature'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:vehicle_vin_'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_street'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:p_o_box_apt_'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_city'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_state'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_zip_code'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:report_number'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:date_added'); ?></td>
		<td style='text-align:left;'><?php echo $hm->Zb('rs:def:mpd_paper_service'); ?></td>
	</tr>
	<?php } ?>

</table>
</div>

<?php include(INC_SR_BOTTOM_BAR); ?>

<?php echo $hm->SectEnd(); ?>

<?php } ?>
<!-- [END] Search Result -->

<?php echo $hm->SectEndMarker(); ?>

<?php include(INC_FORM_END); ?>

</div>
<!-- [END] Main Form -->

<?php include(INC_BODY_FOOTER); ?>

</div>
<!-- [END] Container -->

</body>
</html>

<?php include(INC_HTML_END); ?>

[cretaceous]

I'm not impressed by the fact a member of the police is the main web developer here. That's not a personal comment at you, but you're dealing with sensitive data - this job should be done by a professional.

But as for colour you can do
<td style='text-align:center;color:#000000'> for black
<td style='text-align:center;color:#ff0000'> for red

Read up on css

[eramge11]

I believe you misunderstood what we were trying to accomplish. At this time our database is password encrypted on our server. The server is backed up twice daily and we pay to have it encrypted on a "gold" rated hosting server. However, everything we put into our in-house database is public record. If someone was to hack into our information and look at it- they would really be looking at information that is already available.

Second off,

I know CSS and I know how to change the font color of certain items. My question (originally) is how to make specific search result strings RED based on the information in the string. For example if I search the last name SMITH and we have 3 people with the last name SMITH- you would not want every single SMITH to be red. I would like to know how to make individual search results the color. I would prefer PHP since that is what I am already using to develop the system.

[NogDog]

I'm going to guess that there is something in [FONT=Courier New]$hm->Zb('rs:def:some_field_name_here')[/FONT] that indicates it's a result you want to highlight? If so, what I would do is test for it when outputting the applicable html element, and assign it a HTML class attribute if so, e.g.:

<tr><td<?php
if($hm->Zb('rs:def:some_field_name_here') == 'some_value') {
    echo ' class="active_warrant"';
}
?>><td>etc....</td></tr>

Then in your CSS style sheet, define [FONT=Courier New].active_warrant[/FONT] (or whatever you'd prefer to call it) to have the desired color, font-weight, or whatever else works for you.

[eramge11]

I tried all of what you said and it does not appear to be working. :/

[NogDog]

eramge11;11039767 wrote:

I tried all of what you said and it does not appear to be working. :/

Got code?

[eramge11]

eramge11;11039767 wrote:

Got code?

First off I am going to say thank you for not just giving me a simple "smart" answer because I am trying to solve a problem. I appreciate your help! Now, I added the code you gave and defined .active_warrant in my CSS. For whatever reason it was not changing the color of anything and only placing the etc... text in my search results.

This is what the search page looks like: See attachment 1[ATTACH]5073[/ATTACH] (I added myself into the database to show you an example)

The search result would look for anyone with the last name of "Ramge" and display the results. See attachment 2 [ATTACH]5075[/ATTACH]

I then changed the code that you gave me to show as below: I made the code you provided red, and also set the search string to look for the last name of Ramge. (towards the bottom of the code)

<?php include(INC_HTML_TAG); ?>
<?php $hm->Title( FILE, RSTR_APP_TITLE, RSTR_MPD_DATA, RSTR_SEARCH ); ?>

<?php echo $hm->SectEnd(); ?>
<!-- [END] Search Criteria-->

<!-- [BEGIN] Search Result -->
<?php if ( $hm->Zb("def:display?") ) { ?>

<?php echo $hm->SectBegin( RSTR_SEARCH_RESULT ); ?>

<div style='overflow:auto;'>
<table class='data_table'>

	<tr class='data_table_caption'>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:mpd_data_id'); ?>
			<?php echo RSTR_MPD_DATA_ID; ?></th>
		<th><?php include(INC_SR_SELREC_HEADER); ?></th>
		<th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
		<th><?php echo RSTR_ACTIVE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:ssn'); ?> <?php echo RSTR_SSN; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:license_number'); ?> <?php echo RSTR_LICENSE_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:phone_number'); ?> <?php echo RSTR_PHONE_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:license_plate'); ?> <?php echo RSTR_LICENSE_PLATE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:warning_number'); ?> <?php echo RSTR_WARNING_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:citation_number'); ?> <?php echo RSTR_CITATION_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:reporting_officer'); ?> <?php echo RSTR_REPORTING_OFFICER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:date_of_birth'); ?> <?php echo RSTR_DATE_OF_BIRTH; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:call_type'); ?> <?php echo RSTR_CALL_TYPE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:call_nature'); ?> <?php echo RSTR_CALL_NATURE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:vehicle_vin_'); ?> <?php echo RSTR_VEHICLE_VIN_; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_street'); ?> <?php echo RSTR_HOME_STREET; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:p_o_box_apt_'); ?> <?php echo RSTR_P_O_BOX_APT_; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_city'); ?> <?php echo RSTR_HOME_CITY; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_state'); ?> <?php echo RSTR_HOME_STATE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_zip_code'); ?> <?php echo RSTR_HOME_ZIP_CODE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:report_number'); ?> <?php echo RSTR_REPORT_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:date_added'); ?> <?php echo RSTR_DATE_ADDED; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:mpd_paper_service'); ?> <?php echo RSTR_MPD_PAPER_SERVICE; ?></th>
	</tr>

	<?php while( $hm->zb('@rs:def:begin_table') ) { ?>
	<tr>

<tr><td<?php
if($hm->Zb('rs:def:last_name') == 'Ramge') {
echo ' class="active_warrant"';
}
?>><td>etc....</td></tr>
<td style='text-align:right;'><?php echo $hm->Zb('rs:def:mpd_data_id'); ?></td>
<?php include(INC_SR_ID_PARAM); ?>
<?php include(INC_SR_SELREC); ?>
<?php include(INC_SR_EDIT_BTN); ?>
<td style='text-align:center;'><?php echo $hm->Zb('rs:def:active'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:first_name'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:last_name'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:ssn'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:license_number'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:phone_number'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:license_plate'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:warning_number'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:citation_number'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:reporting_officer'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:date_of_birth'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:call_type'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:call_nature'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:vehicle_vin'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_street'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:p_o_box_apt'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_city'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_state'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:home_zip_code'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:report_number'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:date_added'); ?></td>
<td style='text-align:left;'><?php echo $hm->Zb('rs:def:mpd_paper_service'); ?></td>
</tr>
<?php } ?>

</table>
</div>

<?php include(INC_SR_BOTTOM_BAR); ?>

<?php echo $hm->SectEnd(); ?>

<?php } ?>
<!-- [END] Search Result -->

<?php echo $hm->SectEndMarker(); ?>

<?php include(INC_FORM_END); ?>

</div>
<!-- [END] Main Form -->

<?php include(INC_BODY_FOOTER); ?>

</div>
<!-- [END] Container -->

</body>
</html>

<?php include(INC_HTML_END); ?>

When this code is entered once I search the last name of Ramge this is what I am given as a result:

View attachment 3- [ATTACH]5077[/ATTACH]

Attachment 1.png Attachment 2.png Attachment 3.png

[cretaceous]

<tr><td<?php
if($hm->Zb('rs:def:last_name') == 'Ramge') {
echo ' class="active_warrant"';
}
?>><td>etc....</td></tr>

you havent actually put any text within that 'td' and you've omitted the closing td tag

[eramge11]

cretaceous;11039789 wrote:

<tr><td<?php
if($hm->Zb('rs:def:last_name') == 'Ramge') {
echo ' class="active_warrant"';
}
?>><td>etc....</td></tr>

you havent actually put any text within that 'td' and you've omitted the closing td tag

The data is already in the system, I am trying to make the data that is already in the system red? The etc.... shows up regardless of me searching Ramge or not. I could search the name Smith and it would still be there. Thanks!

[NogDog]

You may have been led astray by sloppy sample coding on my part. (Lesson #25, never assume anyone else's code is correct. 😉 )

Hopefully making my original example somewhat closer to what you actually need:

<tr><td<?php
if($hm->Zb('rs:def:some_field_name_here') == 'some_value') {
    echo ' class="active_warrant"';
}
?>>[COLOR="#FF0000"][B]<?php echo $hm->Zb('rs:def:another_field_name_here'); ?></td>[/B][/COLOR]<td>etc....</td></tr>

You'll have to excuse me from trying to figure out exactly what field names should go where, but I'm fighting off a nasty cold, and am only here out of the sheer boredom of lying around all day to the point where I can't sleep now. 🙂

[eramge11]

NogDog;11039823 wrote:

<tr><td<?php
if($hm->Zb('rs:def:some_field_name_here') == 'some_value') {
    echo ' class="active_warrant"';
}
?>>[COLOR="#FF0000"][B]<?php echo $hm->Zb('rs:def:another_field_name_here'); ?></td>[/B][/COLOR]<td>etc....</td></tr>

You'll have to excuse me from trying to figure out exactly what field names should go where, but I'm fighting off a nasty cold, and am only here out of the sheer boredom of lying around all day to the point where I can't sleep now. 🙂

That is much better! When I search the name Ramge it comes up with the red like I wanted with a little message I put in. However, regardless of the name I search for example searching the last name Smith it shows the same message for the last name of Ramge except it is black instead of red. Any suggestions. Hope you feel better!

[eramge11]

In addition to what I just posted back to you above ^ - this is what the database looks like (I still think I am missing something) after I input rs:def:mpd_data_id into each of your field name here quotations. See the picture attached on the database. I removed the names for identity protection. I replaced some_value with 1136 that is why it is red. [ATTACH]5079[/ATTACH]

Attachment 4.png

[eramge11]

NogDog;11039823 wrote:

You'll have to excuse me from trying to figure out exactly what field names should go where, but I'm fighting off a nasty cold, and am only here out of the sheer boredom of lying around all day to the point where I can't sleep now. 🙂

Any suggestions? It's been quite a few days and I am stuck with no solutions to my last two answers. I posted. Any help would be great! :queasy:

[dalecosp]

Hello,

It's probably best if you show in your post the code as it stands now (otherwise you're expecting people to interpolate their own idea of what has changed), and as precise a description of the "current problem" as you can.

eramge11 wrote:

same message for the last name of Ramge

Are you still testing against that hard-coded name as Creataceous showed above? Surely you should be testing against a variable ... (but, I can't tell, as you haven't showed the current code, as I mention above)...

[eramge11]

dalecosp;11039927 wrote:

Hello,

It's probably best if you show in your post the code as it stands now

<!-- [BEGIN] Search Result -->
	<?php if ( $hm->Zb("def:display?") ) { ?>

<?php echo $hm->SectBegin( RSTR_SEARCH_RESULT ); ?>

<tr><td<?php
if($hm->Zb('ob:rs:def:last_name') == 'RAMGE') {
    echo ' class="active_warrant"';
}
?>><?php echo $hm->Zb('ob:rs:def:last_name'); ?></td><td>ACTIVE WARRANT</td></tr>

<div style='overflow:auto;'>
<table class='data_table'>

	<tr class='data_table_caption'>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:mpd_data_id'); ?>
			<?php echo RSTR_MPD_DATA_ID; ?></th>
		<th><?php include(INC_SR_SELREC_HEADER); ?></th>
		<th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
		<th><?php echo RSTR_ACTIVE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:ssn'); ?> <?php echo RSTR_SSN; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:license_number'); ?> <?php echo RSTR_LICENSE_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:phone_number'); ?> <?php echo RSTR_PHONE_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:license_plate'); ?> <?php echo RSTR_LICENSE_PLATE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:warning_number'); ?> <?php echo RSTR_WARNING_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:citation_number'); ?> <?php echo RSTR_CITATION_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:reporting_officer'); ?> <?php echo RSTR_REPORTING_OFFICER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:date_of_birth'); ?> <?php echo RSTR_DATE_OF_BIRTH; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:call_type'); ?> <?php echo RSTR_CALL_TYPE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:call_nature'); ?> <?php echo RSTR_CALL_NATURE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:vehicle_vin_'); ?> <?php echo RSTR_VEHICLE_VIN_; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_street'); ?> <?php echo RSTR_HOME_STREET; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:p_o_box_apt_'); ?> <?php echo RSTR_P_O_BOX_APT_; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_city'); ?> <?php echo RSTR_HOME_CITY; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_state'); ?> <?php echo RSTR_HOME_STATE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:home_zip_code'); ?> <?php echo RSTR_HOME_ZIP_CODE; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:report_number'); ?> <?php echo RSTR_REPORT_NUMBER; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:date_added'); ?> <?php echo RSTR_DATE_ADDED; ?></th>
		<th nowrap='true'><?php echo $hm->Zb('ob:rs:def:mpd_paper_service'); ?> <?php echo RSTR_MPD_PAPER_SERVICE; ?></th>
	</tr>

[dalecosp]

You're still setting a TD element as class "active_warrant" is the last name is RAMGE. That should, logically, be a variable instead, pointing to the person with the active warrant.

[eramge11]

dalecosp;11040069 wrote:

You're still setting a TD element as class "active_warrant" is the last name is RAMGE. That should, logically, be a variable instead, pointing to the person with the active warrant.

If you have the patience to give me an example of what it should look like you would save me so much headache. I'm trying to learn as best as possible.

[dalecosp]

Patience maybe (you're not really that trying ... give yourself some credit 😉 ), but specific knowledge, no. I have no idea what the $hm object/class looks like, other than it has a Zb function that takes a somewhat strange-looking set of parameters. 🙁

And truth is, I have to have a life away from the computer sometimes, too. Don't lose heart ... we can probably help if we all keep cool and patient. We may need to see your HM class, though ...

It may be getting to the point where you need to hire someone to help you.