Ajpalma

That was it, Thank you VERY much

SELECT * FROM deals WHERE price >= '50,000' AND price <= '2,000,000' is the result

nah, it doesn't return the right value even with 50,000 as the bottom limit(even with a 6 digit top limit) it just seems like it only works when both limits are 6 digits

I have a query that has a selectable ranges letting user select the top and bottom values and it finds the entries between them using greater than and less than for a value, say 350,000 the top value of 900,000 and bottom of 100,000 will return the correct value. but a top value of 2,000,000 or a bottom value of 50,000 will return NOTHING. does anyone know why it does this?or a solution? $result = mysql_query("SELECT * FROM deals WHERE price >= '$sql2' AND price <= '$sql1' ") thanks, Alex

anyone know the easiest way to set up a cron job?

Does anyone know how to send an email from a script when a specified date/time is reached automatically. I know how to send the email but how would the code run itself when the date is reached? Thanks, Alex

when I send emails form my php application they only send to internal network emails. Is this more likley an SMTP issue or in the code - note- theres no error message, it just doesnt go through thanks - Alex Heres the code - require("phpmailer/class.phpmailer.php"); $emaila = $_POST['emaila']; $emailb = $_POST['emailb']; $emailc = $_POST['emailc']; $yourname = $_POST['yourname']; $femail = $_POST['fromemail']; $mail = new PHPMailer(); $mail->IsSMTP(); // telling the class to use SMTP $mail->Host = "smtp.fatcow.com"; // SMTP server $mail->From = "$femail"; $mail->AddAddress("$emaila"); if ($emailb != ''){ $mail->AddAddress("$emailb"); } if ($emailc != ''){ $mail->AddAddress("$emailc"); } $mail->Subject = "Requested Document"; $mail->Body = "Requested Document"; $mail->WordWrap = 50; $path = '/PDF_STORAGE/' . $_POST['id'] . '.pdf'; $mail->FromName = "$yourname"; $mail->AddAttachment($path); if(!$mail->Send()) { echo "EMAIL HAS NOT BEEN SENT!<br>"; echo "Mailer Error: " . $mail->ErrorInfo; echo "<br>Please enter in both email address correctly. If this problem persists, then the smtp server is down."; } else { echo "Your email has been sent";?> <META HTTP-EQUIV="Refresh" CONTENT="2; URL=index.php"> <?php } ?>