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
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
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
[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
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
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
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
> 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
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 question...
how can i
> 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
[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
Simon,
You can use the same name for your result as in:
$query="SELECT * FROM table_name WHERE id='$variable'";
$result=mysql_query($query);
$array1=mysql_fetch_array($result);
$query=SELECT * FROM table_name WHERE name='$variable2'";
$result=mysql_query($query);
$array2=mysql_fetch_array($resul
Hi
Try the following to find out what's happening :
$result = mysql_query($query,$conn) or die (mysql_error());
Or try echo'ing $result to see what it contains. It should contain something
like this if everything is working fine :
Resource id #2
Regards
Girish
- Original Message -
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
44 matches
Mail list logo
