Re: [PHP-DB] MySQL connection

2017-03-05 Thread Karl DeSaulniers
That makes complete sense. Thank you Joshua. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Mar 5, 2017, at 6:44 PM, Arneson, Joshua wrote: > > If you have multiple calls to the database that are grouped, definitely > perform them during the same

Re: [PHP-DB] MySQL connection

2017-03-05 Thread Arneson, Joshua
If you have multiple calls to the database that are grouped, definitely perform them during the same connection session. The bottom line is unless the overhead associated with opening and closing the connection is going to be an issue programmatically, keep connections brief and group your

Re: [PHP-DB] MySQL connection

2017-03-05 Thread Karl DeSaulniers
Ah, thanks for the reply Joshua. Duly noted. So when is it bad to make multiple open and close connections then? I am guessing that could have some impact with lots of users too. Yes? If the website in question does not have a lot of users (less than 1,000), is this still a bad call to keep an

Re: [PHP-DB] MySQL connection

2017-03-05 Thread Arneson, Joshua
Right off the bat, you need to consider concurrency issues. Depending on the size of your user base and level of activity this could become a major issue. In the end, why hold an open connection for 15 minutes just to process 20-30 transactions that take 20-30ms each? Just better (under most

Re: [PHP-DB] MySQL two tables and an uneven number of rows

2016-09-19 Thread Karl DeSaulniers
Thanks Bert, Sorry for late response, but I had to step away from this for a moment to work on other things. Will most likely be back though as things are not working still. Thank you for your responses. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Sep 13, 2016, at 2:15

Re: [PHP-DB] MySQL two tables and an uneven number of rows

2016-09-13 Thread B. Aerts
On 13/09/16 08:42, Karl DeSaulniers wrote: On Sep 12, 2016, at 2:53 PM, B. Aerts wrote: On 12/09/16 05:24, Karl DeSaulniers wrote: Hello All, Hoping you can help clear my head on this. I have two MySQL tables for custom fields data to be stored. custom_fields

Re: [PHP-DB] MySQL two tables and an uneven number of rows

2016-09-13 Thread Karl DeSaulniers
> On Sep 12, 2016, at 2:53 PM, B. Aerts wrote: > > On 12/09/16 05:24, Karl DeSaulniers wrote: >> Hello All, >> Hoping you can help clear my head on this. I have two MySQL tables for >> custom fields data to be stored. >> >> custom_fields

Re: [PHP-DB] mysql query

2013-08-22 Thread Michael Oki
To: Daniel Krook/White Plains/IBM@IBMUS Cc: PHP Database List php-db@lists.php.net Date: 08/21/2013 11:59 PM Subject: Re: [PHP-DB] mysql query On 08/21/2013 11:30 PM, Daniel Krook wrote: Ethan, It's hard to tell from the code formatting in your email what the exact problem might

Re: [PHP-DB] mysql query

2013-08-22 Thread Vinay Kannan
: From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: Daniel Krook/White Plains/IBM@IBMUS Cc: PHP Database List php-db@lists.php.net Date: 08/21/2013 11:59 PM Subject: Re: [PHP-DB] mysql query On 08/21/2013 11:30 PM, Daniel Krook wrote: Ethan, It's hard to tell from

Re: [PHP-DB] mysql query

2013-08-21 Thread Toby Hart Dyke
1) What is the error message? 2) This has an error: values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk) Missing '$' in front of 'odrpt'. Toby On 8/22/2013 12:48 AM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory;

Re: [PHP-DB] mysql query

2013-08-21 Thread Ethan Rosenberg
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote: 1) What is the error message? 2) This has an error: values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk) Missing '$' in front of 'odrpt'. Toby On 8/22/2013 12:48 AM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql

Re: [PHP-DB] mysql query

