[PHP-DB] RE: Creating a pdf document

2002-01-24 Thread Andrew Chase
http://www.php.net/pdf You'll need Thomas Mertz' PDFlib, which is free for personal/not-for-profit use, but requires a license fee for commercial use: http://www.pdflib.com/pdflib/index.html -Andy > -Original Message- > From: Mihail Bota [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, J

[PHP-DB] RE: Search results

2002-02-06 Thread Andrew Chase
You can use mysql_result_rows() to check whether any rows were returned; something like: 0){ while ($row = mysql_fetch_array($result)) { //Do stuff with result rows here } }else{ echo "Sorry your search returned Zero Rows"; } ?> HTH, -Andy >

RE: [PHP-DB] RE: Search results

2002-02-06 Thread Andrew Chase
Yes, sorry about that. :P I need to eat lunch now. -Andy > -Original Message- > From: Chris Boget > Subject: Re: [PHP-DB] RE: Search results > you mean: > > mysql_num_rows(); > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: Creating a good search engine

2002-03-25 Thread Andrew Chase
You might want to check out this article on Webmonkey: http://hotwired.lycos.com/webmonkey/97/16/index2a.html?tw=programming The article uses Perl, but the concepts are easy enough to translate to PHP. :) -Andy > -Original Message- > From: Mike de Libero [mailto:[EMAIL PROTECTED]] > Se

[PHP-DB] RE: Images on MySQL

2002-03-29 Thread Andrew Chase
The kneejerk response always seems to be #2, store images in the filesystem and store their paths in the database. I like to compromise: store the original image in a dedicated "image data" table in the database (keep a separate table for image meta data (date/title/category/whatever) for faster

[PHP-DB] RE: PHP Mysql apache economy hosting

2001-07-13 Thread Andrew Chase
I used Cedant.com to host my own site for a few months, and they were excellent - no down time that I was aware of, and a handy web-based control panel (and of course SSH shell access for anything not covered by the control panel.) Although they didn't have a large tech support phone bank (Usuall

[PHP-DB] RE: Probably a stupid home server question ........

2001-07-19 Thread Andrew Chase
Make sure ahead of time whether the cable ISP gives you a static IP address or a dynamic one... Most of them in the US only give you dynamic IP's. They don't change all that often, but it does make it tough to host a domain name if your IP address is liable to change at any given moment. Also, r

[PHP-DB] RE: Could get all data from MYSQL using Mysql_fetch_array!!

2001-08-29 Thread Andrew Chase
You did fetch all the data by using '*' in your query, but you can't use '*' as a wildcard when referring to an associative array (which is what $row is) - you need to step through each key in the array: while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { $fields = array_keys($row);

[PHP-DB] RE: Could get all data from MYSQL using Mysql_fetch_array!!

2001-08-30 Thread Andrew Chase
> -Original Message- > From: Andrew Chase [mailto:[EMAIL PROTECTED]] > Or you could do it longhand - > > while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) > { > print ("{$row["Reason"]}"); > print ("{$row[&qu

RE: [PHP-DB] php + MYSQL based banner exchange system

2001-09-19 Thread Andrew Chase
There's also PhpAdsNew, which picks up where PhpAds left off at its last release in May of 2000: http://sourceforge.net/projects/phpadsnew/ -Andy > -Original Message- > From: Boaz Yahav [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 18, 2001 1:42 PM > To: Andrius Jakutis; [EMAI

[PHP-DB] RE: postgres optimization

2001-11-26 Thread Andrew Chase
You'll probably want to familiarize yourself with the VACUUM command and VACUUMDB utility: http://www.postgresql.org/idocs/index.php?sql-vacuum.html http://www.postgresql.org/idocs/index.php?app-vacuumdb.html -Andy > -Original Message- > From: Ric Manalac [mailto:[EMAIL PROTECTED]] > S

[PHP-DB] RE: WYSIWYG HTML Editor with PHP

2001-12-10 Thread Andrew Chase
It depends on what platform and browser you expect contributors will be using to add content; ActiveX objects are only good for MSIE/Windows, while Java has a somewhat broader reach. WYSIWYG with HTML/DHTML/Javascript is klugey at best, even if it's PHP-based; PHP is great for making admin screen

RE: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Andrew Chase
> I also prefer to use printf(" so it has the value in > quotes - just a fussy html thing i do though. If you like your code to be legible in a browser's 'View Source' function (which can sometimes be helpful for debugging), you can also add a newline "\n" character to the end of each option line

[PHP-DB] RE: display text in screen

2002-01-11 Thread Andrew Chase
Just add echo statments at whatever steps you want to display comment or detail for; something like: Some page "; echo mysql_error(); echo ""; exit; } echo "Selecting database 'foo': "; if(@mysql_select_db("foo", $dbconnection)){ echo "OK"; }else{ e