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
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
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
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
Hello everyone,
Long time. Hope all are well.
Quick question. How should MySQL connections be treated?
Is it ok to leave them open or is it better to close them after transactions?
I have a website that uses sessions and was wondering if there was any
situations where I should be closing the
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
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
> 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
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 custom_fields_meta
custom_fields is the info for the actual field displayed in the html and
custom_fields_meta is the data stored from
Hi guys, i'm with a doubt about mysql and connect with a mariadb
server using a dialog auth plugin (server side)
i didn't found functions to execute dialog with server
a full example of what i want but using heidisql can be found here:
http://www.heidisql.com/forum.php?t=9752
any help is
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
:
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
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| UPC | varchar(14) | YES | |
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;
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
/21/2013
07:48:12 PM:
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: PHP Database List php-db@lists.php.net
Date: 08/21/2013 07:48 PM
Subject: [PHP-DB] mysql query
Dear List -
I can't figure this out
mysql describe Inventory
@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
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
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 `specialists` `t` HAVING full_name like '%john%');
$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
Hi!
I'm currently developing an application which makes heave use of stored
procedures, stored functions and MySQL's SIGNAL/RESIGNAL feature.
Everything works great if I call only one stored procedure.
But if I call a stored procedure which calls another stored procedure or
function,
Is there a way that
SELECT COUNT(auto_increment) as total_subscribers , `email` FROM `table`
may exist within the same query and provide more than 1 row of search results?
When I run a query like this the COUNT portion of the result is allowing only 1
to be selected. My desire is to have
I was previously on PHP 5.1.6 and was using the following code:
$dbr = mysql_unbuffered_query($query, $this-con);
while($row = mysql_fetch_array($dbr, $assoc ? MYSQL_ASSOC : MYSQL_NUM))
$this-result[] = $row;
$this-rows = mysql_num_rows($dbr);
It worked properly. The
Hey there,
I've just migrated to Mysql 5.5 from source and it works like a charm. Still
every now and then (in intervals of approximatly an hour) I get the following
error:
Error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2013]
Lost connection to MySQL server at
Hello,
i want to create a database with php.
A look in the php manual says that you need a special 4.x MySQL
version for using
mysql_create_db().
I am getting error message: Call to undefined function mysql_create_db().
When is this function defined and in what version of MySQL?
yours
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
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 =
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
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 */
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
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
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
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
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
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
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
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 well in the past but after an upgrade it seems
to be timing out now after 200-300 emails over 1 minute or two. I've
added
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
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 of duration took
place.
: 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
@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
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
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 into a session var as array, offloading the
(seperate)
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
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
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
Does anyone see anything wrong with this query? Do I have one of the , =
or mixed up? The purpose is to figure out if it is within 14 days of
Christmas AND if there is content for Christmas available. 2 is symbolic
in the database being Christmas. Ron
IF( CURDATE( ) = DATE_SUB(
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 seasonal_use =1 ) )
DAY )
AND CURDATE(
I am getting the following error message:
#1054 - Unknown column 'customers.email' in 'order clause'
from the query below --- I don't understand why. Would someone help me
please? Ron
SELECT 'first_name', 'last_name', 'email'
FROM (
(
SELECT `firstname` , `lastname` , `buyer_email`
FROM
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
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 application polls the
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
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
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
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
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
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 programatically whether the next query I'm
going to execute is already part of a transaction,
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);
if ($conn) {
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);
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
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
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
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'] = $client2-real_escape_string($clean['process']);
$sql = SELECT f.name,
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'] =
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
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
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
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
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
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
, 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
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
.
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
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
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
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 playing
with NULL and I was hoping someone would just throw me a fish so I
don't have to try every permutation (possibly using CASE, IFNULL,
etc.).
If my ShipDate
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 to do that in PHP
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
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
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
-- Forwarded message --
From: Piyush Kumar [EMAIL PROTECTED]
Date: Thu, Oct 16, 2008 at 9:09 AM
Subject: Re: [PHP-DB] MySQL Query Timeout program in PHP
To: Chris [EMAIL PROTECTED]
Hi Chris,
As I mentioned in my query I want to Kill only the query ran by web
client not all
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
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
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
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
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
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
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
:
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
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
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
I am writing a catologe application and i have a problem when it comes
to the edit product part. I have a table with the catogories and a table
with manufacturers.
Each table has a id column and a name column. The id column is set up in
the MySQL to auto_increment, which works fine normally,
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 =
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
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
Anyone use one, hopefully written in PHP?
--
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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/
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
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/
Is there a way to make this part of a SELECT query more concise?
AND ministry_directory.listing_approved NOT LIKE '0' AND
ministry_directory.listing_approved NOT LIKE '4'
I know of the
IN ( 10, 12 )
command. Is there something similar available for NOT LIKE?
Ron
--
PHP Database Mailing
1 - 100 of 1362 matches
Mail list logo