[PHP-DB] query error
when i perform query an mysql db, to insert a new record, the PHP says: Warning: Supplied argument is not a valid MySQL result resource in g:\wwwroot\phpusermanager-1.0\add_order.php on line 24 the snippet is as follows why the argument isn't valid? how to solve this problem? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] updating several rows with a single form
Go to Julie Meloni's site at http://www.thickbook.com and have a look at the tutorials, or any of the tutorials listed on the PHP home page, or at DevShed, or PHPBuilder, or WebMonkey, or Zend. There are lots to choose from. Miles Thompson At 07:55 PM 5/4/2002 +0200, Antoine Panier wrote: >Hi all, >Newbie's trouble: >I can't figure out how to build a form and a script to update/delete several >rows from a mysql table with a single form. >I would need to list all the rows of a table, and be able to change the >content of one column. With a single submission ... > >Any idea would be much appreciated > >Antoine > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] updating several rows with a single form
Hi all, Newbie's trouble: I can't figure out how to build a form and a script to update/delete several rows from a mysql table with a single form. I would need to list all the rows of a table, and be able to change the content of one column. With a single submission ... Any idea would be much appreciated Antoine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Fatal error : Call to undefined function dbmopen()
Hello, On 1st May, I posted the following message to the PHP General newsgroup but could not get any answer. Thanks for any help... Bernard --- I run PHP 4.0.4 on a Redhat 7.1 I receive the following message 'Fatal error : Call to undefined function dbmopen()' when trying to open a new DBM file. phpinfo() returns : - configure command : '--with-db2''--with-db3''--with-gdbm' - DBA support : enabled - Supported handlers : gdbm db2 db3 Any idea ? Thanks in advance Bernard Chamberland -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?
"Frank M. Kromann" wrote: Many thanks Frank, changing from varchar to text did indeed fix the problem. On reflection, I do now remember reading about this on another mailing list, it's a pitty my memory failed me when I needed it the most :-) > The tool used to build the MSSQL extension for PHP (DB Library from Microsoft) was >created for SQL Server 6.x and not updated with the release of 7.x or 2000. > > In version 6.x the max length of char and varchar columns was 255 bytes, and that is >what you are seeing when you try to select data from char, nchar, varchar or nvarchar >> columns defined to be longar than 255 bytes. If you use the TEXT type you will not >have this limitation. > > - Frank > > > Hi All, > > > > I've come across an interesting problem. I'm trying to retrieve some > > text data (in this case a question up to 400 chars), but each time I > > perform a select statement I only receive the first 255 chars. > > > > What's the go here, is this just another microsoft thing ? -- Rgds, Chris MacKenzie Windows: "Where do you want to go today ?" Mac OS: "Where do you want to be tomorrow ?" Linux: "Are you coming or what ?" -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php