[PHP-DB] passing parameters between forms

2001-04-02 Thread Sharmad Naik
Hi, I have created a database with following structure CREATE TABLE member( mem_id INT, name TEXT, age INT); the first page is as follows : !-- search1.html -- HTML BODY H1

[PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread Naga Sean
How to delete all the data in database, without delete the table. Looks like I can't delete all the data with single click in PHPmyAdmin mySQL -naga _ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List

[PHP-DB] SOLVED SORRY - Delete all Data and keep the Table

2001-04-02 Thread Naga Sean
How to delete all the data in database, without delete the table. Looks like I can't delete all the data with single click in PHPmyAdmin mySQL -naga _ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List

[PHP-DB] passing parameters between forms

2001-04-02 Thread Sharmad Naik
Hi, I have created a database with following structure CREATE TABLE member( mem_id INT, name TEXT, age INT); the first page is as follows : !-- search1.html -- HTML BODY H1 This is

RE: [PHP-DB] ecommerce - storing as an array or temporary record

2001-04-02 Thread Steve Brett
there is an excellent tutorial with a coded example of a shopping cart using sessions. http://www.phpbuilder.com/columns/evert2816.php3 only takes small mods to extend it so you can delete from cart as well. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential

Re: [PHP-DB] PHP an MySQL

2001-04-02 Thread Russ Michell
I have read and have reccommended several times: "PHP Fast and Easy Web Development" By Juli C Meloni. ISBN: 0-7615-3055-X Prima Tech publishing #---# "Believe nothing - consider everything"

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread Russ Michell
Using PhpMyAdmin click the 'empty' hyperlink. This will empty all the data from the table but not delete the table. HTH :) Russ #---# "Believe nothing - consider everything"

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread olinux
you can, choose the database on the left hand side and you will se all of your tables in that db on the right with the option to EMPTY olinux - Original Message - From: "Naga Sean" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 02, 2001 12:25 AM Subject: [PHP-DB] Delete all

[PHP-DB] MSSQL int field problem

2001-04-02 Thread Marck D. Pearlstone
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi php-db members, I'm not sure if this is the right forum to say this or if this is more of a PHP technical issue I have found a strange problem with the MSSQL interface. I have a small relational database and a PHP script which populates and

[PHP-DB] generating valid JS URL from database field with accents???

2001-04-02 Thread fabrizio . ermini
Hi all... I'm having a little problem in converting a site to spanish, due to - apparently - IE that doesn't like accented words. I have a db-driven website, of a fairly classical type - texts and image paths are stored in a DB, and pages are generated thru PHP. I'm converting this site

RE: [PHP-DB] CSS versus Includes

2001-04-02 Thread richarda
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] CSS versus Includes

2001-04-02 Thread Rubanowicz, Lisa
Hi there, you can also do it this way using Javascript script if (navigator.appName == "Netscape") { StyleSheet = "netstyle.css" } else { StyleSheet = "iestyle.css" } /script

RE: [PHP-DB] CSS versus Includes

2001-04-02 Thread richarda
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Stopping echo

2001-04-02 Thread Shannon Doyle
Hi People, Below I have included some code that just doesn't seem to be functioning all correctly. I have this running and it appears to stop the query/echo after the first entry in the database. What is it that I am doing wrong here?? Regards, Shannon ? $roundnum = ""; $sql = "select * from

[PHP-DB] Echo function stopping

2001-04-02 Thread Shannon Doyle
Hi People, Below I have included some code that just doesn't seem to be functioning all correctly. I have this running and it appears to stop the query/echo after the first entry in the database. What is it that I am doing wrong here?? Regards, Shannon ? $roundnum = ""; $sql = "select * from

[PHP-DB] MySQL maximums?

2001-04-02 Thread phobo
What is ... 1) The maximum number of tables in a database? 2) The maximum number of rows and 3) (most importantly) the maximum size of a MySQL MyISAM table ? (3.23.35) 1. I can find no documentation on this; assuming its atleast 2 bytes; or 65536 tables; this value is if no real concern. 2.

RE: [PHP-DB] array_diff usage

2001-04-02 Thread Mark Roedel
-Original Message- From: Martin Skjoldebrand [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 31, 2001 10:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] array_diff usage I'm daft. I don't understand the PHP Manual. I have two arrays: Open[0] contains 1 2 3 4 5 Closed[0]

[PHP-DB] Keeping Variables

2001-04-02 Thread Chris Hall
Hey guys, need somore help.. i need to pass a variable like $cr from view.php to comment.php..i thought there used to be a variable called $php_self, but i just searched the php.net site and nothin showed up...newaz any help is appreciated. thnx -- Chris Hall sytems administrator funnelbox

RE: [PHP-DB] Keeping Variables

