Re: [PHP-DB] DROP tables with prefix match

2002-05-15 Thread Jason Wong
On Thursday 16 May 2002 07:40, John Hughes wrote: > I need to rebuild a PHP-mySQL site that has an extensive table > structure. Is there a way to DROP all tables that start with a > certain prefix? If you have access to the server running mysql then you could try deleting the actual files holdin

RE: [PHP-DB] DROP tables with prefix match

2002-05-15 Thread Beau Lebens
if it's only a one-off thing, you could use php to get all table names (mysql_list_tables) and then go thru and create an array of the names that match your criteria, then go thru that array and DROP each one progressivly. HTH Beau // -Original Message- // From: John Hughes [mailto:[EMA

[PHP-DB] Re: email

2002-05-15 Thread Vinod Palan
Hi, you can collect the form content in to one Formated String and send mail to the admin with help of mail() function available in php http://www.php.net/manual/en/function.mail.php Hope this will help you. If not do feel free to getback. Thanks Vinod -- Vinod Palan A Calypso Technology, Inc.

Re: [PHP-DB] Global Connection object

2002-05-15 Thread Vinod Palan
Hi, I Think most of people put connection object in separate file and include the file when ever need. And in that connection file I open the connection and its available thought the file. Thanks Vinod -- Vinod Palan A Calypso Technology, Inc. [EMAIL PROTECTED] (415) 817-2463 Phone <[EMAIL PRO

[PHP-DB] DROP tables with prefix match

2002-05-15 Thread John Hughes
I need to rebuild a PHP-mySQL site that has an extensive table structure. Is there a way to DROP all tables that start with a certain prefix? __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP Database Mailing L

RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
So I can retrieve it in 4k pieces? That's cool. Thanks! <>< Ryan -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 4:37 PM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Text Field in SQL Server You can actually contro

Re: RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Frank M. Kromann
You can actually control this on the fly. odbc_binmode($iRecordSet, 2); odbc_longreadlen($iRecordSet, 4096); $str = ""; while ($temp = odbc_result($iRecordSet, "COLUMN_NAME")) $str .= $temp; This will set the block size to 4k and when you fetch data until the entire column has ben fetc

RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
BTW: 0 wasn't the right answer, but I get by with 10. :-) -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Text Field in SQL Server I got it: In php.ini there is a setting for ODBC called "odbc.defaultl

RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
I got it: In php.ini there is a setting for ODBC called "odbc.defaultlrl", if you change it to 0 it will hand over everything. <>< Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Text Field in SQL Server

[PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the database using PHP ODBC I don't get the whole thing. Anyone have any ideas? Thanks. <>< Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] session variables across several pages

2002-05-15 Thread Terry Romine
huh.. seems to work, now. I do the following: session_start(); session_register("form_data"); if($doAction) { switch($doAction) { case "Save Information": // save data in cookies $HTTP_SESSION_VARS['form_data'] = array($name,$employer,$e

RE: [PHP-DB] session variables across several pages

2002-05-15 Thread matt stewart
i would consider trying changing the variable names - so the field on the form would be called "address", therefore the variable passed through would be $address, and then have the session variable called "sess_address" or something like that, and then do $HTTP_SESSION_VARS['sess_address']=$ad

Re: [PHP-DB] session variables across several pages

2002-05-15 Thread Terry Romine
This is freaky. If I change the I can see the e_address coming in correctly, but it gets changed back to old value -- by the session_register('e_address')?? should I have something along the line of if(!$e_address) register_session('e_address'); ??? On Wednesday, May 15, 2002, at 09:

Re: [PHP-DB] session variables across several pages

2002-05-15 Thread Terry Romine
I believe you.. I added $HTTP_SESSION_VARS['e_address'] = $e_address; in my process form code and it's still not updating the var. snippit from select_class.php where I have reference to $e_address: session_register("e_address"); ... switch($doAction) {

RE: [PHP-DB] session variables across several pages

2002-05-15 Thread matt stewart
You need to look up $HTTP_SESSION_VARS['name'] - that's how to change the variables when they are already set.. i think most people have this problem when they first use sessions! -Original Message- From: Terry Romine [mailto:[EMAIL PROTECTED]] Sent: 15 May 2002 15:49 To: [EMAIL PROT

[PHP-DB] session variables across several pages

2002-05-15 Thread Terry Romine
First, forgive me if this seems to be cross post -- but it does involve both PHP and MySQL. My client requirements are: From their website, they display a list of classes. On registering for a class, the user is sent to a secure page that is hosted on a different secured server that does not

RE: [PHP-DB] php_close( ) not working on PHP+FreeTDS+UnixODBC+MSSQL7

2002-05-15 Thread Ryan Jameson (USA)
Are you using odbc_free_result before odbc_close? The documentation doesn't do it justice. For SQL server it seems to be the only way to release the connection. <>< Ryan -Original Message- From: Andrew Rall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:40 AM To: [EMAIL PROT

RE: [PHP-DB] radio buttons

2002-05-15 Thread Ryan Jameson (USA)
We need more of your code, as far as I can tell the variables $verify, and $first_reject don't exist and since they don't it doesn't matter which button is selected the value is blank. Radio buttons are a little odd... in this case depending on which is selected it will either assign $verify

[PHP-DB] radio buttons

2002-05-15 Thread Natividad Castro
Hi everyone, I have two radio buttons. Depending on what the users choose I will run an update statement. The field that needs to be update are code_source and verify if radio button 1 is selected ELSE UPDATE reason_rejected and first_reject if radio button 2 is selected this my two buttons Appro

[PHP-DB] php_close( ) not working on PHP+FreeTDS+UnixODBC+MSSQL7

2002-05-15 Thread Andrew Rall
I'm having a slight problem closing ODBC connections to my MSSQL7 server. My configuration is as follows Web server --- Redhat Linux 7.3 Apache-1.3.23-11 PHP-4.1.2-7 FreeTDS-0.53-1 unixODBC-2.2.0-5 SQL Server --- NT4.0+SP6a MS-SQL7.0+SP3 odbc_close($conid