Search:

I am trying to build a table
to look like this


A

B

C

this worked thank you

Thank you it worked

I have the following databse
Event Date_Start
BWM 2012-11-08
BWM 2012-11-08
BWM 2012-11-08
BWM 2012-11-08
BWM 2012-11-08
Lucent_LTE ...

i have the following in a database
switch-------version------------ date
a-------------b----------------- 01/12
a-------------a----------------- 01/12
b-------------a----------------- 02/12...

I have a database like so
switch version date
a b 01/12
a a 01/12
b a ...

so This is what i have so far:

while($r[]=mysql_fetch_assoc($getBWM));
{
echo "<pre>";
array_pop($r);
print_r($r);
echo "</pre>";
foreach ($r as $key => $value)
{

I need help with a array. Here is what i am trying to do. I have a sql database that has 2 col in it. col a "switch" col b "Emailaddress" so database would llok like this:
AAALT bob@net.com...

Resolved

Thank you for you help

This works thank you all for your help

I have a form with multiple checkboxes on it. Each check box has multiple emails. What i want to do is if they check the checkboxs then it needs to send out a email to the selected persons. Below...

i figured it out if you do the following command it will work

SELECT AddTeamsSoccerScore.TeamName,
SUM(CASE WHEN (AddTeamsSoccerScore.TeamName = HomeTeam) THEN HomePointsScore ELSE (CASE WHEN...

I need help with the following statement. What i want to do is add the AS statements
here is the code


SELECT AddTeamsSoccerScore.TeamName,
SUM(CASE WHEN (AddTeamsSoccerScore.TeamName =...

i figure it out you have to do the following

SELECT Vendor,Person,Sum(CASE WHEN(Vendor = 'L' AND `Event`= 'Cell' THEN `Total1` ELSE 0 END) AS LCell,Sum(CASE WHEN(Vendor = 'N' AND `Event`= 'Cell'...

i have a data base that looks like this

Vendor,Person,Event,Total1
L,bob,cell,5
N,bob,cell,3
L,bob,cell 2
M,bob,cell 1


SELECT Vendor,Person,Sum(CASE `Event`WHEN 'Cell' THEN `Total1` ELSE...

So i got that to work the only thing is that i need it to display like this

Vendor Person Cell BWM
Lucent BOB 8 0
Lucent Rob 2 0
Nortel ...

But then how do i print that on my web page. This is the problem that i am having

this is resolved

I have got this to work thank you for all your help

I need help
I have a database that has the following fields
Vendor,Person,Event,Total
What i need to do is get the sum of the total of what each person did by the vendor and the event.
I can get...

When i do the following command

SELECT * FROM `MailingList` WHERE `Switch` = (SELECT `Switch` FROM `MailingList` WHERE `Vendor`='Lucent' AND `YESorNOBWM` = 'Y')

I get the following error...

I have the following table layout
ID,Vendor,Switch,Postion,Emailaddress,YESorNO
1 lucent test MC s@ddd.com Y
2 lucent test ST s1@dd.com
3 lucent test1 DR ...

I am new at this so i am not sure what that is doing. Is there a easier way of sending the email out when the file gets updated

So i did the echo and What i found out is that the $getEmail is not working. I have test the string in my sql database and can get everything to come out. but when i apply it to the script there is...