2013-08-21 Thread Daniel Krook
Ethan, It's hard to tell from the code formatting in your email what the exact problem might be, but a few reasons that this might fail in PHP rather than when sent to MySQL with hardcoded values: 1. var_dump/print_r $_POST to see what you're getting as input is what you expect (and

Re: [PHP-DB] mysql query

2013-08-21 Thread Daniel Krook
@IBMUS Cc: PHP Database List php-db@lists.php.net Date: 08/21/2013 11:59 PM Subject: Re: [PHP-DB] mysql query On 08/21/2013 11:30 PM, Daniel Krook wrote: Ethan, It's hard to tell from the code formatting in your email what the exact problem might be, but a few reasons that this might fail

Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

2013-06-28 Thread Tamara Temple
Alexander Pletnev pletnev.rusa...@gmail.com wrote: Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM

Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

2013-06-27 Thread Vinay Kannan
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%'); How about '%:$query%' instead of '%:query%' ? Does that solve the problem? Thanks, On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev

Re: [PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Artur Ejsmont
You probably miss the mysql extension or have different one than you are calling. Please call ?php php_info(); ? in script to see what extensions are loaded. if there is some other module supporting mysql just use different way to run sql. otherwise you need to look into php.ini and see if

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Onur Yerlikaya
function getOptGrps($ID=null){ if ($ID == All) { $ID = %; // % = MySQL multi character wildcard } $extraClause = ; if(!is_null($ID)) { $extraClause = WHERE OptGrpID LIKE '$ID' ; } $q = SELECT * FROM .OPT_GRPS_TABLE.$extraClause; $result =

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Karl DeSaulniers
On May 7, 2010, at 4:16 AM, Onur Yerlikaya wrote: function getOptGrps($ID=null){ if ($ID == All) { $ID = %; // % = MySQL multi character wildcard } $extraClause = ; if(!is_null($ID)) { $extraClause = WHERE OptGrpID LIKE '$ID' ; } $q = SELECT

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Onur Yerlikaya
so sorry function getOptGrps($ID=null){ $extraClause = ; if($ID != All) { $extraClause = WHERE OptGrpID LIKE '$ID' ; } $q = SELECT * FROM .OPT_GRPS_TABLE.$extraClause; $result = $this-query($q); /* Error occurred, return given name by default */

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Chaitanya Yanamadala
what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records (users) during a 7 day period ending

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Chris
Ron Piggott wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records (users) during a 7 day period ending yesterday. I always to keep it current ... Yesterday will keep changing. In other words I want to know the number of users who accessed

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Ron Piggott
It is in a 'date' column type -MM-DD what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Chaitanya Yanamadala
try this SELECT DATE_ADD('2008-01-02', INTERVAL -7 DAY); Chaitanya On Tue, Apr 13, 2010 at 12:01 PM, Ron Piggott ron.pigg...@actsministries.org wrote: It is in a 'date' column type -MM-DD what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at

RE: [PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates

2010-04-12 Thread David Murphy
Message- From: Chris [mailto:dmag...@gmail.com] Sent: Sunday, April 11, 2010 6:26 PM To: David Murphy Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates David Murphy wrote: As you can see PHP

Re: [PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates

2010-04-11 Thread Chris
David Murphy wrote: As you can see PHP claims it took 20 seconds for mysql-query() to return but mysql think is took around 1.0s This is from our application I enabled profile in mysql to determine why an update took 20seconds. As you can see MySQL reported no where near that amount

Re: [PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates

2010-04-11 Thread kranthi
just a pointer.. have you enabled php profiling to see if it actually mysql-query() that takes 20 secs ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread Chaitanya Yanamadala
have u checked max_execution_time Chaitanya On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin stephen.sunder...@verizon.net wrote: I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop through a while statement to send about 3000 email using phpmailer. It's worked

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread Chaitanya Yanamadala
: Chaitanya Yanamadala dr.virus.in...@gmail.com Date: Fri, 09 Apr 2010 19:26:22 To: Stephen Sunderlinstephen.sunder...@verizon.net Cc: php-db@lists.php.net Subject: Re: [PHP-DB] mysql/php time out issue have u checked max_execution_time Chaitanya On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread ad
@lists.php.net Subject: Re: [PHP-DB] mysql/php time out issue have u checked max_execution_time Chaitanya On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin stephen.sunder...@verizon.net mailto:stephen.sunder...@verizon.net wrote: I'm running php 5.1.6 with mysql 5.0.45

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread ad
dr.virus.in...@gmail.com mailto:dr.virus.in...@gmail.com Date: Fri, 09 Apr 2010 19:26:22 Cc: php-db@lists.php.net mailto:php-db@lists.php.net Subject: Re: [PHP-DB] mysql/php time out issue have u checked max_execution_time Chaitanya On Fri, Apr 9, 2010 at 7:17 PM, Stephen

Re: [PHP-DB] MySQL vs. Session array

2010-04-07 Thread Peter Lind
On 8 April 2010 00:13, 3dgtech syst...@3dgtech.com wrote: Quick question. I have an AJAX component that fires a like query for each key up event (since it's a like % query there is no indexing or caching possible). While everything works fine, I was contemplaining downloading the ~1500 rows

Re: [PHP-DB] Mysql query

2009-12-14 Thread Chris
ron.pigg...@actsministries.org wrote: The query from my previous post was only part of a larger query. This is the entire query: SELECT GREATEST( IF( CURDATE( ) = DATE_SUB( DATE( FROM_UNIXTIME( 1239508800 ) ) , INTERVAL LEAST( 14, ( SELECT COUNT( * ) FROM `verse_of_the_day_Bible_verses` WHERE

Re: [PHP-DB] Mysql query

2009-12-14 Thread ron . piggott
Chris I spent 3 hours debugging this query myself. I got as far as putting '' around 2009-12-25 to get the desired results. I just added the word DATE. It works, thanks. Chris I run a verse of the day e-mail list. This query determines the logic of the content (year round, Easter and

Re: [PHP-DB] mySQL query syntax error

2009-11-14 Thread Ron Piggott
I found the problem. The first subquery needed AS aliases. I am learning more of what mySQL is capable of and appreciate the help. Ron -Original Message- From: TG tg-...@gryffyndevelopment.com To: ron.pigg...@actsministries.org Subject: Re: [PHP-DB] mySQL query syntax error Date: Sat

Re: [PHP-DB] Mysql multiple queries Vs. Query in multi-dimensional array

2009-08-10 Thread Chris
Drew Stokes wrote: Hello all, I have an enterprise application that needs to be optimized/re-engineered. In the process of re-designing the framework, i stumbled across the idea of storing large mysql result sets in multi-dimensional arrays for easy/quick reference. Basically, my

Re: [PHP-DB] MySQL - LIMIT 1 on primary KEY - makes sense?

2009-06-03 Thread Bastien Koert
2009/6/3 Martin Zvarík mzva...@gmail.com: SELECT * FROM xxx WHERE primary_id=123 LIMIT 1 Is it useless (LIMIT 1) ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Bastien Cat, the other other white meat -- PHP Database

Re: [PHP-DB] MySQL - LIMIT 1 on primary KEY - makes sense?

2009-06-03 Thread Bastien Koert
2009/6/3 Martin Zvarík mzva...@gmail.com: SELECT * FROM xxx WHERE primary_id=123 LIMIT 1 Is it useless (LIMIT 1) ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php It doesn't do anything...you are already returning just the one row

Re: [PHP-DB] MySQL - LIMIT 1 on primary KEY - makes sense?

2009-06-03 Thread Martin Zvarík
Bastien Koert napsal(a): 2009/6/3 Martin Zvarík mzva...@gmail.com: SELECT * FROM xxx WHERE primary_id=123 LIMIT 1 Is it useless (LIMIT 1) ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php It doesn't do anything...you are already

Re: [PHP-DB] MySQL: did anyone start a transaction?

2009-05-11 Thread Bastien Koert
On Fri, May 8, 2009 at 6:23 PM, Bogdan Stancescu gu...@moongate.ro wrote: Hello all, I asked this question on php-general last month (http://marc.info/?t=12404923034r=1w=2), and received some answers -- but I was directed to this list, so here. My question is: can I tell

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ??

2009-03-12 Thread Chris
YVES SUCAET wrote: Hi List, I'm experiencing the problem as described at http://forums.mysql.com/read.php?37,39779,136287#msg-136287 I'm using the following script to test: ?php $p = 0; $n = 0; for ($i = 0; $i 120; $i++) { $conn = mysql_connect(www.myserver.org, user, secret);

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ?? - clarification

2009-03-12 Thread YVES SUCAET
Subject: Re: [PHP-DB] MySQL + PHP on WinXP x64 = ?? YVES SUCAET wrote: Hi List, I'm experiencing the problem as described at http://forums.mysql.com/read.php?37,39779,136287#msg-136287 I'm using the following script to test: ?php $p = 0; $n = 0; for ($i = 0; $i 120; $i

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ?? - clarification

2009-03-12 Thread Chris
YVES SUCAET wrote: Hi Chris, I don't need 120 concurrent connections. The problem arises from subsequently opening connections and the script is a way to simulate the problem: the first 100 connections e.g. open up fine; then the next 5 mess up; then the next 7 are good to go again etc... I'm

RE: [PHP-DB] MySQL query executes outside of PHP, but not in PHP

2009-01-26 Thread Dave.McGovern
snip error_log(Hey, the SQL is: $sql); Then look in your php error log (you do have error logging enabled, right?) [McGovern, Dave] Enabled, yes. Usefully enabled, no (correcting this helped a lot). If that SQL in the error log is fine, then your problem is

Re: [PHP-DB] MySQL query executes outside of PHP, but not in PHP

2009-01-23 Thread Peter Beckman
On Fri, 23 Jan 2009, dave.mcgov...@sungard.com wrote: Hi, I am running: PHP 5.2.8, Apache 2.2.11, MySQL 5.1.30 on Win32/XP. I have a number of queries on my page which are very similar in structure, and they all work except for the following one. $mysql['process'] =

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-21 Thread Chris
Aleksandar Vojnovic wrote: You could try with the operator. !=, Not equal operator Same issue as using '=': mysql select 2 null; +---+ | 2 null | +---+ | NULL | +---+ 1 row in set (0.00 sec) Comparing anything with null returns null. (I'm not asking for a

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-19 Thread Aleksandar Vojnovic
You could try with the operator. !=, Not equal operator Or you could try it this way - ISNULL(col_or_data_to_check). Example: mysql SELECT ISNULL(1+1); +-+ | ISNULL(1+1) | +-+ | 0 | +-+ 1 row in set (0.02 sec) Aleksander Chris wrote: Chris

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-18 Thread OKi98
Original Message Subject: Re: [PHP-DB] MySQL Conditional Trigger From: Chris dmag...@gmail.com To: OKi98 ok...@centrum.cz Date: 8.12.2008 23:09 anything compared to NULL is always false Actually it's null. mysql select false = null; +--+ | false = null

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-18 Thread Chris
unknown compared to anything is unknown. he was talking about plsql and condition evaluation (ends with true or false), your point is absolutely useless. The context is in the database - my example is in the database. How is that useless? -- Postgresql php tutorials

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-18 Thread Chris
Chris wrote: unknown compared to anything is unknown. he was talking about plsql and condition evaluation (ends with true or false), your point is absolutely useless. The context is in the database - my example is in the database. How is that useless? In case you missed it, this is the

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread OKi98
Original Message Subject: [PHP-DB] MySQL Conditional Trigger From: Dee Ayy [EMAIL PROTECTED] To: php-db@lists.php.net Date: 31.10.2008 17:09 I don't think my trigger likes a comparison with a variable which is NULL. The docs seem to have a few interesting variations on

RE: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread Fortuno, Adam
, 2008 4:33 PM To: Dee Ayy Cc: php-db@lists.php.net Subject: Re: [PHP-DB] MySQL Conditional Trigger Original Message Subject: [PHP-DB] MySQL Conditional Trigger From: Dee Ayy [EMAIL PROTECTED] To: php-db@lists.php.net Date: 31.10.2008 17:09 I don't think my trigger likes

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread Chris
anything compared to NULL is always false Actually it's null. mysql select false = null; +--+ | false = null | +--+ | NULL | +--+ 1 row in set (0.01 sec) mysql select 1 = null; +--+ | 1 = null | +--+ | NULL | +--+ 1 row

RE: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread Fortuno, Adam
. Be Well, A- -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2008 5:10 PM To: OKi98 Cc: php-db@lists.php.net Subject: Re: [PHP-DB] MySQL Conditional Trigger anything compared to NULL is always false Actually it's null. mysql select false = null

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-08 Thread Chris
Fortuno, Adam wrote: All, Chris makes a good point i.e., unknown compared to anything is unknown. His comment made me want to clarify my earlier note. In my earlier example, I wasn't suggesting that-that logic be coded in the database. I was assuming it would be in the page: ?php

Re: [PHP-DB] MySQL Query Timeout program in PHP

2008-10-31 Thread Thodoris
Man- when the query is fired through the web interface- it rans on mysql server max_execution_time - wont' help evn I stop apache itself... Yes it will. Apache will be instructed to stop execution of any script by the mod_php module (assuming you are using mod_php). But mysql

Re: [PHP-DB] MySQL Query Timeout program in PHP

2008-10-15 Thread Chris
Piyush Kumar wrote: I'm using http://myclient.polarlava.com/ as web query interface for mysql server Now I want to add Query Timeout functionality to it For that I need to get the PID for last ran mysql query and then using kill PID - I can kill the process on MySQL server Please explain how

Re: [PHP-DB] MySQL Query Timeout program in PHP

2008-10-15 Thread Jack van Zanen
Just put the time out in your PHP.INI file max_execution_time = 30 ; Maximum execution time of each script, in seconds 2008/10/16 Piyush Kumar [EMAIL PROTECTED] I'm using http://myclient.polarlava.com/ as web query interface for mysql server Now I want to add Query Timeout functionality

Re: [PHP-DB] MySQL Query Timeout program in PHP

2008-10-15 Thread Piyush Kumar
Man- when the query is fired through the web interface- it rans on mysql server max_execution_time - wont' help evn I stop apache itself... The query runs on mysql server - so I have to kill the PID on server itself... Thanks Piyush On Thu, Oct 16, 2008 at 7:57 AM, Jack van Zanen [EMAIL

Re: [PHP-DB] MySQL Query Timeout program in PHP

2008-10-15 Thread Chris
Piyush Kumar wrote: Hi Chris, As I mentioned in my query I want to Kill only the query ran by web client not all queries running on the server. The perl script kill all queries - which are been running from for last 120(or any threshold set) Issues: How do I get the PID of my last select

Re: [PHP-DB] MySQL Query Timeout program in PHP

2008-10-15 Thread Chris
Piyush Kumar wrote: show full processlist ; gives me whole query -- but I want some php function -- like mysql_info() -- to return the PID of last run query Please do not email me directly. Always send to the mailing list. If it's not listed under php.net/mysql somewhere, then it's not

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-10-11 Thread Tim Hawkins
Until TUDBC is available under an accredited FOSS license, nobody in their right mind is going to use it in any project that may need to be ipr encumbrement free at a future date. Posting solutions that pertain to a proprietary technology on a list predominately dedicated to technologies

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-10-11 Thread Post TUDBC
TUDBC has recently moved to open-source GPL, similar to how MySQL works. (You probably got the impression that it had proprietary license, maybe because some the obsolete webpages still referred to the old license, so I have corrected those obsolete web pages.) I am not familiar with FOSS, but my

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-10-10 Thread Post-No-Reply TUDBC
By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Better yet, it works on any flavors of PHP (original, Phalanger, or Quercus). Even better, you would use the same style of coding for any DBMSes or programming languages. Have fun! For an example in MySQL (just change

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-10-10 Thread Fergus Gibson
2008/10/10 Post-No-Reply TUDBC [EMAIL PROTECTED]: By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Your post was an excellent answer to the question, How do I call stored procedures easily with TUDBC? Unfortunately, that is not what the original poster asked. In

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-10-10 Thread Post-No-Reply TUDBC
I kindly disagree. The original post asked How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? by STF. To quote STF again in a later post Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-09-19 Thread Thodoris
: How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? STF === http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is: 9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

2008-09-19 Thread Stanisław T. Findeisen
Thodoris wrote: I think that the manual is quite clear on this: http://dev.mysql.com/doc/refman/5.1/en/call.html You use a way to query the database like PDO or mysqli and you wite sql. Yes, I've already found that multi-step way before... I was just wondering if anything got better since

Re: [PHP-DB] mysql auto_increment

2008-09-07 Thread Evert Lammerts
I guess this code was not copy pasted from your actual source? It would generate mysql errors. Anyway, I think I've an idea of what you want, so here's my two cents : function edit_cat_radio($item_cat_id) { connect(); $query = mysql_query(SELECT * FROM cat); while ($row =

Re: [PHP-DB] mysql auto_increment

2008-09-07 Thread Evert Lammerts
Pastebin is so much nicer when posting code. Find the code i've sent here: http://pastebin.com/mc5d611a -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql auto_increment

2008-09-07 Thread Evert Lammerts
Little change - the label was not used in the right way: http://pastebin.com/m2d98e677 On Sun, Sep 7, 2008 at 11:46 PM, Evert Lammerts [EMAIL PROTECTED] wrote: I guess this code was not copy pasted from your actual source? It would generate mysql errors. Anyway, I think I've an idea of what

Re: [PHP-DB] MySQL Reporting Tool

2008-09-04 Thread Chris
Micah Gersten wrote: Anyone use one, hopefully written in PHP? To report on what? Or you mean something like crystal reports where you can make up your own stuff? crystal reports supports odbc so will be able to hook into mysql. -- Postgresql php tutorials http://www.designmagick.com/

Re: [PHP-DB] MySQL Reporting Tool

2008-09-04 Thread Micah Gersten
Anything Open Source? One of my friends uses SQL Server Reporting Services and was wondering if there is a similar product for MySQL. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Chris wrote: Micah Gersten wrote: Anyone use one, hopefully written in

Re: [PHP-DB] MySQL Reporting Tool

2008-09-04 Thread Chris
Micah Gersten wrote: Anything Open Source? One of my friends uses SQL Server Reporting Services and was wondering if there is a similar product for MySQL. Don't know any off hand but check out sourceforge. Here's a couple: http://sourceforge.net/projects/fourfive/

Re: [PHP-DB] mySQL SELECT query

2008-08-29 Thread Evert Lammerts
In the SQL standard this would be AND NOT ministry_directory.listing_approved=0 AND NOT ministry_directory.listing_approved=4 MySQL supports (and there are probably more RDBs that do): AND ministry_directory.listing_approved!=0 AND ministry_directory.listing_approved!=4 On Fri, Aug 29, 2008 at

Re: [PHP-DB] mySQL SELECT query

2008-08-29 Thread Matt Anderton
or NOT IN (0,4) -- matt On Fri, Aug 29, 2008 at 12:19 PM, Evert Lammerts [EMAIL PROTECTED]wrote: In the SQL standard this would be AND NOT ministry_directory.listing_approved=0 AND NOT ministry_directory.listing_approved=4 MySQL supports (and there are probably more RDBs that do): AND

Re: [PHP-DB] Mysql logs

2008-07-23 Thread Micah Gersten
You have to edit your my.cnf file. Here's a link to the docs: http://dev.mysql.com/doc/refman/5.0/en/log-files.html Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Manoj Singh wrote: Hi All, Please help me to set the logging on in mysql. I am using the

Re: [PHP-DB] Mysql logs

2008-07-23 Thread Manoj Singh
Hi Micah, Thanks for help. Best Regards, Manoj Kumar Singh On Thu, Jul 24, 2008 at 11:02 AM, Micah Gersten [EMAIL PROTECTED] wrote: You have to edit your my.cnf file. Here's a link to the docs: http://dev.mysql.com/doc/refman/5.0/en/log-files.html Thank you, Micah Gersten onShore

Re: [PHP-DB] MySQL circular buffer

2008-06-21 Thread OKi98
(i.e. stack_id 500 stack_id 601 vs where stack_id = 500 limit 100) stack_id between 501 and 600 (stack_id 500 stack_id 601) is much better What I would like to know is if anybody has experience implementing this sort of data structure in MySQL (linked list?) or any advice. tables:

Re: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Daniel Brown
On Tue, Feb 26, 2008 at 10:49 AM, Lasitha Alawatta [EMAIL PROTECTED] wrote: Hello Everybody, We have 6 multi-master MySql instances within a LAN , that are replicating is a sequential manner. Server Environment : Six identical Linux Enterprise version 4 running, servers with having MySQL

RE: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Lasitha Alawatta
BETTER answers if you asked on a MySQL list. De: Lasitha Alawatta [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 13:47 Para: Thiago Pojda Assunto: RE: [PHP-DB] MySQL replication delaying issue Hay, If U don't know about that then u

RE: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Lasitha Alawatta
. I said: you would get BETTER answers if you asked on a MySQL list. De: Lasitha Alawatta [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 13:47 Para: Thiago Pojda Assunto: RE: [PHP-DB] MySQL replication delaying issue Hay, If U

RE: [PHP-DB] mysql data truncation does not cause an error to be thrown

2007-11-08 Thread Vandegrift, Ken
Web Developer/Administrator (Direct) 503-605-4132 [EMAIL PROTECTED] -Original Message- From: Andrew Blake [mailto:[EMAIL PROTECTED] Sent: Thursday, November 08, 2007 7:51 AM To: Instruct ICC Cc: php-db@lists.php.net Subject: Re: [PHP-DB] mysql data truncation does not cause an error

RE: [PHP-DB] mysql data truncation does not cause an error to be thrown

2007-11-08 Thread Instruct ICC
sidestepped. Date: Thu, 8 Nov 2007 15:50:38 + From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] mysql data truncation does not cause an error to be thrown Hiya I could check the length of the field against the entry data and javascript myself

RE: [PHP-DB] mysql data truncation does not cause an error to be thrown

2007-11-08 Thread Instruct ICC
Using mysql_query if i try to force more data than a field can have the data is truncated yet no error is throw at all. Is there a way round this ? Cheers Andy This isn't exactly what you want to hear, but how about validating your input before submitting a query?

Re: [PHP-DB] mysql data truncation does not cause an error to be thrown

2007-11-08 Thread Andrew Blake
To: Instruct ICC Cc: php-db@lists.php.net Subject: Re: [PHP-DB] mysql data truncation does not cause an error to be thrown Hiya I could check the length of the field against the entry data and javascript myself out of trouble but i was more worried that there is no error or message when mysql

Re: [PHP-DB] mysql data truncation does not cause an error to be thrown

2007-11-08 Thread Andrew Blake
Hiya I could check the length of the field against the entry data and javascript myself out of trouble but i was more worried that there is no error or message when mysql clearly returns one saying i've truncated this yet php ignores it completely. It should fail or know about the truncation

RE: [PHP-DB] mysql data truncation does not cause an error to be thrown

2007-11-08 Thread Instruct ICC
Maybe tell the list the exact solution? File/variable/setting? Cheers. I figured it out it was the mysql install not php :-) cheers for your help though :-) Vandegrift, Ken wrote: You may want to check the my.ini setting for the table type you are using and see if there is a

RE: [PHP-DB] mysql error...

2007-08-28 Thread Bastien Koert
Condition is a reserved word in mysql...you will need to change the field name bastien Date: Tue, 28 Aug 2007 18:11:20 -0700 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] mysql error... this is bugging me to no end (no pun intended)... I am getting the error: invalid

Re: [PHP-DB] mysql error...

2007-08-28 Thread Chris
John Pillion wrote: this is bugging me to no end (no pun intended)... I am getting the error: invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, ConstructType, BldgDimensions,

Re: [PHP-DB] mysql different server different EXPLAIN result

2007-07-24 Thread Niel
Hi I'm running 3 servers with mysql database - Local : 5.0.18-log, MySQL Community Edition (GPL) - Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard (GPL) - Backup Server : 4.1.20, Source Distribution I copied a database from the Main Server to Local and Backup Server

Re: [PHP-DB] mysql different server different EXPLAIN result

2007-07-24 Thread Chris
Chenri wrote: Dear All I'm running 3 servers with mysql database - Local : 5.0.18-log, MySQL Community Edition (GPL) - Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard (GPL) - Backup Server : 4.1.20, Source Distribution Not sure why you're surprised why they are

RE: [PHP-DB] MySQL user anHTACCESSusername not found?

2007-07-17 Thread Instruct ICC
From: Instruct ICC [EMAIL PROTECTED] Why is this second log entry present? I don't see any place where I ask MySQL to authenticate an HTACCESS username. It came to me. The very fact that we are using mod_auth_mysql in the Apache web server means that Apache is trying to authenticate

Re: [PHP-DB] MySQL Error 1366

2007-05-28 Thread Chris
elk dolk wrote: Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql LOAD DATA - INFILE 'D:/SITE/SOMETABLE.SQL' - INTO TABLE SOMETABLE - FIELDS TERMINATED BY ',' - OPTIONALLY ENCLOSED BY '' - LINES TERMINATED BY

Re: [PHP-DB] MySQL Error 1366

2007-05-28 Thread Chetanji
Chetanji says, This may be a typo of yours. Look at the header... CREATE TABLE `sometableo` The 'o' is added by mistake? Blessings, Chetanji elk dolk wrote: Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql LOAD DATA

Re: [PHP-DB] MySQL BETWEEN Problems

2007-05-18 Thread Brad Bonkoski
I think you need between 'A' and 'F%' Aa is between A and F but 'Fa' is not between 'A' and 'F' (but 'Ez' would be between 'A' and 'F') -B Tony Grimes wrote: I'm using BETWEEN to return a list all people who's last names fall between A and F: WHERE last_name BETWEEN 'A' AND 'F' ... but

Re: [PHP-DB] MySQL BETWEEN Problems

2007-05-18 Thread Brad Bonkoski
Try using the substr, since you are only comparing the first letters... (sorry I did not reply all on the other email, Dan) i.e. select name from users where substr(name, 1, 1) = 'A' and substr(name, 1, 1) = 'B'; -B Dan Shirah wrote: So just change it to WHERE last_name BETWEEN 'A' AND 'G' .

Re: [PHP-DB] MySQL BETWEEN Problems

2007-05-18 Thread Tony Grimes
Yeah, but what do I do for Q-Z? I guess I¹ll have to write a condition to use last_name = ŒQ¹ if it finds a Z. I¹ll have to write conditions to look for other exceptions too. Aaarrgh! *looks up at the Gods* Damn you BETWEEN! Why must you torture me so!?! Have a good weekend. On 5/18/07 2:51

Re: [PHP-DB] MySQL BETWEEN Problems

2007-05-18 Thread Tony Grimes
Nice! That did the trick. Thanks Brad. I live to fight another day. Tony On 5/18/07 3:00 PM, Brad Bonkoski [EMAIL PROTECTED] wrote: Try using the substr, since you are only comparing the first letters... (sorry I did not reply all on the other email, Dan) i.e. select name from users

Re: [PHP-DB] MySQL BETWEEN Problems

2007-05-18 Thread itoctopus
I remember I had the same problem for the between dates. for example, Select * FROM the_table WHERE the_date BETWEEN '2007-01-01' AND '2007-01-31', the problem that it wasn't including the 2007-01-31, I discovered later on that it should be something like: SELECT * FROM the_table WHERE the_date

RE: [PHP-DB] MySQL Query on the Fly

2007-05-14 Thread Dwight Altman
That's one of the uses of Ajax. http://www.xajaxproject.org/ http://wiki.xajaxproject.org/Tutorials:Learn_xajax_in_10_Minutes You don't have to use an iframe. Regards, Dwight -Original Message- From: Todd A. Dorschner [mailto:[EMAIL PROTECTED] Sent: Friday, May 11, 2007 8:31 AM

  1   2   3   4   5   6   7   8   9   10   >