FW: [PHP-DB] php-db-unsubscribe@lists.php.net

2002-09-10 Thread Robert DelGarbino
-Original Message- From: rdelgar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 9:07 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [EMAIL PROTECTED] [EMAIL PROTECTED] Sincerely, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www

[PHP-DB] php-db-unsubscribe@lists.php.net

2002-09-10 Thread rdelgar
[EMAIL PROTECTED] Sincerely, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Shane Caraveo
Ok, then I would be for ODBC 3 for PHP 5 as the standard. An ODBC 2 extension can be shuttled out to PECL for those who may need it. But for BC issues, there is still the nameing convention. I would personaly prefer that the odbc functions stay odbc_*, rather than to start iterating through

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
On Tue, 10 Sep 2002, Shane Caraveo wrote: > Hmm, is there no way to make the functions work with both odbc versions? > Have an odbc_set_version(int) function that can set the version of > odbc to use. The default can be version 3. This way, with the addition > of a single function call, scrip

Re: Fw: [PHP-DB] whats wrong with my sql insert statement?

2002-09-10 Thread user
my input.html has errors in it. wrong correct strange thing is it used to work. anyhow thanks for the help. Nikos wrote: >>Try remove (;) at the end of the expresion, before quote ("): VALUES >>('$first_name','$location','$phone', '$blabla')...(;)..." >> >>- Original Message - >>From:

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Shane Caraveo
Hmm, is there no way to make the functions work with both odbc versions? Have an odbc_set_version(int) function that can set the version of odbc to use. The default can be version 3. This way, with the addition of a single function call, scripts can provide BC. Shane Dan Kalowsky wrote: >

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
On Wed, 11 Sep 2002, Wez Furlong wrote: > I know this probably isn't the kind of comment you want just now, but... > If this is to support ODBC v3+, why not call the functions odbc3_xxx instead > of odbc2_xxx? I think this could help prevent some head-scratching a little > later down the track.

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

2002-09-10 Thread Wez Furlong
Hi Dan, On 11/09/02, "Dan Kalowsky" <[EMAIL PROTECTED]> wrote: > - It will support ODBC v 3.0 and greater only. With the needs of many DBs ... > I would like to add this into the current PHP system, to allow users to > start playing with and testing as well. Well probably just as soon as I > fi

[PHP-DB] RFC: ODBC and PHP

2002-09-10 Thread Dan Kalowsky
To Whom It May Concern, I've been working for the last few months (delayed often, but mostly the last few weeks) on what I've been tenatively calling ODBC2. Basically this is what I'd like to see PHP v 5 have as it's default ODBC system. Some general notes about it: - It will break BC. I have

AW: [PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Franz Kornberger
Hi, I had a similar problem to this shopping cart some time ago, and I handled it that way: Within a form the user (it's made for salesmen) can add lines of articles, text etc to build up an offer. The price for the added articles can be choosen from different pricelists given in a database. W

[PHP-DB] ODBC text driver problem

2002-09-10 Thread Ethan Nelson
Hello, I'm having trouble connecting via ODBC using the Microsoft text driver on a win2k box. I read the KB article at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178717 and it seems to suggest that I should be able to select data from a text source. Here is what I have so far:

[PHP-DB] update db problem

2002-09-10 Thread chip . wiegand
I am making a web form for entering/editing/deleting items from a database, the entering and deleting parts work fine. The editing part is giving me some problems - Here's the code - List RMA's"; } elseif ($delete) { // delete a record $sql = "DELETE FROM rma WHERE id=$id";

RE: [PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Ryan Jameson (USA)
A bit of a strange way would be to always pop the window and at that point have the PHP decide what to put in there. If there is not offer you want to include you could simply thank them, or you could even produce an inline window.close(); javascript call. The only problem with that is that som

Re: [PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Petr Tomenendál
Hi. You cannot call PHP script from JavaScript in any simple way. It can be possibly done by including JavaScript code generated by PHP script through

Re: [PHP-DB] Multiple Sorts??

2002-09-10 Thread Petr Tomenendál
> $result = mysql_query("SELECT * FROM pfiles WHERE cdate >= '2002-07-01' > ORDER BY 'cdate' DESC", $link); > > I would like to be able to sort this data FIRST by 'cdate' then by 'vendor' > Is this possible? Yes. Just add another sort criterium to your query like this: $result = mysql_query("SE

Re: [PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Adam Voigt
Umm, the body tag in HTML has an onLoad parameter. So: That code for the window.new is probably wrong, but that will do it. Adam Voigt [EMAIL PROTECTED] On Tue, 2002-09-10 at 11:20, Aaron Wolski wrote: > Hi All, > > I HOPE this is the right place for this.. if not I am sorry!!! > > > > I'

[PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Aaron Wolski
Hi All, I HOPE this is the right place for this.. if not I am sorry!!! I'm hoping someone can put me on a clear path of how to do what I am asking here. I Have a shopping cart... and in this shopping cart I want to feature some items in a pop_up window when the user is ready to check out - if

[PHP-DB] Multiple Sorts??

2002-09-10 Thread Chase
Is there a way that I can sort data twice when it is being pulled from the DB? Here is a sample line of my code: $result = mysql_query("SELECT * FROM pfiles WHERE cdate >= '2002-07-01' ORDER BY 'cdate' DESC", $link); I would like to be able to sort this data FIRST by 'cdate' then by 'vendor' Is

Re: [PHP-DB] Problem with SQL

2002-09-10 Thread Maureen
Most likely the datatype you are using for the id field is tinyint, auto increment. The tinyint datatype only goes to 127, so once you get to 127, it tries to assign the same value for the next one. Try changing your id datatype to int. HTH Maureen Brtosz Matosiuk <[EMAIL PROTECTED]> sa

RE: [PHP-DB] FW: Php database support

2002-09-10 Thread Andrew Hill
David, You will be pleased with OpenLink Software's ODBC Drivers. This requires setting up PHP --with-iodbc, as per the HOWTO's on http://www.iodbc.org and the ODBC drivers are available as a free 30-day download from our site. Please let me know if you have any questions. Best regards, Andrew

Re: [PHP-DB] previous and next with postgresql

2002-09-10 Thread Andrey Sosnitsky
Hello, Angelo. Try pn.class.php at www.phpclasses.org AMR> I am trying to have previous and next links in my php script AMR> wich i make a select from a table. I am using postgresql AMR> anybody has a link for a tutorial or a sample code doing this? www.pskov.ru -- Best Regards, Andrey

[PHP-DB] previous and next with postgresql

2002-09-10 Thread Angelo Marcos Rigo
Hi I am trying to have previous and next links in my php script wich i make a select from a table. I am using postgresql anybody has a link for a tutorial or a sample code doing this? Ângelo Marcos Rigo Webmaster Colégio Anchieta http://www.colegioanchieta.g12.br -- PHP Database Mailing List

RE: [PHP-DB] php -> checkboxes -> mysql

2002-09-10 Thread Hutchins, Richard
Also check the archives for the php-db list. Questions very similar to this get asked just about every week and you might be able to find more information there. Rich -Original Message- From: nikos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:51 AM To: PHP-mailist Subje

Fw: [PHP-DB] whats wrong with my sql insert statement?

2002-09-10 Thread nikos
> Try remove (;) at the end of the expresion, before quote ("): VALUES > ('$first_name','$location','$phone', '$blabla')...(;)..." > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, September 10, 2002 4:38 AM > Subject: Re: [PHP-DB] whats wrong

Fw: [PHP-DB] php -> checkboxes -> mysql

2002-09-10 Thread nikos
> You should first check if checkbox value stored in the databese is 1 or 0. > After use an if clause: > if ($checkbox==1) { > echo "" > } > elseif ($checkbox==0) { > "" > } > > Nikos > -- -- > ---

Fw: [PHP-DB] Conversion from access to mysql

2002-09-10 Thread nikos
> You should install MyQDBC. Then use it to export the Access tables in MySQL > > Nikos > -- -- > -- > > - Original Message - > From: "Chris Grigor" <[EMAIL PROTECTED]> > To: <[EMAI

Fw: [PHP-DB] Conversion from access to mysql

2002-09-10 Thread nikos
> You should install MyQDBC. Then use it to export the Access tables in MySQL > > Nikos > -- -- > -- > > - Original Message - > From: "Chris Grigor" <[EMAIL PROTECTED]> > To: <[EMAI

Fw: [PHP-DB] Conversion from access to mysql

2002-09-10 Thread nikos
Untitled Document --- - Qbit &Ggr;&agr;&tgr;&sgr;&eeacgr;&sfgr; &Ngr;&iacgr;&kgr;&ogr;&sfgr; Web developer tel.: 0108256721 - 0108256722 fax: 0108256712 email: [EMAIL PROTECTED] http://www.qbit.gr - Original Message -

Re: [PHP-DB] Conversion from access to mysql

2002-09-10 Thread Hatem Ben
both tools don't work okay for me, i'm just using the export tool in MsAccess then convert database to xml, and thanks to PHP, i convert that to mysql queries. Just one problem when i want to convert binary data (pict or others), still haven't find a suitable solution for that. Best regards, Hat

Re: [PHP-DB] Conversion from access to mysql

2002-09-10 Thread Steven Dowd
also http://www.dbtools.com.br this will work both ways access<>mysql also supports excel , dbf, csv etc etc Steven - Original Message - From: "Chris Grigor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 10:47 AM Subject: [PHP-DB] Conversion from acces

SV: [PHP-DB] Conversion from access to mysql

2002-09-10 Thread Dann Pedersen
Hi, Check out MyAccess at http://www.accessmysql.com/. It works for me. The manual points out some things to keep in mind when converting. /Dann -Oprindelig meddelelse- Fra: Chris Grigor [mailto:[EMAIL PROTECTED]] Sendt: 10. september 2002 11:48 Til: [EMAIL PROTECTED] Emne: [PHP-DB] Con

[PHP-DB] Conversion from access to mysql

2002-09-10 Thread Chris Grigor
Hey there all This is more than likely a common question, anyone have any guidelines, do's or dont's about converting an access db to mysql db... Regards Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: assist with SORT array

2002-09-10 Thread Adam Royle
Bartosz was correct in saying that you should use your query to sort, rather than sorting array. And the array is actually sorted, although it keeps its index. See the manual reference on arrays to see how they work. To iterate over sorted arrays, use the foreach() construct. Anyway, the bette

Re: [PHP-DB] php -> checkboxes -> mysql

2002-09-10 Thread Ignatius Reilly
Try something like this: > (value is a dummy value - HTML will POST the name=value pair only if checked.) HTH Ignatius - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002