[RESOLVED] Selecting data from array and using SUBSTR ?

[swatisonee]

Hi,

Here's what i want to and following it is the code i have thus far.

a. I have a small message service for my users .
b. Lets say i send a message to one of them. When he logs in, he gets an alert.
c. He then reads the message.
d. Now the next time he logs in and sees his list of messages, i would like the read messages to be in blue and the unread in say, red.
e. I need help in defining the the userid as part of the array.

Here's the relevant snippet :

$seenby = $myrow["Seen_By"];
$sbArray = array_unique(explode(',', $seenby));

if ( $userid ==  $sbArray) // this is the error. userid can be only one of the array elements and hence the equal to sign doesnt work. So I wondered if I should use substr instead of sbArray and if so, then how would i define it to pick up only the userid i need ?

{


$name = "<span style=\"color: blue;\">$name</span>";              // defined earlier
$calcdate = "<span style=\"color: blue;\">$calcdate</span>";
$timea = "<span style=\"color: blue;\">$timea</span>";
}

else
{

$name = "<span style=\"color: red;\">$name</span>";
$calcdate = "<span style=\"color: red;\">$calcdate</span>";
$timea = "<span style=\"color: red;\">$timea</span>";
}

printf("<tr><td><input type=\"radio\" name=\"choice\" value=%d><td>
<font size=2 face=Tahoma color=#339966>%s<td>
<font size=2 face=Tahoma color=#339966>%s<td>
<font size=2 face=Tahoma color=#339966>%s<td>
</tr>",
 $myrow["MID"],
 $name,
 $calcdate,
 $timea );

and so on....

Woukd appreciate some help in that IF statement which is incorrect pl.

Thanks. Swati

[Kudose]

//if ( $userid ==  $sbArray) // old
foreach($sbArray as $key => $value)
  if($userid == $value)
     //do stuff

That work for you?

[halojoy]

Kudose wrote:

//if ( $userid ==  $sbArray) // old
foreach($sbArray as $key => $value)
  if($userid == $value)
     //do stuff

Or maybe use http://php.net/in_array

if ( in_array( $userid, $sbArray ) ) {


}

[swatisonee]

Yes !! Thank you both !

[Kudose]

I was going to reccommend [man]is_array[/man] but for some reason I went the other route ... oh well.

[swatisonee]

Hi Kudose , Halojoy

Taking your solution a little further , I am trying to combine both to solve another problem (pl see hyperlink) , only i first need to take elements of the array out of the field and then query another table for that element. I've made a mess of it . Below is the snippet that i tried using your solution in and the error is a blank page.

Can you please guide me on what i should be doing ?

Thanks. Swati

http://www.phpbuilder.com/board/showthread.php?t=10327066

$sqlb= 	"SELECT * FROM `VisitReport` WHERE  (( (MONTH(`Visited_Date`) >= 4) AND (YEAR(`Visited_Date`) = $year0) ) || ( (MONTH(`Visited_Date`) <= 3) AND (YEAR(`Visited_Date`) = $year1) ) ) ORDER BY `Company` asc ";

//echo $sqlb; 

$resultb = mysql_query($sqlb);

if ($myrowb = mysql_fetch_array($resultb))
{
do
{

$cid = $myrowb["Customerid"];
$cidArray = array_unique(explode(',', $cid));

 $sqla = "SELECT * FROM `Customers_List` WHERE  ((`BusinessState` LIKE 'AZ') || (`Business State` LIKE 'PA') ) ";

$resulta = mysql_query($sqla);

if ($myrowa = mysql_fetch_array($resulta))

{
$csid = $myrowa["Customerid"];
// echo $csid;


if ( in_array( $csid, $cidArray ) )

{
printf("<tr>
<brS.No&nbsp;<font size=2 face=Tahoma>%d,

 //  and so on

</tr>",

  $i,
 $myrowa["Company"],
  calculatedate($myrowb["Visited_Date"])   // and so on
 );
}

}

}
while ($myrowb = mysql_fetch_array($resultb));
}

[Kudose]

If $cid cannot be $value, then it must be $key.

$key => $value seperates the array key (name) and the value it holds. So if the associative array (hash)'s name is what you are looking for, use $key.

[swatisonee]

OK i just modified it because i thought of combining the two. i had tried $key but thatalso gave an error.