ignace

PEAR::Mail is no different then mail() it only allows you to use something different then the native PHP mailer. It will not tell you if your recipient actually received the e-mail. There are a few other ways though you can use: 1. Use a 1x1 pixel image <img src="http://www.yourserver.com/mail-received.php?email=.." width="1" height="1> Ofcourse if their e-mail client blocks images you'll never know who read it. 2. Use the Return-Path header. This will send an e-mail back to you in the event a mail could not be received. You can use PHP to read incoming mail (http://www.evolt.org/article/Incoming_Mail_and_PHP/18/27914/index.html) Your best option is to use http://www.campaignmonitor.com/ this is a tool that provides you with all the needed statistics

If you use the built-in DateTime & DateInterval classes you could just use: while ($row = mysql_fetch_assoc($result)) { $start = new DateTime($row['start']); $end = new DateTime($row['end']); $interval = $end->diff($start); // replaces time_compare() if ($interval->invert) { echo 'Item Sold'; continue; } // these 4 lines replace your entire time_format() function with equal functionality echo (!empty($interval->d) ? $interval->d . ' days ' : ''), (!empty($interval->h) ? $interval->h . ' hours ' : ''), (!empty($interval->i) ? $interval->i . ' minutes ' : ''), (!empty($interval->s) ? $interval->s . ' seconds ' : ''); } If you extend both the DateTime & DateInterval class it can be as simple as: while ($row = mysql_fetch_assoc($result)) { $start = new MyDateTime($row['start']); $end = new MyDateTime($row['end']); $interval = $end->diff($start); // replaces time_compare() if ($interval->isSold()) { echo 'Item Sold'; continue; } // these 4 lines replace your entire time_format() function with equal functionality echo $interval; }

That's because Windows uses \ not / file:///c:\xampp\htdocs\images\xxx.jpg

http://www.sqlbuddy.com/

What is your current setup? One page for every song? If so then at the minimum you are going to have to write at every page: include('modules/comments/index.php'); Edit: nevermind read it wrong What do you actually want in the system? user registration/login, promote/demote, mark as spam?

Your XML is wrong <item name="whatever"> <request by="someone" confirmed="true"/> </item> Then you can use: /item[name="whatever"] Now you have to query all by: /item/request/by | //by And go over each element, retrieve it's value and check if it equals

You basically want to create a game-balancer? SELECT g.id, count(p.*) AS player_count FROM groups g LEFT JOIN players ON g.id = p.group_id ORDER BY player_count LIMIT 1 This should give you the ID of the group that has the lowest number of players

php.ini

LOL 0D0A is the equivalent of \n for which their is a function called nl2br

try LEFT JOIN

Excel has an option to format XML: 1. remove the empty row #1 2. Create a dummy XML file with all elements/attributes and empty values 3. Go to Options for Excel > Popular > Show tab developers 4. Go to the new tab Developers, press Source a window on the right appears 5. Press XML assignments a new dialog box appears, press Add 6. Select your dummy XML and press Ok 7. In the window on the right your elements/attributes appear, drag & drop them on your heading 8. Return to the Developers tab and press Export This may be a quicker way to format your data as Excel is compatible with Access which in turn can use ODBC for which their is a MySQL driver

You have this when you send it. Create the unsubscribe link in the newsletter you send out. If you are using outlook it may give you an option to add a parameter in your e-mail that will be changed when it sends it.

That query is wrong as there is no table with the name prod as for your InnoDB it might give problems. Create a SELECT query that selects all the data that needs to be deleted then transform it in a DELETE query using my code as a base

$result = mysql_query("SELECT * FROM cart WHERE session_id = $sid OR user_id = $uid"); $products = array(); while ($row = mysql_fetch_assoc($result)) { $products[$row['id']] = $row; echo '<input type="text" name="product[', $row['id'], ']" value="', $row['quantity'], '">'; } //.. if (isset($_POST['product']) && is_array($_POST['product'])) { foreach ($_POST['product'] as $id => $quantity) { $id = intval($id); $quantity = intval($quantity); if (isset($products[$id])) { if ($quantity <= 0) { mysql_query("DELETE FROM table WHERE user_id = $uid AND id = $id"); } else if ($quantity != $products[$id]['quantity']) { mysql_query("UPDATE table SET quantity = $quantity WHERE id = $id"); } } } }

Do you want to store the error's? Or do you want to display them directly?

<!ELEMENT option (choose)><!-- you forgot > --> <!ELEMENT choose (one|two|three) >

Move price & quantity out of your products table then add these tables: products_sizes (id, size_name); products_has_sizes (products_id, products_sizes_id, price, quantity); SELECT p.name, p.description, ps.size_name, phs.price, phs.quantity FROM products_has_sizes phs JOIN products p ON phs.product_id = p.id JOIN products_sizes ps ON phs.products_id = ps.id This will return: Vintage T-Shirt, .., S, 5.99, 15 Vintage T-Shirt, .., M, 8.99, 3 Vintage T-Shirt, .., L, 10.99, 7

Your developing an application that is harder then you might think for example the restaurant may only have tables of four so that becomes a problem when someone reserves for 1 person or 3 persons where your application would indicate that there is a seat available but no table..

DELETE c, p, pd, pq FROM company c JOIN product p ON c.compid = p.prodcompid JOIN productdetail pd ON p.id = pd.prodid JOIN productquality pq ON p.id = pq.prodid WHERE c.compid = '$compID'

download-files.cmd ftp -vin -s:download-files.txt download-files.txt open www.domain.com user username password cd path/to/directory !cd path/to/local/directory binary mget *.jpg Modify this script to your needs and add a windows task to run this script every now and then PS i did not test this script

select * from articles where month(now()) = month(article_date)

Mark Zuckerberg thought so to when he started Facebook with some friends

If you use my code it's as simple as: <form action="unsubscribe.php"> <input type="text" name="email"> <input type="submit" value="Unsubscribe"> </form>

Be sure to create a back-up before using this script. if (!isset($_GET['email'])) { echo 'No e-mail specified.'; exit(0); } $email_address = $_GET['email']; if (!preg_match('/[a-z0-9-\._]+@[a-z0-9-]+(\.[a-z]+){1,2}/i', $email_address)) { echo 'Invalid e-mail specified.'; exit(0); } $found = false; $emails = file('NewsletterREG.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES); foreach ($emails as $key => $email) { if ($email === $email_address) { $found = true; unset($emails[$key]); break; } } if ($found) { echo 'You have been unsubscribed.', 'If you are not being redirected click to return to the <a href="index.php">homepage</a>'; file_put_contents('NewsletterREG.txt', implode(PHP_EOL, $emails)); header('Refresh: 3; url=index.php'); } else { echo 'Your e-mail was not found in our records, do you wish to', '<a href="subscribe.php">subscribe?</a>'; }

For me it all started in a PC cafe around 2003 where me and my friends played Counter-Strike and I downloaded skins to play with from http://games.telenet.be (doesn't exist anymore refers you to 9lives.be) and I wondered what it would take to create something like that somehow I landed at HTML and CSS later on. I must have written tons of templates back then just to get the hang of HTML and CSS and to create "stunning" templates which I would admire for a few hours and then started creating another. In 2005, the union in the company for which my Dad worked - and for which he was a treasurer - needed a website but they didn't like the price-tag associated with it. My Dad knew I was messing around with that kind of stuff and volunteered me. So it was settled - without my knowledge - I would create their website. When I heard I was excited first but that turned into worries because there is a big difference between creating a template for yourself and a website for a client, to cut a long story short I can say their website was tutorial-ed together (PHP was hot everything (tutorial) pointed in it's direction) and the best part is they loved it even after 5 years they still don't want to change the front-end template because they still get and got real good comments about their website. They even liked the back-end (which was inspired by Mint). Although they were happy about the result I wasn't (because of the guilt and the endless tutorial code that made up their website) So bound to make it right I learned PHP thoroughly a few years later I wanted to take another shot and created a completly new website, new layout, neat code on which they replied: the website is fine like it is, it doesn't need changing. A couple years later I asked them again if they wanted a new website which was once rejected. Now 5 years later I develop PHP websites with a passion and I'm proud to say that I have a thorough knowledge of the PHP library and Project A&D