[PHP-DB] Stress Test Script?

Does anyone have a good php script that will test (i.e. benchmark) my MySQL machine and my Web server? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php and db/c

, returning -1 (empty set) for the odbc_num_rows(). When we make a raw odbc connection to run a direct sql query on the data, it all shows up fine. There is some miscommunication between odbc and php that is eluding us. Any input or suggestions would be welcomed. Thank you, Jay Merritt [EMAIL PROTECTED

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

to find out if an array is empty use: empty() it must be unset NULL returns false 0 returns false it must be truly empty to return true... Ok... well When I select the select product which has a option value= it tells me the count is one (1). If I select an ACTUAL product it tells me

[PHP-DB] Sum function for multiple recordsets?

? And is this even the best way to approach it? Cheers, Jay

[PHP-DB] file() shooting blanks - importing fixed width file for use in MySQL

Hello, I have an ASCII fixed width text file I'm trying to convert to an array of fields. When I use file() to place each line (record) in it's own array element, it strips out any blanks it finds except one. This results in in ABC MOTORS becoming ABC MOTORS. That creates a problem if ABC is

[PHP-DB] MySQL read only?

but that didn't help. I'm wondering if it's a setting in MySQL. Can someone point me in the right direction for getting the Update and Inserting fixed? Thanks! Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

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

actually the owner of the tables/files that all_databases.sql creates is mysql.mysql.. and it still says read only.. and they are chmod'ed to 660... like i said before i'm really lost as to why it's doing this. jay - Original Message - From: Brunner, Daniel [EMAIL PROTECTED] To: 'Jay

[PHP-DB] MySQL ERROR 1036: Table 'foo' is read only

'foo' is read only. Anyone know why this is happening and or how to fix it? Thanks, Jay -- 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] restoring mysql db after mysqldump

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

[PHP-DB] MySQL read only?

a difference if I was using a earlier version of MySQL on my Win2k machine than on the RedHat machine? Anyway, I'm at a total lost here so any help would be great! Thanks, Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

[PHP-DB] Last Modified question..

and I don't want to change the permissions of the file. Is there an easy way to check to see when the last time anyone logged in and updated their 'employee' information? Thanks, jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Last Modified question..

A) It's a MySQL database that I'm using B) I'm using file_exsist() and to check the modified date I'm using filemtime() C) If I modify the permissions on the file wouldn't that possibly cause some security issues? Thanks, jay - Original Message - From: Justin Buist [EMAIL PROTECTED

[PHP-DB] Update Query?

that I'm using to build it. Any suggestions? update news set newsOrder=2 where station_id=5 and id=3 $query = update news set newsOrder=.$order. where station_id=$stationid and id=.$orderNewsID; thanks, jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Newbie Question

for your time, Jay Fitzgerald, Design Director - CSBW-A, CPW-A, CWD-A, CEMS-A == Bayou Internet..(888) 30-BAYOUhttp://www.bayou.com Mississippi Internet...(800) MISSISSIPPI...http

Re: [PHP-DB] RE: [PHP] Newbie Question

| ++--+--++-+-+--+--++--+ | 1 | test | test | test | test| 1 2 3 4 5 6 7 8 9 | test | test | test | test | ++--+--++-+-+--+--++--+ === is this in fact normal? Jay

[PHP-DB] what version of Oracle does php_oci8.dll support?

the following error when I start my Apache service: The procedure entry point OCILobClose could not be located in the dynamic link library OCI.dll Does this mean I can't use the php_oci8.dll functionality? Thanks. -- Jay Dickon Glanville -- PHP Database Mailing List (http://www.php.net

[PHP-DB] RE: [PHP] Ho to write output of sql query to txt file?

TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM test_table; HTH! Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] Ho to write output of sql query to txt file?

are totally empty. Only default of the columns is set. [/snip] Did you remember to add a field seperator? That seems the likely cause of the problem. Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] dumping only selected records into another table

the ID included? [/snip] RTFMySQLM http://www.mysql.com/doc/I/N/INSERT_SELECT.html HTH! Jay It's hip to snip! Give a man a program, frustrate him for a day. Teach a man to program, frustrate him for a lifetime. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area

