Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
mail merge with php and mysql?
Name: timothy_aah Date: March 16, 2009 at 12:56:36 Pacific OS: Windows XP Subcategory: General
Comment:
Hi,
I'm trying to make a mail merge system like word does, but with php and mysql. as far as I know word only uses the query 'select * from <source>' my database is a lot more complex than just one simple table, so I need to be able to make custom queries... Actually, queries from 2 different databases have to be made... this should definitely be possible with php and mysql. I've searched around, but haven't found anything satisfying/working :s... any ideas? thx!
btw: I'm running a Xampp webserver package on windows XP pro
Name: timothy_aah Date: March 17, 2009 at 01:40:09 Pacific
Reply:
Also, the database(s) contain data that has to be exploded first by means of a delimiter... so unless that is possible in mysql, creating a View in mysql and then reading from it with word is not an option
Summary: When I test this code for php and mysql; <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected suc...
Summary: In my opinion a book is the best way to learn a new language because it is better to read than from screen, you can easily look things up when needed (and believe me, you will look things up because ...
Summary: Using static documents is certainly the fastest way, but string matching your database regularly isn't very dynamic (and when you add content it creates an extra step). Also, It could pollute your da...