[PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread Chris Berlioz
An easy way to do it (work around) is to dump it as csv or html. If your form can output an html table to the browser to show results then all you need is to include a short instruction on the html form that has all results in html table that would say something like "Save with your browser's 'sav

[PHP-DB] Re: Printing Forms

2004-05-21 Thread Chris Berlioz
Quick work around: Dump the MySQL data into a comma delimited file and then pick it up with MS Word Document Form to be merged. Then with the MS Task Scheduler I would schedule to open the document to print automatically and/or research with MS to email automatically. CB. === "

Re: [PHP-DB] Re: inserting data into database!

2004-05-14 Thread Chris Berlioz
Go to PHP.net, books @ bookstore. Seems like you are trying to insert data from an array into a MySQL table, I would visit http://dev.mysql.com/doc/mysql/en/index.html site too. Good luck. === "Ronald "The Newbie" Allen" <[EMAIL PROTECTED]> wrote in message news:[EM

Re: [PHP-DB] PHP Processing

2004-01-05 Thread Chris Berlioz
You can always test if your SQL statement successfully completed or not to determine errors. Using: $myresult =mysql_query($queryX,$myconn); if (! $myresult) { echo mysql_error($myresult) ; } else { // nothing or echo "Query successful"; } "Ryan Jameson" <[

[PHP-DB] Re: Searching a name field

2003-11-06 Thread Chris Berlioz
Yes you have to break this up into fields that hold your Firstname, MI,Lastname. This has so many advantages, using PHP string function to query inside fields might be useful somewhere else, I wouldn't recommend it for use in a large DB. Divide and conquer! Espero este consejo te sirva, ese erro

[PHP-DB] Re: MySQL Very Slow Work.

2003-09-25 Thread Chris Berlioz
You can always try indexing your data, this will improve your query speeds. Don't know how you are quering data, but would suggest using keys and "optimized" query expressions. You should also check your Win 2000 services running and anything that might interfere with your setup (ie: antivir, etc)

[PHP-DB] Re: MySQL and PHP?

2003-08-14 Thread Chris Berlioz
Read: http://www.mysql.com/products/licensing-examples.html === "Richard" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello > > I hope this is a rumour but I heard that MySQL is now fully GPL which it > wasn't earlier. > I think the part used to communicate with the

[PHP-DB] Re: Conection to MS SQL 2000 from PHP in Linux

2003-08-09 Thread Chris Berlioz
Try reading this on PHP site, documentation here is pretty useful. http://us4.php.net/manual/en/ref.mssql.php Suerte. == "Jean Fernando Ortiz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all! > I need to know how I must connect to MS SQL Server 2000 in a Win

[PHP-DB] Re: Pros/Cons Database vs Excel

2003-07-23 Thread Chris Berlioz
You can achieve much more with a Database backend, if your boss likes spreadsheets (XLS) then you can always export from any database backend (which ever one you want). He can still keep hyperlinks etc for web access etc if he would display the database results onto webpages/excel/text/etc!. Perha

[PHP-DB] Re: any Help !! the only way have to ODBC to Linux

2003-07-14 Thread Chris Berlioz
Go to http://www.mysql.com/downloads/api-myodbc.html or http://www.mysql.com/downloads/api-myodbc-3.51.html and download the driver for linux. Hope this is what you were asking for. Chris = "Nabil" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have an Linux server runni

[PHP-DB] Join Cursors

2003-03-24 Thread Chris Berlioz
Does anyone know how to join cursors after having successfull query ie: I have multiple queries that get data from different sources and now I need to join the results, how can I achieve this in PHP (Do I need to write into a temporary table and then requery? is that the only way? I am using MyS

[PHP-DB] ODBC cursor join

2003-03-24 Thread Chris Berlioz
Does anyone know how to join cursors after having successfull query ie: I have multiple queries that get data from different sources and now I need to join the results, how can I achieve this in PHP (Do I need to write into a temporary table and then requery? is that the only way? I am using MyS