On 6/27/09 7:09 PM, "Daniel Kolbo" wrote:
> Tom Worster wrote:
>> On 6/27/09 3:15 PM, "Daniel Kolbo" wrote:
>>
>>> When a MySQL table is locked a php call of mysql_query() that requires
>>> that table will hang as the request blocks at the MySQL server until the
>>> table is unlocked. Is there
Daniel Kolbo wrote:
Hello,
When a MySQL table is locked a php call of mysql_query() that requires
that table will hang as the request blocks at the MySQL server until the
table is unlocked. Is there a way to stop a mysql_query from hanging
(by setting a time limit)?
Daniel
I can understand yo
On Jun 27, 2009, at 7:17 PM, Daniel Kolbo wrote:
Phpster wrote:
Bastien
Sent from my iPod
On Jun 27, 2009, at 4:13 PM, Daniel Kolbo wrote:
Ashley Sheridan wrote:
On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
Ashley Sheridan wrote:
On Sat, 2009-06-27 at 15:15 -0400, Daniel
Phpster wrote:
>
>
> Bastien
>
> Sent from my iPod
>
> On Jun 27, 2009, at 4:13 PM, Daniel Kolbo wrote:
>
>> Ashley Sheridan wrote:
>>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
Ashley Sheridan wrote:
> On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
>> Hello,
Bastien Koert wrote:
> Why issue/do a lock at all? Shouldn't need a large lock at read
>
> bastien
>
> On Saturday, June 27, 2009, Daniel Kolbo wrote:
>> Ashley Sheridan wrote:
>>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
Ashley Sheridan wrote:
> On Sat, 2009-06-27 at 15:1
Tom Worster wrote:
> On 6/27/09 3:15 PM, "Daniel Kolbo" wrote:
>
>> When a MySQL table is locked a php call of mysql_query() that requires
>> that table will hang as the request blocks at the MySQL server until the
>> table is unlocked. Is there a way to stop a mysql_query from hanging
>> (by se
Bastien
Sent from my iPod
On Jun 27, 2009, at 4:13 PM, Daniel Kolbo wrote:
Ashley Sheridan wrote:
On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
Ashley Sheridan wrote:
On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
Hello,
When a MySQL table is locked a php call of mysql
On Saturday, June 27, 2009, Bastien Koert wrote:
> Why issue/do a lock at all? Shouldn't need a large lock at read
>
> bastien
>
> On Saturday, June 27, 2009, Daniel Kolbo
wrote
>> Ashley Sheridan wrote:
>>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
Ashley Sheridan wrote:
>>
Why issue/do a lock at all? Shouldn't need a large lock at read
bastien
On Saturday, June 27, 2009, Daniel Kolbo wrote:
> Ashley Sheridan wrote:
>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
>>> Ashley Sheridan wrote:
On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
>
On 6/27/09 3:15 PM, "Daniel Kolbo" wrote:
> When a MySQL table is locked a php call of mysql_query() that requires
> that table will hang as the request blocks at the MySQL server until the
> table is unlocked. Is there a way to stop a mysql_query from hanging
> (by setting a time limit)?
would
Ashley Sheridan wrote:
> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
>> Ashley Sheridan wrote:
>>> On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
Hello,
When a MySQL table is locked a php call of mysql_query() that requires
that table will hang as the request
On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:
> Ashley Sheridan wrote:
> > On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
> >> Hello,
> >>
> >> When a MySQL table is locked a php call of mysql_query() that requires
> >> that table will hang as the request blocks at the MySQL server
Ashley Sheridan wrote:
> On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
>> Hello,
>>
>> When a MySQL table is locked a php call of mysql_query() that requires
>> that table will hang as the request blocks at the MySQL server until the
>> table is unlocked. Is there a way to stop a mysql_qu
Daniel Kolbo wrote:
> Hello,
>
> When a MySQL table is locked a php call of mysql_query() that requires
> that table will hang as the request blocks at the MySQL server until the
> table is unlocked. Is there a way to stop a mysql_query from hanging
> (by setting a time limit)?
>
> The php.ini
On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote:
> Hello,
>
> When a MySQL table is locked a php call of mysql_query() that requires
> that table will hang as the request blocks at the MySQL server until the
> table is unlocked. Is there a way to stop a mysql_query from hanging
> (by settin
Hello,
When a MySQL table is locked a php call of mysql_query() that requires
that table will hang as the request blocks at the MySQL server until the
table is unlocked. Is there a way to stop a mysql_query from hanging
(by setting a time limit)?
The php.ini directive max_execution_time does not
You can also stack the queries to run multiple rows in one insert
Insert into table values (row1col1, row1col2,'row1col3'),
(row2col1,row2col2,'row2col3'),...(rowNcol1,rowNcol2,'rowNcol3')
Bastien
Sent from my iPod
On May 31, 2009, at 8:18, דניאל דנון
wrote:
I've a file of about 500,000
- Original Message -
From: "flint"
To: "דניאל דנון"
Sent: Sunday, May 31, 2009 9:21 AM
Subject: Re: [PHP] mysql_query takes long time...
have you actually tried running the script against your data?
i'm running MySQL/PHP on an old P3/933Mhz box with onl
I've a file of about 500,000 lines, each line contains a string in variety
of lengths, but no less then 3 characters and usually no more then 120.
average of about 80, and maximum of about 250.
I made a PHP script to fetch the data (using fgets), process it and insert
it to a MySQL database.
Hello,
When i create a mysql database with the next command:
mysql_query("CREATE DATABASE my_db",$con)
In the server is created the database, but usually the name is created with
a prefix.
In this case: someuser_my_db
How can i detect with PHP the complete name of the new database created?
Th
On Tue, 2009-01-20 at 17:51 +0100, Jan G.B. wrote:
> 2009/1/20 Waynn Lue :
> > Hey guys,
> >
> > I've been noticing that large queries cause a connection lost to mysql
> > server problem, so I'm trying to figure out what settings I need to tweak in
> > my my.cnf file to get it to work.
>
> Have yo
2009/1/20 Waynn Lue :
> Hey guys,
>
> I've been noticing that large queries cause a connection lost to mysql
> server problem, so I'm trying to figure out what settings I need to tweak in
> my my.cnf file to get it to work.
Have you had a look on your (mysql) Logfiles and/or are you echo'ing
mysql
> ...
Hi,
You might get more help on the MySQL list.
--
Richard Heyes
HTML5 Graphing for Firefox, Chrome, Opera and Safari:
http://www.rgraph.org (Updated January 17th)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hey guys,
I've been noticing that large queries cause a connection lost to mysql
server problem, so I'm trying to figure out what settings I need to tweak in
my my.cnf file to get it to work. I know people change the
max-allowed-packet variable, but I'm trying to figure out what the correct
secti
[snip]
RE: mysql_query() vs query_database()
What is the differences between mysql_query and query_database?
Are both compatible with PHP 5 and MySQL 5?
Is one faster than the other?
[/snip]
query_database appears to be someone's function for generic database
queries and is not a part of the PHP
Hi,
RE: mysql_query() vs query_database()
What is the differences between mysql_query and query_database?
Are both compatible with PHP 5 and MySQL 5?
Is one faster than the other?
Thank you for your help.
Keith
Jeff Ostapchuk wrote:
ok, this same query, works EVERYWHERE ELSE, why won't it work now? it
returns to me:
Warning: Supplied argument is not a valid MySQL result resource
$query_result = mysql_query("SELECT * FROM AotH_Users");
while ($row = mysql_fetch_array($query_result, MYSQL_NUM)){
Why don't
[snip]
ok, this same query, works EVERYWHERE ELSE, why won't it work now? it
returns to me:
Warning: Supplied argument is not a valid MySQL result resource
$query_result = mysql_query("SELECT * FROM AotH_Users");
while ($row = mysql_fetch_array($query_result, MYSQL_NUM)){
[/snip]
When are you g
ok, this same query, works EVERYWHERE ELSE, why won't it work now? it
returns to me:
Warning: Supplied argument is not a valid MySQL result resource
$query_result = mysql_query("SELECT * FROM AotH_Users");
while ($row = mysql_fetch_array($query_result, MYSQL_NUM)){
--
PHP General Mailing List
> $sql = "INSERT INTO x VALUES ({$_SESSION['add']['name']} ";
>
> oh, and unless add & name are actually constants you should always wrap
> them in single quotes. (php will covert the non-exstent constant into a
> string a issue an E_NOTICE + its overhead)
well that got me on the right track..
user curly braces around your arrays in the string e.g:
$sql = "INSERT INTO x VALUES ({$_SESSION['add']['name']} ";
oh, and unless add & name are actually constants you should always wrap
them in single quotes. (php will covert the non-exstent constant into a
string a issue an E_NOTICE + its
Tuesday, April 6, 2004, 1:21:52 AM, you wrote:
> hi...
> i cant cut and paste my exact mysql query because it takes the ''
> stuff out doubles the $'s and the ,'s in the whole thing (dont know
> why but anyways...)...
> i have a query that goes something like this:
> mysql_query("insert into $Gue
hi...
i cant cut and paste my exact mysql query because it takes the '' stuff out doubles
the $'s and the ,'s in the whole thing (dont know why but anyways...)...
i have a query that goes something like this:
mysql_query("insert into $GuestbookTable values(NULL, '$_SESSION[add][date]',
'$_SESSIO
i am doing a straight mysql_query without an autocommit=0 should i be doing
an autocommit=0 if i am doing a read ?
> Hi there i have a random issue where mysql_query is not returning true
> sometimes on an innodb table which will trigger a custom error, this
> happens randomly if i go back to that
Hi there i have a random issue where mysql_query is not returning true
sometimes on an innodb table which will trigger a custom error, this
happens randomly if i go back to that page its fine ??
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> one last question for the day...
> if in one cell i have two names. ex 'mary eleanor'
> and i want to search by typing 'ele' with name LIKE '$name%' will not
give
> me mary eleanor as a result...
> any ideas?
*sighs*
LIKE '%$name%'
As I said... Read the MySQL Manual.
--
PHP General M
Thnx! :)
one last question for the day...
if in one cell i have two names. ex 'mary eleanor'
and i want to search by typing 'ele' with name LIKE '$name%' will not give
me mary eleanor as a result...
any ideas?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http:
- Original Message -
From: "Kevin Fradkin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 06, 2003 6:40 PM
Subject: Re: [PHP] mysql_query
> the problem is if i put 821000 i will have as result all number > 821000
> including 83
>
the problem is if i put 821000 i will have as result all number > 821000
including 83
and i only need numbers begining with the numbers i entered..
i will try now the other thing!.. thnx!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.ph
On Sunday, July 6, 2003, 7:26:06 PM, Kevin wrote:
KF> and now.. if in one cell i have for example... "John Matheus"
KF> when i do the query i have to put exactly john matheus to find it...
KF> is there any way to just write jo and search in every cell that contains
KF> those words?
try this SELE
and now.. if in one cell i have for example... "John Matheus"
when i do the query i have to put exactly john matheus to find it...
is there any way to just write jo and search in every cell that contains
those words?
example... i have 1 column with 5 rows each 6 numbers inside :
821554
821674
81
Hmm. Should have been like this..
-Original Message-
From: Sævar Öfjörð [mailto:[EMAIL PROTECTED]
Sent: 6. júlí 2003 14:04
To: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql_query
SELECT * FROM my_table WHERE var1='$var1' AND var2='$var2'
-
SELECT * FROM my_table WHERE var1='$var1' AND var2='$var2'
--^
you use AND
-Original Message-
From: Kevin Fradkin [mailto:[EMAIL PROTECTED]
Sent: 6. júlí 2003 13:43
To: [EMAIL PROTECTED]
Subject: [PHP] mysql_query
hi... 1 q
hi... 1 question...
how can i show in a table the query i'm trying to make
this is what i want :
select * from my_table where var1='$val1' /* here comes the trouble cause i
want to use 2 instead of only one... */ var2='$val2'
how you have to use it for more than one? where var1='$val1' ???
var2
> Just wondering if there is a maximum size to the sql that can be passed as
a
> mysql_query, either from mysql itself or from the php side of things?
>
> I ask only cause I have a limiting clause on my select and I have no idea
how
> big it will grow and I would prefer to write it in such a way th
Hi there,
Just wondering if there is a maximum size to the sql that can be passed as a
mysql_query, either from mysql itself or from the php side of things?
I ask only cause I have a limiting clause on my select and I have no idea how
big it will grow and I would prefer to write it in such a wa
Hello everybody,
Having an issue where I am getting unexpected results with a simple query
and at a lost to explain why.
At the end is my code. The problem I believe though I have narrowed down to
the following statement.
1. When I run SELECT accounts.id, accounts.action, people.last,
people.
Lo all,
I get a timeout on line 523 of my code (posted and marked below). However,
I fail to see where the timeout is occurring, and even debugging
(mysql_error()) doesn't report anything wrong!
I'm baffled as to what exactly is causing this timeout The code is
currently on Apache (Win32)
[snip]
This is a query that I am sending to mysql. The problem is that sometimes in
the variable "$message" characters like ")" will get posted and when they do
it makes mysql die. I can only assume that mysql thinks that the ")" in the
$message variable is meant to close the sql query, but I am h
This is a query that I am sending to mysql. The problem is that sometimes in
the variable "$message" characters like ")" will get posted and when they do
it makes mysql die. I can only assume that mysql thinks that the ")" in the
$message variable is meant to close the sql query, but I am having t
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 5:30 AM
Subject: [PHP] mysql_query: how to uniquely identify the query???
> Hi,
> I'm a bit a newbie at the mysql-php tandem,
> but I wanted to ask a pretty basic question
>
> Supose you do
> x=mysql_query(/someque
Hi,
I'm a bit a newbie at the mysql-php tandem,
but I wanted to ask a pretty basic question
Supose you do
x=mysql_query(/somequery/)
// fetch a row
and then later you do
y=mysql_query(/somequery/)
If you want to fetch the following row for the query in x,
you should probably make the distincti
al Message -
From: "Brian Rue" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 17, 2001 8:33 AM
Subject: [PHP] mysql_query() problem
> Hi,
>
> I'm getting the error
> <>
>
> from this code:
>
> function validateUser($us
Hi,
I'm getting the error
<>
from this code:
function validateUser($username,$password) {
$conn = connectToMySQL();
mysql_select_db($db_name,$conn);
$query="select * from members where username='".$username."' AND
password='".$password."'";
$result = mysql_query($query,$conn);
if (mysql_nu
At 5:25 PM +0200 8/14/01, _lallous wrote:
>I have PHPMyAdmin 2.21
>I only see "GO" button, where can I upload my SQL file?
>
Well my ISP uses PHPMyAdmin 2.10, which I can't imagine would be that
different from 2.21. Basically, if I load, and click on the database
name in the left top corner:
I have PHPMyAdmin 2.21
I only see "GO" button, where can I upload my SQL file?
"Alnisa Allgood" <[EMAIL PROTECTED]> wrote in message
news:p05100309b79edae8263f@[63.202.15.82]...
> At 4:05 PM +0200 8/14/01, _lallous wrote:
> >Basically I have PHPMyAdmin...
> >If I am to paste the 33,000+ lines SQL
At 4:05 PM +0200 8/14/01, _lallous wrote:
>Basically I have PHPMyAdmin...
>If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more
>than 30secs to execute it which will make everything fail!
>Anyway, I solved it. Check the recent post in the same thread about SQL2PHP
>script.
>
Basically I have PHPMyAdmin...
If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more
than 30secs to execute it which will make everything fail!
Anyway, I solved it. Check the recent post in the same thread about SQL2PHP
script.
"Alnisa Allgood" <[EMAIL PROTECTED]> wrote in m
At 2:21 PM +0200 8/14/01, lallous wrote:
>I can't execute MySql via system() I have no rights!
>
Generally ISPs either give you shell rights or access to PHPMyAdmin,
if they give access to a MySQL database. Otherwise, you'd never be
able to add tables, or modify data. If PHPMyAdmin is installe
om file and
> execute it.
>
> do
> system ( "mysql < sql.fie");
> or
> `mysql < sql.fie`;
>
> dont forget to use -D and -p if User is required.
>
> - Original Message -
> From: "lallous" <[EMAIL PROTECTED]>
> To: <[EMAIL
lt;[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 1:29 PM
Subject: Re: [PHP] PHP: mysql_query()
> No actually I have a .SQL file that is a complete dump of my database.
> All i want to do is the execute with mysql_query() the whole .SQL which
will
> create databases and tables a
rs
> Ben-Nes Michael - Manager
> Tel: 972-4-6991122
> http://sites.canaan.co.il
> --
>
> - Original Message -
> From: "lallous" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 14, 2001 12:59 PM
> Subject: [PHP] PHP: mysql
t;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 12:59 PM
Subject: [PHP] PHP: mysql_query()
> Actually the mysql_query() seems to accept only one statement at a time.
>
> Any work around so i can do query suchs:
>
> mysql_query("
> SELECT
Actually the mysql_query() seems to accept only one statement at a time.
Any work around so i can do query suchs:
mysql_query("
SELECT 1+1;
SHOW DATABASES;
USE database1;
SELECT * FROM table1;
");
Just multiple commands seperated with ';' ? (as if using the Mysql command
prompt)
--
PHP Gene
is ol' fool.
Cheers,
Brad
> From: "Christopher Allen" <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 09:11:05 -0500
> To: "Brad Wright" <[EMAIL PROTECTED]>
> Subject: Re: [PHP] mysql_query problem (more suggestions)
>
> not right because this
> > From: Alvin Tan <[EMAIL PROTECTED]>
> > Date: Tue, 17 Jul 2001 14:38:58 +0800
> > To: Brad Wright <[EMAIL PROTECTED]>, Jason Murray
> > <[EMAIL PROTECTED]>, PHP General List
> > <[EMAIL PROTECTED]>
> > Subject: Re: [PHP] mysql_query pr
lvin Tan <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 14:38:58 +0800
> To: Brad Wright <[EMAIL PROTECTED]>, Jason Murray
> <[EMAIL PROTECTED]>, PHP General List
> <[EMAIL PROTECTED]>
> Subject: Re: [PHP] mysql_query problem (more suggestions)
>
> Hi ag
right wrote:
>Jason,
>I have tried what yoiu suggested. result is the same.
>
> > From: Jason Murray <[EMAIL PROTECTED]>
> > Date: Tue, 17 Jul 2001 15:28:11 +1000
> > To: "'Brad Wright'" <[EMAIL PROTECTED]>, Alvin Tan
> > <[EMAI
Jason,
I have tried what yoiu suggested. result is the same.
> From: Jason Murray <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 15:28:11 +1000
> To: "'Brad Wright'" <[EMAIL PROTECTED]>, Alvin Tan
> <[EMAIL PROTECTED]>, PHP General List <[EMAIL
> Unless i have actually defined a function 'password()', calling 'echo
> password('$password') will (...does, i just double checked)
> causes a Fatal
> Error 'Undefined Function'.
> Nice try tho :)
the original mail said to echo $query, which will include some
text in it that says "password('i
7;echo
password('$password') will (...does, i just double checked) causes a Fatal
Error 'Undefined Function'.
Nice try tho :)
> From: Alvin Tan <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 13:07:45 +0800
> To: Brad Wright <[EMAIL PROTECTED]>
> Subject:
> $testResult = mysql_query("SELECT * FROM login_table where Pass =
$query = "select * from login_table where Pass=password('$password')";
then echo $query to the screen and make sure you see what needs to be there.
Also try mysql_error etc.. from the manual
GL
--ccma
--
PHP General Mail
Hi all',
I have a mysql_query that reads:
$testResult = mysql_query("SELECT * FROM login_table where Pass =
password('$password')") or die ("ouch");
$num_rows = mysql_num_rows($testResult);
the problem is that I keep getting a value of 0 for $num_rows when I know
the table has 1 entry for PAs
73 matches
Mail list logo
