Coloured Row : 2Different Table

sweetstranger

Hello,

I am fetching data from 2different tables – tab1 & tab2. Result of tab1 is displayed on page in table form. Now what I am trying to do is, if result (i.e. ID) of any row matches with the ID of tab2, it should be marked in RED COLOR.

if($id!==$fet_id)
{
$clas="admin_prod";
}while($id==$fetured_id){
$clas="admin_prod1";
}

$id is from tab1 & $fet_id is from tab2.
$clas is defined as 2different CSS

Where in all rows get marked RED sometime & sometime nothing happens. Kindly guide me through.

Thanks,
sW33tsTanG3R

bogu

U should put all the ID of tab2 in an array and when u output the table rows, just check if the ID of tab1 is in that array ....

sweetstranger

Hi again,

Thanks for your reply. I tried but not working as required. Please let me know whats going wrong :

//set array variable
$results = array();

//talk to the db
$query = "SELECT * FROM products WHERE id!='$newarrival_id'";
$result = mysql_query($query) or die(mysql_error());

//count the rows and fields
$totalRows = mysql_num_rows($result);
$totalFields = mysql_num_fields($result);

//start the loop
for ( $i = 0; $i < $totalRows; ++$i ) {

//make it 2 dim in case you change your order
$results[$i] = mysql_fetch_array($result);
}

if (in_array($fetured_id, $results, true)){
$clas="admin_prod";
}else{
$clas="admin_prod1";
}

Thanks in advance.

bogu

Do u understand your code? I dont ...

First of all did u print_r this array ($results) to see what do u have in it?

Second of all why do u count your fields number you dont use it?

$totalFields = mysql_num_fields($result);

This is a tip when u query ...

Write your query ...

$query = "SELECT * FROM products WHERE id!='$newarrival_id'";

Send it to mysql and check it for errors

$result = mysql_query($query) or die(mysql_error());

/* Check if there are affected rows (if your query returns results) */
if (mysql_num_rows($result)) {
    /* grab results in an array */
    while ($sc=mysql_fetch_assoc($result)) {
        $my_arr[] = $sc;
        /**
         * In your case u need an array with your ID's
         * so u catch
         * $my_arr[] = $sc['ID'];
         */
    }
}

In the end u should have an array of ID's:

$my_arr = array (
			0 => 1
			1 => 5
			...
			n => m
		);

something like this.

When u check this:

if ( in_array( $fetured_id, $my_arr) ) {
	$clas = "admin_prod";
}else{
	$clas = "admin_prod1";
}

if $fetured_id is in $my_arr array that should return true else return false ...

NOW, look at your array is it like the array I told u to create it?

sweetstranger

Hi again,

Thanks for your kind support by providing codes & accordingly it works but now what happens is : If value of both the Ids are same then color of all the rows changes🙁

// CODE STARTS ///

$query = "SELECT * FROM products WHERE id!='$newarrival_id'";
$result = mysql_query($query) or die(mysql_error());
$totalFields = mysql_num_fields($result);

/ Check if there are affected rows (if your query returns results) /
if (mysql_num_rows($result)) {

/ grab results in an array /
while ($sc=mysql_fetch_assoc($result)) {

$my_arr[] = $sc; 
}

}

$my_arr[] = $sc['ID'];

if ( in_array($fetured_id, $my_arr) ) {

            //RED COLOR
            $clas = "admin_prod1"; 
}else{ 

            //BLUE COLOR
$clas = "admin_prod"; 
}

//CODE ENDS //

Please guide me through whats going wrong.