a user group in your area if you live near a major city. According to the PHPusergroups.org web site [http://www.phpusergroups.org/groups.phtml?menu=groups] there 189 PHP user groups in 52 countries. Jay Chaos, panic disorder…my work here is done! -- PHP Database Mailing List (http://www.php.net

[PHP-DB] RE: PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area

member. Just want to keep this fresh in everyone's mind. If you know of other developer lists where php is discussed please forward this along. Thanks! Jay Do not meddle in the affairs of dragons-for you are crunchy and good with ketchup -- PHP Database Mailing List (http://www.php.net

[PHP-DB] RE: [PHP] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users

computer users groups in your area and you may be surprised at what pops-up. Jay LOTTERY: A tax on people who are bad at math *** * * * Texas PHP Developers Meeting* * Spring 2003 * * T Bar M

[PHP-DB] RE: [PHP] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users

. Thanks! Jay It’s as bad as you think, and they are out to get you. *** * * * Texas PHP Developers Meeting* * Spring 2003 * * T Bar M Resort Conference Center * * New Braunfels, Texas

[PHP-DB] RE: [PHP] php|cruise - do unto others...

, but I've never seen (to my recollection) one done directly before. Thanks! Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] Changing case

[snip] The problem is if someone enters aa-1234 and the other items in the quote are FF-2345 and QQ-3456 then the aa-1234 is UNDER them, instead of on top. [/snip] http://www.php.net/strtoupper -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] keyword searching

[snip] I am selecting a field in a database called description for keyword searching. The field contains names of people, states, years, etc. When someone searches for say holmes north carolina the query searches for exactly that, fields which have holmes north carolina, and not fields that

[PHP-DB] RE: [PHP]{Semi-OT} keyword searching

[snip] I'm using Informix SQL. Do you know how to do full text searching on Informix? If so, please share the details :) [/snip] You will have to consult your Informix documentation in order to discern if full-text features are available. Usually the text column where the information is being

[PHP-DB] RE: [PHP] Missing mysql_real_escape_string() function in PHP 4.3.4

[snip] I'm trying to move a PHP application that was originally built on the windows PHP implementation to a newly installed Fedora FC1 Linux system. However the Fedora implementation of PHP 4.3.4 seems to be missing the mysql_real_escape_string() function. I suspect that there might be other

[PHP-DB] RE: [PHP] MySQL Identifying worst-performing codes

[snip] There is  a tool call idera (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature;  Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures, long-running queries, most

[PHP-DB] RE: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

[snip] I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first select box displays the available language by querying the database. On selecting one language, author

Re: [PHP-DB] auto creation of email IDs

Vinay Kannan wrote: Hey Guys, I've been at this for couple of days now, and have no clue where to start, and was almost thinking about scrapping the project, It would be great help if anyone can give me some advice, or guide me in the right direction. I have a portal, where users would come in

[PHP-DB] RE: [PHP] Problems w/ goto

[snip] Thank you with your excellent help in the past. Here is another puzzler I am trying to write a program that can have two(2) independent forms in one PHP file. When I run the code below [from PHP - A Beginner's Guide], to which I have added a second form, it freezes. Without the

[PHP-DB] installing MySQL with PHP4.0.3pl1

database. I'm totally lost on this and don't have a clue as what to do. Any help will be greatly appreciated. Regards, Jay -- 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

[PHP-DB] simple sql question

-03-27" but I'm not getting any results. select * from events where startDate='2001-03-01' and startDate'2001-01-04' Any help on what I could be doing wrong would be great! Thanks, Jay Paulson Developer, Web Technologies Viatel, Inc. http://www.viatel.com -- PHP Database Mailing List

[PHP-DB] easy db question

incrementing field will start back at 1. Thanks, Jay Paulson Developer, Web Technologies Viatel, Inc. http://www.viatel.com -- 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

[PHP-DB] Connect to MySQL from different computer

Hello- I was wondering how do I connect to a MySQL database, using php, when php and MySQL are on two separate computers? Thanks, Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] php4 + sqlite - quoting stuff

Hi all, I'm a kinda-sorta newbie to php -- I basically just futz around with it because it's pretty cool. However, I'm brand spanking new to databases. Never did anything with them. I taught myself a little SQL because it looked fun to learn, but I just thumbed through some books. I never

[PHP-DB] Undefined indicies

Slightly off topic, I apologise. Total newbie. In many php DB tutorials I've seen, it's recommended to set register_globals off, and error reporting to E_ALL. When I looked at my system, register_globals was enabled and error reporting was set to E_FATAL. I changed them to the suggested values

[PHP-DB] Update keeps failing with php/sqlite

Hi all, I made a toy database. Two tables are students (a collection of student info) and message (private messages I want individual students to read). The message table is indexed by a student's social security number. student last, first, ssn, address, city, state, zip, email message

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

On Mon 27 Dec 04, 5:22 PM, S Kumar [EMAIL PROTECTED] said: Dear group, I am a novice programmer started doing php to process a query form of my patients. I have a database and one table in it deals with my patient information. Depending on their condition I divided their age groups

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

On Mon 27 Dec 04, 9:22 PM, p p said: Select age_group from patient_data where age_group = young and old ; I am truly stuck here. Can any one please help me out to pass this situation. Thank you in advance. Kumar. PS- How can a single patient be young, middle, and

Re: [PHP-DB] How to process a query form with CHECKBOX Please help

On Mon 27 Dec 04, 8:48 PM, S Kumar [EMAIL PROTECTED] said: Hello Pete: However, in the case of checkboxes, I do not know how to make variables out of them depensing on what user selects. Say whatever user cheks in the checkbox, that variable has to be searched in TABLE-C and various

Re: [PHP-DB] is this a problem ?

On Tue 28 Dec 04, 11:44 AM, Miles Thompson [EMAIL PROTECTED] said: At 09:25 AM 12/28/2004, amol patil wrote: hallo, i have changed file signup1.php with login1.php, in action fied of form form name=form1 method=POST action=-- and saved . but when i run this file

Re: [PHP-DB] Site optimization

On Tue 28 Dec 04, 12:11 PM, Joseph Crawford [EMAIL PROTECTED] said: i was wondering this as well :D are there any tools out there to simulate high traffic on your web server say where you specify how many users hit the site at one time and the tool actually hits your server that many times?