PHP - Php Mail From Multiple Result Sets

mysql_query("UPDATE mods SET version='$version' AND name='$title' AND descritpion='$description' AND lastupdate='$date' WHERE id='$id'");


I don't think I'm doing it correctly. :/

I have this code working fine (thanks to Thorpe).  FYI, this code is getting info for each day and putting that info into the array and then later on a calendar is generated and the data gathered here is placed onto each specific day.  This is working EXCEPT when there are MULTIPLE data sets on the SAME day.  In those cases, it's just displaying the first data set.

In other words, if $hunches['day'] = 3 and there is just one data set with that date, it will display that info on the calendar fine. But if there are five data sets with $hunches['day'] = 3, then it only displays the first one.

I need it to display all data sets, so any clue how I could alter this code to do that?


Code: [Select]
$sql = "SELECT  *, DATE_FORMAT(`dob`, '%e') AS day FROM hunches
WHERE poolid = '{$_GET['poolid']}'
AND  (DATE_FORMAT(`dob`,'%m')) = " . $month1 . "
ORDER BY day";
$gethunches = mysql_query($sql, $connection);
if (!$gethunches) {
die("Database query failed: " . mysql_error());
} else {

while ($hunches = mysql_fetch_array($gethunches)) {         
    $days1[$hunches['day']] = array(NULL,NULL,'<span class="red">' . $hunches['firstname'] . '</span>');
}
}