2001-04-02 Thread Rubanowicz, Lisa
form method="post" action="?php echo $PHP_SELF?" I use this in forms to submit something to the same page and then do something like if($submit){ do this } Hope it helps Lisa -Original Message- From: Chris Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 9:13 AM To:

RE: [PHP-DB] Keeping Variables

2001-04-02 Thread Steve Brett
session_register("cr"); and then read the manual page on starting sessions etc ... Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for

Re: [PHP-DB] Keeping Variables

2001-04-02 Thread Russ Michell
Chris: in view.php: a href="anotherpage.php?cr=yes"Click here to see the value of cr/a in anotherpage.php: echo $cr; //outputs 'yes' Or: ?php form method=\"POST\" action=\"$PHP_SELF\" input type="hidden" name="arse" value="big" more form stuff etc etc yadda yadda yadda /form ?

[PHP-DB] Please help me with this script...

2001-04-02 Thread SliderĀ©
Hello, I've been working on this script all day, but I'm getting the same failure report each time: Warning: Supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\motoerit\toon_alles.php on line 23 What could be wrong? This is the code I have:

RE: [PHP-DB] array_diff usage

2001-04-02 Thread Martin
I'm daft. I don't understand the PHP Manual. I have two arrays: Open[0] contains 1 2 3 4 5 Closed[0] contains 1 2 Now: $test = array_diff($Open, $Closed); Given the setup you've described, I think you might actually want $test = array_diff($Open[0], $Closed[0]); OK

[PHP-DB] closing persisent connections

2001-04-02 Thread Nathaniel Dose
Hi - how are persistent connections closed once they're opened? is there a timeout or something that deactivates them? i just want to make sure they're not hanging around when they're not needed. Nathaniel Dose LeoMedia Berlin

RE: [PHP-DB] array_diff usage

2001-04-02 Thread Mark Roedel
-Original Message- From: Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 10:48 AM To: Mark Roedel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] array_diff usage This, on the other hand, makes me suspect that the arrays themselves don't actually contain what you

[PHP-DB] Getting a date from MS SQL in the correct format.

2001-04-02 Thread Richard Quadling
I want to extract a date from a datetime field in Microsoft SQL, via ODBC ('cause we support different databases, or so I'm told, and hey, what do I know! gr!). I want the format to be CCYYMMDD. Is there a MS SQL function for this? I've found DATEPART("",field), but I don't know

[PHP-DB] Solaris 2.6, PHP 4.0.4pl1, Solid EE 3.51

2001-04-02 Thread meiji
I'm trying compiling PHP4 with Solid once again (Dan Kalowsky advised me to repost here) and yet again I've hit a totally brick wall. 1, I'm not sure what is needed in the Solid lib directory and where I can get the files if they're not in the archive I've used to install Solid 2, Because

[PHP-DB] display login info

2001-04-02 Thread Liz Bander
I want to display a user's full name and user id that would be from their login action. (The login stuff is already set up.) How would I be able to grab the user id from the login? Any ideas on where to look? Thanks, Liz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] Please help me with this script...

