PHP - Creating A Job Number Script.

Hey guys was wondering if anyone could modify the code below to have $output = 'yes' if the number of rows equal 10, 20, 30, 40, 50, 60, 70, 80......... etc

$dbhost = '******';
$dbuser = ''******';';
$dbpass = ''******';';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('MYSQL N/A - Please Contact Admin');

$dbname = ''******';';
mysql_select_db($dbname);

$query="SELECT * FROM documentaryinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close($conn);
?>

Thanks
--------------------------------------------------------------------------------------------------------
Watch Free Documentaries Online - The Documentary Database
www.free-documentaries-online.com
--------------------------------------------------------------------------------------------------------

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

I'm attempting to praise(if that's how you say it) txt data into xml with php and have come across a problem I've been unable to solve over the past two days so I'm coming here to ask the php gods for their assistance.

The file I'm prasing contains line after line of real estate data. I understand what I'm doing I think. I've gotten the data in a format that is more usable, taking out the tabs and replacing them with spaces and such. I am creating a series of if than statements which will select the address out of each line even though each line can be different. At the end of the address on each line there is a "S" character which stands for some property I'm not concerned with. I'm simply using the single 'S' to find the end of the address. The lines look like so:
                                                                                                                                                                        \/
403089   RESIDENTIAL   Residential   385000   7610 N Lakeshore Dr.   Harbor Springs   S   3   2   0   None      3   Litzenburger, Boo   Schaffer Real Estate
399562   RESIDENTIAL   Condominium   155000   4749 Pleasantview Road   Harbor Springs   S   2   2   0   One         Hartwick, Bob   Coldwell Banker Schmidt   

With a bunch of extra text following that I've trimmed off for our purposes here. See the 'S' after the town? I've created the following code to look for the 's' in relation to the word order.

Code: [Select]
<?php
// Listings file
$listings= file('listingsTest.txt');
$i = 0;
$j = 0;
$_ENV['a'] = 0;

foreach($listings as  $value) {
//Replace all spaces of every kinds with single spaces
$listings[$i] = preg_replace("'\s+'", ' ', $listings[$i]);
//Put all characters into an array corisopndings to each line in $listings
$_ENV['chars'.$i] = preg_split('//', $listings[$i]);

//Place all words and uninterupted numbers and place in array $words
$_ENV['words'.$i] = preg_split('/ /', $listings[$i]); 

$i++;
}

//echo $_ENV['chars'.'1']['1'];

foreach($_ENV['words'.$_ENV['a']] as $char){
$countedf = preg_split('//', $_ENV['words'.$_ENV['a']][$j]);
$counted = count($countedf) - 2;

$wordBeforef = preg_split('//', $_ENV['words'.$_ENV['a']][$j-1]);
$wordBefore = count($wordBeforef) - 2;

$wordAfterf = preg_split('//', $_ENV['words'.$_ENV['a']][$j+1]);
$wordAfter = count($wordAfterf) - 2;

if( ($counted == 1) 
&& ($wordAfter == 1)
&& (is_numeric($_ENV['words'.$_ENV['a']][$j+1]))
//&& ($wordBefore == 1)
//&& (!is_numeric($_ENV['words'.$_ENV['a']][$j]))
//&& (is_numeric($_ENV['words'.$_ENV['a']][$j+2]))
//&& ($_ENV['words'.$_ENV['a']][$j+3] == ' ' )
){
echo '*';
echo $_ENV['words'.$_ENV['a']][$j];
echo '*';
$_ENV['a']++;
$j =0;
//$j=1
}
//echo $_ENV['chars'.$_ENV['a']][$j];

$j++;
}

?>

As you can see from the if then statements, I've gotten to the point where It's replying to the 'S' at the end of the address thus telling me where the address ends. I am however having  a problem I believe is a server issue. The code works fine when applied to 12 lines like the ones above, when I apply it to more of those lines it does not return the 'S' for them even if I used the exact same line more than 12 times. The main file which I'd like to automate the parsing of has thousands of these such lines in it.  If I try to apply this code to the file with these thousands of lines, the browser returns a "The website encountered an error while retrieving http://localhost. It may be down for maintenance or configured incorrectly".

I take this to mean the server is doing too much work for it to be completed. I think when it reaches it's twelfth, the temporary memory of my program/server or some thing else, is exhausted. I'm applying these if then statements to every single word in the file. Is this a processing issue on the server? I was applying this code to every character in the file and thought I could fix the problem by applying instead to every word given there are less words than characters. I have the processing time on the server set to 10000 and it's not taking along time to return the error message.

I would be very grateful to any help any of you could provide. Thank you for your time.

I am using a simple email script called PHPmailer which works great but i would like to create a form so a user can input what the text for the email should be along with the subject from texts boxes, i also need the script to connect to a mysql database to get a list of email address to send to. Then once the user presses the send button the email is sent out to everyone in the database.
Can anyone help me?
<?php
include_once('class.phpmailer.php');

$mail             = new PHPMailer();
$body             = eregi_replace("[\]",'',$body);

$mail->IsSendmail(); // telling the class to use SendMail transport

$mail->From       = "zac@zpwebsites.com";
$mail->FromName   = "First Last";

$mail->Subject    = "PHPMailer Test Subject via smtp";

$mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test

$mail->MsgHTML($body);

$mail->AddAddress("zacthespack@gmail.com", "John Doe");

$mail->AddAttachment("uploads/AleMail.pdf");             // attachment

if(!$mail->Send()) {
  echo "Mailer Error: " . $mail->ErrorInfo;
} else {
  echo "Message sent!";
}

?>

I need like,

http://www.trackcourier.in/

The customer chooses selected courier service and enters tracking id then clicks its redirect to the appropriate courier service website.

eg: If tracking id 12345 the redirect link should be https://www.fedex.com/apps/fedextrack/index.html?tracknumbers=12345&cntry_code=in

How to do for India courier services?