Here is a further explanation...
Say $hunches['day'] = 5 and there are four data sets for that day (with respective firstnames of Bob, Joe, Jim and Tony).  I would essentially need this to happen in the code...
Code: [Select]
$days1[$hunches['day']/*which would be 5 in this example*/] = array(NULL,NULL,'<span class="red">' . $hunches['firstname'] . '</span><br>
<span class="red">' . $hunches['firstname'] . '</span><br>
<span class="red">' . $hunches['firstname'] . '</span><br>
<span class="red">' . $hunches['firstname'] . '</span>');

And that would then output...

Bob
Joe
Jim
Tony

...in the 5th day box on the calendar.  Right now, I'm just getting...

Bob

I fear this is very complicated to do but holding out hope that there is some relatively easy way to make this work.

Hi,

i have a database with multiple records. One of those values is an image. When i query the database and i want only the images as a result it gives the result in a field. It then fills up the field horizontal and when there is no more field left it starts a new row. That is what i want.

But now i want some extra info next to the picture so i put that in a table with two colums like this:

echo '<table border="1" width="400"><td><a href="'.$row['website'].'"> <img src="'.$row['prod_img'].'">
               '.$row['prod_name'].' <a href="'.$row['website'].'">'.$row['website'].'</td></table>
            ';}}

But i still want the result to fill up the field and when the field is full i want the next results on a row below this....

Anyone?

Hi There,

I have an SQL query that returns 10 rows, which I want to echo over 2 columns and 5 rows, however, I want rows 1-5 on the left hand column and rows 6-10 on the right hand side.

Is there an easy way to do this? Normally I would do a fetch_array but, that would place the rows in order of, left, right, left, right - if that makes sense?

Table is a standard table with 2 columns and 5 rows.

Thanks
Matt

Hi Guys,

I have a HTML form which posts to a PHP mail script page. This data then emails to the company email address.

I have two file attachments on my form: CV and Photo ID

How do I integrate my php mail script to upload and then email these TWO files as TWO attachements on the email?

$fileatt_cv
$fileatt_id

I have tried a few methods that I found on Google but they dont work 

Code: [Select]
<?php

// Grab Data from Form
if(isset($_POST['submit'])) {

// Personal Information
$surname = mysql_real_escape_string($_POST['surname']);
$firstname = mysql_real_escape_string($_POST['firstname']);
$telephone = mysql_real_escape_string($_POST['telephone']);
$mobile = mysql_real_escape_string($_POST['mobile']);
$email = mysql_real_escape_string($_POST['email']);
$address = mysql_real_escape_string($_POST['address']);
$postcodep1 = mysql_real_escape_string($_POST['postcodep1']);
$postcodep2 = mysql_real_escape_string($_POST['postcodep2']);
$dob_dd = mysql_real_escape_string($_POST['dob_dd']);
$dob_mm = mysql_real_escape_string($_POST['dob_mm']);
$dob_yyyy = mysql_real_escape_string($_POST['dob_yyyy']);

// Next of Kin
$nextkinname = mysql_real_escape_string($_POST['nextkinname']);
$nextkintel = mysql_real_escape_string($_POST['nextkintel']);

// Availability
$days_mon = mysql_real_escape_string($_POST['days_mon']);
$days_tue = mysql_real_escape_string($_POST['days_tue']);
$days_wed = mysql_real_escape_string($_POST['days_wed']);
$days_thu = mysql_real_escape_string($_POST['days_thu']);
$days_fri = mysql_real_escape_string($_POST['days_fri']);
$days_sat = mysql_real_escape_string($_POST['days_sat']);
$days_sun = mysql_real_escape_string($_POST['days_sun']);
$availability_am = mysql_real_escape_string($_POST['availability_am']);
$availability_pm = mysql_real_escape_string($_POST['availability_pm']);
$availability_allday = mysql_real_escape_string($_POST['availability_allday']);
$availability_requirements = mysql_real_escape_string($_POST['availability_requirements']);

// Experience
$experience = mysql_real_escape_string($_POST['experience']);

// File Attachments
$fileatt_cv = mysql_real_escape_string($_POST['fileatt_cv']);
$fileatt_id = mysql_real_escape_string($_POST['fileatt_id']);

// Rates
$rate = mysql_real_escape_string($_POST['rate']);
$rate_specific = mysql_real_escape_string($_POST['rate_specific']);

// Employer Ref
$employrefname = mysql_real_escape_string($_POST['employrefname']);
$employrefcomp = mysql_real_escape_string($_POST['employrefcomp']);
$employreftel = mysql_real_escape_string($_POST['employreftel']);
$employrefadd = mysql_real_escape_string($_POST['employrefadd']);

// Personal Ref
$persrefname = mysql_real_escape_string($_POST['persrefname']);
$persreftel = mysql_real_escape_string($_POST['persreftel']);
$persrefadd = mysql_real_escape_string($_POST['persrefadd']);

// Extra Information
$allergy = mysql_real_escape_string($_POST['allergy']);
$allergy_details = mysql_real_escape_string($_POST['allergy_details']);
$drive = mysql_real_escape_string($_POST['drive']);
$car = mysql_real_escape_string($_POST['car']);
$criminal = mysql_real_escape_string($_POST['criminal']);
$criminal_details = mysql_real_escape_string($_POST['criminal_details']);
$howlongworkuk = mysql_real_escape_string($_POST['howlongworkuk']);
$police_check = mysql_real_escape_string($_POST['police_check']);
$right2work = mysql_real_escape_string($_POST['right2work']);
$right2workna = mysql_real_escape_string($_POST['right2workna']);


// Email Options
$subject = "Test Company - Job Application";
$to = "test@test.com"; 
$mailheader = "From: $email" . "\r\n";
$mailheader .= 'MIME-Version: 1.0' . "\r\n";
$mailheader .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Applicants copy
$mailheader .= "BCc: $email" . "\r\n";

// Message Content

$body .= 'Message';


// End of Email Content > Display Message

echo "Thank you. Your application was submitted to us successly. We review all applications carefully and we may contact you shortly.";

// Attempt to Send Email

mail($to, $subject, $body, $mailheader);

} else {

echo "Application Failed. Unfortunatley, there was a problem with your application and it was not submitted. Please try again later or alternativley please contact us.";

}
?>
Thanks in advanced.