2001-04-02 Thread Mark Roedel
-Original Message- From: Slider [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 9:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Please help me with this script... Hello, I've been working on this script all day, but I'm getting the same failure report each time:

[PHP-DB] duplicate a table

2001-04-02 Thread McShen
how do i duplicate a table? i tried create table refer2 select * from refer; create table refer2 as select * from refer; they didn't work. my mysql version is mysql 3.22.28, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] duplicate a table

2001-04-02 Thread dime
And to go one step further with his question, I would like to know how to do the following: 2 tables named table1 and table2 table1 contains 3 records, firstname, lastname, password. table2 is the same except that it has one more field at the beginning and that field is of type serial. Now,

RE: [PHP-DB] PHP on WIN32 with DB2 CLI

2001-04-02 Thread Chris Book
Well in linux I use the CLI interface from php to run all my queries. I read somewhere that the native CLI interface was faster than using the ODBC driver. I have the ODBC driver working properly, I just wanted to know if it was possible to use CLI with PHP in windows (like on Linux). I guess

[PHP-DB] easy db question

2001-04-02 Thread Paulson, Joseph V. \Jay\
hello everyone- I'm running MySQL 3.23.27-beta with php 4.04pl1. What I am wondering is I have an auto incrementing field and if I delete all the entries in the table with this field the incrementing doesn't start over. For example, if I insert 6 records for the first time into this table the

[PHP-DB] Validating forms

2001-04-02 Thread Julio Cuz, Jr.
Hi-- I have a form that cannot have a specific field blank, so I would like to add a message box saying "fill out the x field," is there a way to do this WITHOUT having to refresh the page? Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List

RE: [PHP-DB] easy db question

2001-04-02 Thread Oson, Chris M.
joseph, This was a feature that was recently modified. Older versions of mySQL support the feature that you seem to want. 3.23.xx and above will support the feature that you have just described. If you want to roll your own out, you could do something like... mysql SELECT

Re: [PHP-DB] Validating forms

2001-04-02 Thread Manuel Lemos
Hello, "Julio Cuz, Jr." wrote: Hi-- I have a form that cannot have a specific field blank, so I would like to add a message box saying "fill out the x field," is there a way to do this WITHOUT having to refresh the page? Maybe you would like to try this PHP form generation and

RE: [PHP-DB] How to limit a WHILE statement?

2001-04-02 Thread David Balatero
Ok, in your $sql var, put: $sql = "SELECT * FROM table LIMIT 20"; Leave the other code intact. This fetches 20 rows from MySQL. -- David Balatero -Original Message- From: Bob Stone [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 3:53 PM To: [EMAIL PROTECTED] Subject: [PHP-DB]

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Naga Sean) wrote: How to delete all the data in database, without delete the table. Do you want to delete every *table* in the *database*, or delete every *row* in the *table*? Assuming the latter, "delete from database_name". -- CC -- PHP

[PHP-DB] Need Help

2001-04-02 Thread Chris Brunelle
Okay, Im having some problem using setcookie(). Basically, I have to form fields, Username/Login. When the username and login are authenticated using mysql, it logs into the secure area. I set the cookie so taht it takes the $username variable that the user entered into the form and on the

RE: [PHP-DB] How to limit a WHILE statement?

2001-04-02 Thread Brian Hardwick
Your might want to consider limiting the records selected. For example "select emp_name from employees limit 0,20". Alternatively consider using a a "for" statement. - Brian Hardwick Tangible Networks. -Original Message- From: Bob Stone [mailto:[EMAIL PROTECTED]] Sent: Monday, April

RE: [PHP-DB] help with compiling ODBC into PHP4

2001-04-02 Thread Daevid Vincent
Okay, don't ask me how, but for whatever reason, this "partially worked": "./configure --with-openlink=/usr/local/openlink/odbcsdk --with-mysql=/usr/l ocal --with-apache=../apache" however, now I get a different error: In file included from internal_functions.c:38:

[PHP-DB] Re: [PHP] RE: [PHP-DB] help with compiling ODBC into PHP4

2001-04-02 Thread Andrew Hill
Daevid, You shouldn't need iodbc.h, just odbc.h - until I can compare what is each SDK distribution, just create a symbolic link of iodbc.h pointing to odbc.h udbcext.h is in our iODBC SDK - you should have that. Here is the linux glibc2.1.1 version:

[PHP-DB] Auto load PHP

2001-04-02 Thread Jim Ray
Is there a way, once updating a table to load another PHP? After, I have the user click on the save button, the code calls a update routine. After the UPDATE is done, I want the code to call another progam. Thank you. Jim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] PHP4.0.4 segfaults with odbc_pconnect

2001-04-02 Thread Daevid Vincent
I've tried this with both PHP4.0.4 and PHP4.0.4pl1 as a module (it's for a daily script eventually). [root=pts/1]7:29pm@content:{/www/html/private/TattooShop} ./odbc-test2.phtml #!/bin/php -q Segmentation fault the relevant part of phpinfo(); is below, so I'm assuming that I finally got odbc

Re: [PHP-DB] Validating forms

2001-04-02 Thread Phil Jackson
Julio, It is much more efficient to do that type of validation client-side, using Javascript. No sense in making another round trip to the server if not necessary. Here is a quicke example: if (document.autoform.txtVehicleNumber.value == ""){ document.autoform.txtVehicleNumber.focus()

Re: [PHP-DB] metabase support

2001-04-02 Thread Joe Brown
I am a little less biased ;-) I think Manuel's Metabase is the bomb. Unfortunatly, so does Windows... Metabase provides some truely wonderful features. On Windows, Metabase with OCI8 my server keep performing illegeal instructions. I think this is a lack of PHP's maturity on Win32, not

Re: [PHP-DB] PHP4.0.4 segfaults with odbc_pconnect

2001-04-02 Thread Andrew Hill
Daevid, connection script snipped (looked fine) $dsn="DSN=OpenLink"; // this is a valid DSN set up in the above odbc.ini //$conn_id = odbc_connect("DSN=OpenLink;UID=daevid;PWD=secret","",""); ? -- [OpenLink] Driver = /usr/local/openlink/lib/oplodbc.so.1

RE: [PHP-DB] Auto load PHP

2001-04-02 Thread David Balatero
Maybe after the UPDATE statement, you could do: ?php header("Location: /path/to/other/script.php"); ? ...but I don't know, I don't use header() that much. -- David Balatero -Original Message- From: Jim Ray [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 6:23 PM To: [EMAIL