[PHP-DB] Re: E-mail as HTML

2004-08-26 Thread Nadim Attari
In PHP, how do I submit data by e-mail as HTML to a specified address? And where can I find samples of that in http://www.php.net/ ? HTML Mime mail at phpGuru http://www.phpguru.org/static/mime.mail.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] odbc_num_rows fails when HAVE_SQL_EXTENDED_FETCH is commented out

2004-08-26 Thread Mahmut Eren
Hi, I'm using php-4.3.3 on mandrake Linux. I had a performance problem accessing to DB2 databases on As400 systems. When I searched the internet I found out that commenting out '#define HAVE_SQL_EXTENDED_FETCH 1' lines from php_odbc_includes.h file could solve the problem. I edited the file and

Re: [PHP-DB] odbc_num_rows fails when HAVE_SQL_EXTENDED_FETCH is commented out

2004-08-26 Thread Robert Twitty
If HAVE_SQL_EXTENDED_FETCH is defined, then the odbc ext will use the ODBC API function SQLExtendedFetch instead of SQLFetch to retrieve records. SQLExtendedFetch is only necessary if a forward-only cursor is not being used. In the case of the odbc ext, it uses a dynamic cursor if

Re: [PHP-DB] Update multiple tables

2004-08-26 Thread John Holmes
From: Khalid Judeh [EMAIL PROTECTED] I have a script that make changes to the database in more than one sql statement, as i need to update more than one table at the same time, I want to know if there is a method where all of those changes are committed, or rolled back if some error occured(lets

[PHP-DB] Space requirements (with respect to foriegn languages)

2004-08-26 Thread Gerard Samuel
My site/code/database is developed primarily for the english language. I've had people from The Far East add content to my site using their native language, and it is displaying properly in the site. But Im a bit concerned about the number of characters these languages use. For example, I've had

Re: [PHP-DB] Space requirements (with respect to foriegn languages)

2004-08-26 Thread Jonathan Haddad
On Aug 26, 2004, at 12:27 PM, Gerard Samuel wrote: My site/code/database is developed primarily for the english language. I've had people from "The Far East" add content to my site using their native language, and it is displaying properly in the site. But Im a bit concerned

[PHP-DB] Re: PHP Array to Javascript?

2004-08-26 Thread Jasper Howard
depending on the size I guess you could run a foreach loop ex. $num = 0; foreach ($ringb as $val) { print x[$num] = '$val';\n; $num += 1; } so it pretty much just cycles through your array and prints it out in javascript form... Chris Payne [EMAIL PROTECTED] wrote in message news:[EMAIL

Re: [PHP-DB] Text area

2004-08-26 Thread Peter Ellis
I suspect your return result looks something like input type=textarea rows= rather than the full string, as you were expecting. You do need to escape quotes, as they are special characters. Try: function write_textarea() { return input type=textarea rows=\5\ cols=\70\ name=\\; } I'm

[PHP-DB] Array

2004-08-26 Thread 'Miguel Guirao'
Hi!! I have a table with many options from when the user can select them, after that, his/her selections will be stored in a database. In the mean time, I want to store his/her selections in an array like this one: PN DescQty

[PHP-DB] Re: Array

2004-08-26 Thread Torsten Roehr
Miguel Guirao [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi!! I have a table with many options from when the user can select them, after that, his/her selections will be stored in a database. In the mean time, I want to store his/her selections in an array like this one:

[PHP-DB] Updating a table when using LEFT JOIN

2004-08-26 Thread Chris Payne
Hi there everyone, I am using the following to grab the data I need from several tables: $sql = SELECT * FROM vendorprices LEFT JOIN fooditems on (vendorprices.FoodItemNumber = fooditems.FoodItemID) WHERE vendorprices.VendorNumber='$VendorID' ORDER BY vendorprices.VendorItemNumber;

Re: [PHP-DB] Array

2004-08-26 Thread Justin Patrin
$arr = array('key' = array('key2' = 'value', 'key3' = 'value', ...), ...); $arr['key2'] = array('key2' = 'value', ...); $arr['key3]['key2'] = 'value'; On Thu, 26 Aug 2004 16:11:27 -0500, Miguel Guirao [EMAIL PROTECTED] wrote: Hi!! I have a table with many options from when the user can

[PHP-DB] select query across multiple tables

2004-08-26 Thread Cole S. Ashcraft
I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class, assignment where assignment.classID = class.classID and assignment.assignmentID=$assidn'.

Re: [PHP-DB] Array

2004-08-26 Thread Micah Stevens
Since you provided no value's it's a little tough, but the general for would be: $parts = array( array(PN = $row1col1, Desc = $row1col2, Qty = $row1col3), array(PN = $row2col1, Desc = $row2col2, Qty = $row2col3) ); Depending on your implimentation, it maybe easier to use some sort of loop

Re: [PHP-DB] select query across multiple tables

2004-08-26 Thread jeffrey_n_Dyke
I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class, assignment where assignment.classID = class.classID and assignment.assignmentID=$assidn'.

Re: [PHP-DB] select query across multiple tables

2004-08-26 Thread Cole S. Ashcraft
Thanks! It works Cole On Thu, 2004-08-26 at 16:45, [EMAIL PROTECTED] wrote: I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class,

Re: [PHP-DB] Updating a table when using LEFT JOIN

2004-08-26 Thread Micah Stevens
From the Mysql docs: Starting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables: UPDATE items,month SET items.price=month.price WHERE items.id=month.id; The example shows an inner join using the comma operator, but multiple-table UPDATE statements can use