[PHP] Mcrypt: just a little tip:-)

2001-08-22 Thread Alex Piaz
Hi Folks! I am working on a project where I need to encrypt some data that will be decrypted later by a visual basic application and also receive encrypted data from that application and decrypt it on the webserver. To exchange the data, I did some xml and everything went fine, but I can't

[PHP] Executing perl scripts in a unix environment running php cgi-module

2001-08-22 Thread Shane Reid
Running the cgi-module trying to execute a perl script, dug through the archives found something that would at least return something: exec(/full/path/to/file.cgi, $results, $errorCode); while (list(,$line) = each($results)){ echo $line, BR\n; } if ($errorCode){ echo OS Error:

[PHP] 2 NEWBIE QUESTIONS

2001-08-22 Thread Georgie
1) Is there any PHP command that'll convert a MySQL database timestamp into a format that humans can read?!! For example, I want to change 20010822001245 into 00:12.45 on the 22-08-2001? 2) This is the hard question. I have a script that gets values from a database and then includes a php page

RE: [PHP] 2 NEWBIE QUESTIONS

2001-08-22 Thread Jason Murray
1) Is there any PHP command that'll convert a MySQL database timestamp into a format that humans can read?!! For example, I want to change 20010822001245 into 00:12.45 on the 22-08-2001? ? function dateMysqlToUnix($mysqltime) { $stamp = ereg_replace([^0-9], , $mysqltime);

RE: [PHP] 2 NEWBIE QUESTIONS

2001-08-22 Thread Kees Hoekzema
hey, 1) Is there any PHP command that'll convert a MySQL database timestamp into a format that humans can read?!! For example, I want to change 20010822001245 into 00:12.45 on the 22-08-2001? take a look at: http://www.php.net/manual/en/function.date.php 2) This is the hard question. I

RE: [PHP] 2 NEWBIE QUESTIONS

2001-08-22 Thread Matthew Loff
1) strftime(%T on the %D, strtotime($yourdate)); Should produce: 00:12:45 on the 08-22-2001 You can check the manual page for strftime() to see different ways to format the time to your liking: http://www.php.net/manual/en/function.strftime.php 2) The way you're trying to do that sounds

RE: [PHP] Random PowerBall Generator

2001-08-22 Thread Jerry Lake
if array_unique does what I think, The biggest problem with that is that Powerball being a reasonable semblance of random, does allow non-unique series to be selected. i.e. the powerball can be the same as one of the other five. Jerry Lake Interface Engineering Technician -Original

Re: [PHP] Creditcard checksum and identification

2001-08-22 Thread Egan
On Thu, 23 Aug 2001 00:22:28 +0200, Peter Ostry [EMAIL PROTECTED] wrote: Has anyone a PHP Script for the checksum of Creditcards? And a Script which can identify card types based on their first numbers? (VISA, AMEX, MASTER, DINERS, JBC, DISCOVERY) There where a lot of JavaScript pages on the

RE: [PHP] Creditcard checksum and identification

2001-08-22 Thread Jason Murray
Here's what I pulled from px.sklar.com and modified to suit my own devious ends... :) ? Function verifyCreditCard ($Number, $creditcardtype = ) { // Nicked this from: http://www.analysisandsolutions.com/code/ccvs-ph.htm // Checks the 1st 4 digits for validity, then checks

[PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread Seb Frost
Or is PHP the be-all and end all? I know its strong points, but what are the WEAK points of PHP? - seb -- PHP General 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:

Re: [PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread John Meyer
At 01:10 AM 8/23/01 +0100, you wrote: Or is PHP the be-all and end all? I know its strong points, but what are the WEAK points of PHP? - seb PHP isn't default on Microsoft systems You have to learn a new language for PHP: ASP is basically either VBScript or JScript around some objects. To

Re: [PHP] HTTP headers and include()

2001-08-22 Thread Casteele/ShadowLord
Andy [EMAIL PROTECTED] wrote in article 003b01c12b23$d1f245d0$0b01a8c0@ANDreY... See if is there some kind of echo before header()s, or HTML sent to browser. No, I've been extremely careful to avoid that. The following are the two test files I've been using to try to solve this.. (sans

RE: [PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread Seb Frost
Ah ha, but am I better off becoming a PHP guru or a jackofalltrades-notverygoodatanyofthem kind of person ;-) Well I've never used scripting of any sort before PHP, just c++ really. I'll stick to php i guess (for now). - seb -Original Message- From: John Meyer [mailto:[EMAIL

[PHP] Email this page to a friend

2001-08-22 Thread Seb Frost
How can I implement this in php? -seb -- PHP General 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] Re: imagemagick and file size

2001-08-22 Thread Richard Lynch
function example() { $convert = cat $userfile | /usr/X11R6/bin/convert - $type:-; return `$convert`; } the returned binary value is uploaded to the DB. My main problem is that I don't know how to measure the decreased image size while its stored in the variable. Use

[PHP] Re: column_name

2001-08-22 Thread Richard Lynch
I was wondering if there was a way to retreive a column_name instead of a value in a query? For example if my table has the fieldfirstname, lastname, telephone, movie1, movie2, movie3.. And my first record is JohnDoe 555- good bad bad

[PHP] Re: Problems benchmarking php Scripts

2001-08-22 Thread Richard Lynch
I have been trying to benchmark the backend scripting for a flash online game, for this purpose i wrote another PHP Script that uses fopen to make exactly the same requests the flash movie would make with the same timing, and writes a log of the game session into a database. I run this script

Re: [PHP] Concept of Templates

2001-08-22 Thread Richard Lynch
Does the link itself send any information someplace that tells the server what information is needed and how it has to be performed or placed? By definition, this must be true. (Short of some stupid JavaScript hack that would really suck...) You'll have to design your system such that

[PHP] Re: someone please explain weird getforeignkeys

2001-08-22 Thread Richard Lynch
I need to look up a table's foreign keys using the unified ODBC-functions. 'odbc_foreignkeys()' requires me to pass seven parameters, each of them being mandatory, to archive this. Yes. Because the approach is not intuitive anyhow and there is no documentation available except of the

[PHP] Re: COM

2001-08-22 Thread Richard Lynch
I heard refs on using the COM interface to access MS Word files. Is this a procedure an interface that only works on Windows systems (as that is where Word runs)? Yes... Almost for sure... There *MIGHT* be some hack port of COM objects to Un*x, but you'd be better off using a doc2xxx

[PHP] Re: Move recordset to first record problems...

2001-08-22 Thread Richard Lynch
How to move recordset to the first record (i use to connect to database using ODBC). http://php.net/manual/en/function.odbc-fetch-row.php To step through the result more than once, you can call odbc_fetch_row() with row_number 1, and then continue doing odbc_fetch_row() without row_number to

[PHP] Re: Cant load dynamic library.... whats up?

2001-08-22 Thread Richard Lynch
- extension_dir = c:\windows\system\ Try / instead of \ -- WARNING [EMAIL PROTECTED] address is an endangered species -- Use [EMAIL PROTECTED] Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm -- PHP General

Re: [PHP] HTTP headers and include()

2001-08-22 Thread David Robley
On Thu, 23 Aug 2001 10:06, Casteele/ShadowLord wrote: Andy [EMAIL PROTECTED] wrote in article 003b01c12b23$d1f245d0$0b01a8c0@ANDreY... See if is there some kind of echo before header()s, or HTML sent to browser. No, I've been extremely careful to avoid that. The following are the two

RE: [PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread Jack Dempsey
Seb, I think the answer, tho it may not be a great one, is to become a jackofalltrades-verygoodatallofthem kind of person if you truly want to make yourself stand out... Whether you love php or not, you have to respect the power it gives you and the ease with which you can develop with it.

RE: [PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread John Meyer
At 01:29 AM 8/23/01 +0100, you wrote: Ah ha, but am I better off becoming a PHP guru or a jackofalltrades-notverygoodatanyofthem kind of person ;-) I don't know. I've learned both PHP and ASP, and neither of them have decreased the other in terms of learning. The fact is, you are going to

[PHP] insert hyperlink to mysql query result

2001-08-22 Thread Andras Kende
Hello, I have a mysql query with addresses , trying to insert a link to a map line 51 echo /tdtdfont face=verdana size=1pa href=http://www.expedia.com/pub/agent.dll?qscr=mcststrt1=$amyrow[address;] city1=$amyrow[city]stnm1=CAzipc1=cnty1=4Map/p; echo /td; Error Message: Parse error: parse

[PHP] Re: php-counter

2001-08-22 Thread Raphael Pirker
http://php.resourceindex.com/Complete_Scripts/Access_Counters/ -- PHP General 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] insert hyperlink to mysql query result

2001-08-22 Thread ReDucTor
echo /tdtdfont face=verdana size=1pa href=http://www.expedia.com/pub/agent.dll?qscr=mcststrt1=.$amyrow[address ]. city1=.$amyrow[city].stnm1=CAzipc1=cnty1=4Map/p; echo /td; - Original Message - From: Andras Kende [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001

Re: [PHP] insert hyperlink to mysql query result

2001-08-22 Thread David Robley
On Thu, 23 Aug 2001 10:56, Andras Kende wrote: Hello, I have a mysql query with addresses , trying to insert a link to a map line 51 echo /tdtdfont face=verdana size=1pa href=http://www.expedia.com/pub/agent.dll?qscr=mcststrt1=$amyrow[addr ess]

RE: [PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread Dave
I would say that depends on what platform you wish to market yourself on. Being of *nix mind... PHP works beautifully for virtually all aspects of Web based scripting, and personally i use it for a vast majority of server scripting as well. And if not, it isn't a far cry from Perl syntax and

[PHP] using PHP to browse and select a file on a Windows machine

2001-08-22 Thread Don
Hi, I am running PHP 4.01 in a FreeBSD environment with Apache server. Is there a way I can use PHP to browse the users PC and choose a file (choose = placing it in a text box)? Thanks, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP] path to php

2001-08-22 Thread ReDucTor
does anyone know all the possible paths to php...because i can't seem to find it on my current host...i have tried using the following php /path/to/script.php /usr/php /path/to/script.php /usr/local/bin/php /path/to/script.php /usr/bin/php /path/to/script.php but i still can't seem to get it to

[PHP] using PHP to browse and select a file on a local machine

2001-08-22 Thread Don
Hi, I am running PHP 4.01 in a FreeBSD environment with Apache server. Is there a way I can use PHP to browse the users PC and choose a file (choose = placing it in a text box)? Thanks, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP] Re: strange upload/db-insert problem with ie5.5

2001-08-22 Thread Serge Adamowsky
hey, thanks for the reply, richard yes, most is done in one script, the very last step was because i had to reuse the code and didn't want to forcefully merge it into my script. btw, i solved my inital problem, i had to revisit the designer's html-code, duh ;) next time i will be more

[PHP] GET method and forms....

2001-08-22 Thread Seb Frost
how do I prevent getting submit=shop%21 in the url window? form method=GET action=page.php4 pEmail address: input type=text name=email size=20 input type=submit value=Shop! name=submit /form - seb -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail:

Re: [PHP] GET method and forms....

2001-08-22 Thread ERISEN, Mehmet Kamil
instead of method=GET use method=POST --- Seb Frost [EMAIL PROTECTED] wrote: how do I prevent getting submit=shop%21 in the url window? form method=GET action=page.php4 pEmail address: input type=text name=email size=20 input type=submit value=Shop! name=submit

Re: [PHP] path to php

2001-08-22 Thread David Robley
On Thu, 23 Aug 2001 11:05, ReDucTor wrote: does anyone know all the possible paths to php...because i can't seem to find it on my current host...i have tried using the following php /path/to/script.php /usr/php /path/to/script.php /usr/local/bin/php /path/to/script.php /usr/bin/php

RE: [PHP] GET method and forms....

2001-08-22 Thread Seb Frost
But I have good reason to use get, I want all the other variables to become part of the url. - seb -Original Message- From: ERISEN, Mehmet Kamil [mailto:[EMAIL PROTECTED]] Sent: 23 August 2001 03:10 To: Seb Frost; [EMAIL PROTECTED] Subject: Re: [PHP] GET method and forms instead

Re: [PHP] using PHP to browse and select a file on a local machine

2001-08-22 Thread David Robley
On Thu, 23 Aug 2001 11:11, Don wrote: Hi, I am running PHP 4.01 in a FreeBSD environment with Apache server. Is there a way I can use PHP to browse the users PC and choose a file (choose = placing it in a text box)? Thanks, Don Forrtunately , no. I wouldn't want someone wandering around

[PHP] The future of PHP

2001-08-22 Thread Thomas Deliduka
A little background... Skip to THE JIST if you wanna make this quick. I am on this webmaster's list where most of the people are fairly new webmasters. They're just getting the hang of things. I am probably one of the only advanced ones on there (not to toot my own horn really) and I'm one of

[PHP] Re: The future of PHP

2001-08-22 Thread Elias Santiago
Thomas Deliduka [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... A little background... Skip to THE JIST if you wanna make this quick. I am on this webmaster's list where most of the people are fairly new webmasters. They're just getting the hang of things. I am

RE: [PHP] Help alleviate the U.S. Nursing Shortage and Profit in

2001-08-22 Thread Don Read
On 22-Aug-2001 Jess Ragaza wrote: snip It would seem like the nursing shortage here would be for years to come. No doubt. I'll check with Mom, but I don't think i've nursed in some 40 years. -- Don Read [EMAIL PROTECTED] -- It's always darkest

Re: [PHP] The future of PHP

2001-08-22 Thread Rasmus Lerdorf
So, the jist is, what does PHP have to offer to the web in the future? I think it's still a viable option that will be around for at least another 6-7 years. This kid thinks it's shelf life is another 3. What do ya'll think? Personally I would be a hell of a lot more worried if I was in

Re: [PHP] Any point in learning ASP/JSP etc?

2001-08-22 Thread Elias Santiago
I have learned (and used) both PHP and ASP. However, when I was beginning with PHP, I always made it first on ASP then re-implemented on PHP. I always found PHP to be easier, shorter (but more powerful) logic (scripts are shorter than ASP). I guess it has served me well, I have learned to do

Re: [PHP] The future of PHP

2001-08-22 Thread Elias Santiago
Just by looking at M$ history we all know that their only interest is $$money$$. Even if the product is not fully tested/bug-free and if 20% of it works, they spit it out and leave the dirty work (and headaches) to the system administrators and everyone else who's not a plain non-technical user

[PHP] Looking for PHP job in US

2001-08-22 Thread Gregory
Hi! The company, I was working for, cut 30% of it's power in one day. So, I'm looking for a PHP related job in US. My major experience is PHP/Perl/C++/JavaScript/DHTML front-end and back-end development using various DBMS like MySQL, PosgreSQL, Oracle and other. Here is my short resume. If

Re: [PHP] Re: The future of PHP

2001-08-22 Thread Thomas Deliduka
On 8/22/2001 10:52 PM this was written: I don't know if you refer to this list or other one, but I've been a webmaster since 1993 and in computers in general since 1988 and I also consider myself of the advanced type. It definitely wasn't this list. It's another one. -- Thomas Deliduka IT

[PHP] Advanced Form Processing HELP

2001-08-22 Thread Arcadius A.
Hello ! I have a simple form (feedback.php) that could allow users to send me seedbacks... the form is processed(email is sent ) by the script confirm.php. My question is : How could i make the values filled in the form remain unchanged even after the user click on the browser Refresh/Reload

[PHP] Sorting IP Address Data

2001-08-22 Thread Chris Aitken
Hi all, Just a quick one, I am pulling a whole Class C list of IP addresses, and im trying to sort them in order, but im getting it displayed 127.0.0.1 127.0.0.10 127.0.0.100 127.0.0.101 127.0.0.102 etc. Is there any other way to sort this thinking they are numbers, rather than text ?

[PHP] Re: how to disable the automated userID/password in Internet Explor er

2001-08-22 Thread Elias Santiago
You need to go to: Tools - Internet Options - Content (tab) - Autocomplete - clear the box beneath User names and passwords on forms also press Clear Passwords if you're concerned about passwords being remembered. Just check/uncheck the options you need. Gabe Da Silveira [EMAIL PROTECTED]

Re: [PHP] Re: force download in IE -- conclusion

2001-08-22 Thread Elias Santiago
Not necessarily an answer but on my work (a computer center for medical students) we use a propietary Perl web-based course software and when doing attachments on email messages on the system's bulletin board, the system sends a header with appplication/octet-stream and IE 5.5 attaches the .html

Re: [PHP] Sorting IP Address Data

2001-08-22 Thread Chris Fry
Chris, What order are you trying to achieve? These look to be in order? Chris Chris Aitken wrote: Hi all, Just a quick one, I am pulling a whole Class C list of IP addresses, and im trying to sort them in order, but im getting it displayed 127.0.0.1 127.0.0.10 127.0.0.100

[PHP] Re: Advanced Form Processing HELP

2001-08-22 Thread Lang Sharpe
Can't be done AFAIK. Because your webserver never receives the information when the page is reloaded, you can't send it back to him when he reloads. Lang Sharpe Arcadius A. wrote: Hello ! I have a simple form (feedback.php) that could allow users to send me seedbacks... the form is

Re: [PHP] Re: if statement and imageline()

2001-08-22 Thread Hugh Danaher
Richard, Thanks for your help. I'll try the error_log() and see what comes out. Hugh - Original Message - From: Richard Lynch [EMAIL PROTECTED] To: Hugh Danaher [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 1:21 PM Subject: Re: [PHP] Re: if statement and imageline() No. 150

[PHP] Problems compiling with Apache 2.0 Alpha 22

2001-08-22 Thread The Doctor
Can anyone explain what I am getting this? Script started on Wed Aug 22 21:34:29 2001 doctor.nl2k.ab.ca//usr/source/php-4.0.6$ config2phpdso loading cache ./config.cache checking for a BSD compatible install... (cached) /usr/bin/install -c checking whether build environment is sane... yes

[PHP] Re: Sorting IP Address Data

2001-08-22 Thread Raphael Pirker
127.0.0.1 127.0.0.10 127.0.0.100 127.0.0.101 127.0.0.102 well, this looks pretty sorted to me :) you wanted them sorted by numeric value, right?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP] $HTTP_REFERER problem

2001-08-22 Thread pekesan
I know that some browsers doesn't gives support to $HTTP_REFERER variable ( lynx in example). I am thinking on checking the browser ident (with HTTP_USER_AGENT) and managing $HTTP_REFERER as a session var in those cases who doesn't give support. But it would be great that if somebody found

[PHP] Re: Sorting IP Address Data

2001-08-22 Thread Gregory
That looks clumsy, but it will work : you could make a multidimensional hash (treat it like table) like ips[first][x] ips[second][x] etc it is like table ips: first | second | third | etc - 127 |0 | 0 | 127. |0 | 1 |

Re: [PHP] Re: COM

2001-08-22 Thread Lara J. Fabans
At 05:40 PM 8/22/2001 -0500, Richard Lynch wrote: I heard refs on using the COM interface to access MS Word files. Is this a procedure an interface that only works on Windows systems (as that is where Word runs)? Yes... Almost for sure... There *MIGHT* be some hack port of COM objects

[PHP] Re: GET method and forms....

2001-08-22 Thread Gregory
Use button element instead of submit like this: button onClick=this.form.submit() value=Submit this form Gregory Seb Frost [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... how do I prevent getting submit=shop%21 in the url window? form method=GET action=page.php4

Re: [PHP] GET method and forms....

2001-08-22 Thread Egan
On Thu, 23 Aug 2001 03:23:16 +0100, Seb Frost [EMAIL PROTECTED] wrote: how do I prevent getting submit=shop%21 in the url window? reason to use get, I want variables to become part of the url. Using a frameset prevents the GET url from appearing in the browser window, if that's all you want

[PHP] Re: Advanced Form Processing HELP

2001-08-22 Thread Raphael Pirker
Lang Sharpe [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Can't be done AFAIK. Because your webserver never receives the information when the page is reloaded, you can't send it back to him when he reloads. only partly correct. it can't be done using PHP (and

Re: [PHP] Advanced Form Processing HELP

2001-08-22 Thread Egan
On Thu, 23 Aug 2001 05:24:17 -0700, Arcadius A. [EMAIL PROTECTED] wrote: : How could i make the values filled in the form remain unchanged even after the user click on the browser Refresh/Reload button without submittingf the form ? Until they submit the form, PHP has nothing to act on.

Re: [PHP] Sorting IP Address Data

2001-08-22 Thread Chris Fry
Chris, Understand the problem now. All you need to keep is the last octect of the IP Address. The following code snippet generates an array entry for each ip. The array is then sorted and the result prepended with the base IP. ? $strBaseIP = 127.0.0.; for ($i=0;$i=255;$i++) { $strIP

[PHP] Sablotron configure options...

2001-08-22 Thread Darron Froese
Do I need to use --enable-xslt as this bug report seems to indicate? http://www.php.net/bugs.php?id=8412edit=1 Or are these enough to enable Sablotron and get XSLT processing properly: --with-sablot --with-xslt-sablot --with-expat-dir=/usr It appears to be basically functional - transforms

[PHP] Sablotron and remote URI's

2001-08-22 Thread Darron Froese
For some reason - this works just fine: $processor = xslt_create(); xslt_run($processor, 'diary.xsl', 'test.xml'); print xslt_fetch_result($processor); xslt_free($processor); While this doesn't work at all: $processor = xslt_create(); xslt_run($processor, 'diary.xsl',

[PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Gabe da Silveira
I know nothing about this, but did you investigate 'SHOW TABLE STATUS' for any clues? In article 018601c12b3c$2c2970b0$6e00a8c0@webdesign, [EMAIL PROTECTED] (Jay Paulson) wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p

RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
On 22-Aug-2001 Jay Paulson wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops...

RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
On 22-Aug-2001 Jay Paulson wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops...

[PHP] Move recordset to first record problems...

2001-08-22 Thread Veniamin Goldin
Please help me ! How to move recordset to the first record (i use to connect to database using ODBC). Thank you ! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP] Re: [PHP-DB] Move recordset to first record problems...

2001-08-22 Thread Miles Thompson
I guess it depends on the ODBC driver. If it lets you pass commands directly to the database, something like s SQL_PASSTHRU, use that faciity. Otherwise use the SELECT command to fetch the first record. Normally this is a two step process: execute the select, then use a while loop to step

[PHP] MySQL read only?

2001-08-22 Thread Jay Paulson
Anyone know why a MySQL table is set to read only? I'm logged in as the root user of MySQL and I have checked the privalages of the root user in the MySQL table and everything is set to Yes and I'm able to add and delete users in the MySQL table. Here's what I did... I had a database on my

[PHP] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
Hello everyone- I have done the mysqldump function and got the db in a all_database.sql file. Now I am running this command at the shell prompt of my Linux machine: mysql -u root -p -e 'all_databases.sql' When I do that it works fine until it starts to insert the information into the

[PHP] RE: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Rick Emery
Are your privileges in MySQL set correctly? If ROOT doesn't have read/write access, the script will crash. rick -Original Message- From: Jay Paulson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 11:29 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] restoring

[PHP] Re: MySQL read only?

2001-08-22 Thread Gabe da Silveira
This would probably be a better question for a MySQL newsgroup... Anyway, I am just talking off the top of myhead since I never did anything like this, but i don't think copying DB files is the proper way to move databases. I believe there is some MySQL dump utility you need to create one

[PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops... jay - Original Message - From:

<    1   2