How is the last mailing date variable set?
Have you tried printing out the queries that are run when it is run manually
and when it is run as a cron to find any differences?
-patrick
On Jul 11, 2010 8:23 AM, Ron Piggott ron.pigg...@actsministries.org
wrote:
I am trying to write a query to
According to php.net, if you don't specify a link iedentifier it closes the
last nonpersistent connection.
http://us3.php.net/mysql_close
Patrick
-- Sent from my Palm Pre
Ron Piggott wrote:
Does mysql_close() close all open database connections?
How would I specify which connection to
I would say that only if this is going to be a very small project should you
think about storing the images in the db. I had a contract job for a real
estate company that had stored all their images in the database. They had
~25K rows of data where each image was ~5K and their website was going
It appears that you had a missing bracket or two and you had misspelled
'WHERE' in the query.
In your code you were checking if the username and password were correct
outside of the while loop. Even though it can be uncommon, if you have
multiple users with the same username then you would only
Just shooting from the hip, I would say the faster method would be to create
the 5 different mysql queries. The amount of time taken up by retrieving
500 articles of either blob or text can add up to a significant amount of
time, whereas 5 queries that average 10 results per query would result in
I believe your best bet is to change how you are iterating through the $row
data.
Since there are only 6 columns of data, I think the simplest solution is to
remove the foreach() and handle each column's data independently, ie:
while($row = mysql_fetch_row($result10))
{
print '
tr
code to access that data in my code, whereas your code you wouldn't
need to add any more code.
Thanks
patrick
On Wed, Jul 15, 2009 at 1:40 PM, Don Collier d...@collierclan.com wrote:
Would that work for multiple rows though? This is getting a varying number
of rows.
Patrick Price wrote:
I
I believe your problem is that the mysqli_fetch_array function on line 39
returns an enumerated array and the extract function on line 41 takes the
values in an array and assigns it to an associative array based on the
keys. Since the keys in an enumerated array are numbers, those are the
Hey all,
I ran across a problem while trying to run a delete query. The website that
I am working on has multiple users in the db for various logins and I was
inadvertently using a less-privileged account and found I couldn't make
delete queries run successfully. I eventually found out the
Hey Frank,
I wasn't able to run the query:
select * from mysql.user where concat(user, '@', host) like (select
CURRENT_USER())
because I didn't have privileges to view the table, but I was able to root
around the INFORMATION_SCHEMA table and find what I needed.
thanks!
patrick
On Tue, Jan 6,
-- Original Message --
Received: Fri, 24 Oct 2008 03:35:47 PM CDT
From: Patrick Price [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] using database without mysql installed
I am trying to access a mysql database server from a php 5.2 server that
doesn't have mysql installed
I am trying to access a mysql database server from a php 5.2 server that
doesn't have mysql installed on it. I don't have access or the ability to
reinstall php on this server. Is it possible to install mysql after php is
installed and up and running?
If it is not possible, what would be
12 matches
Mail list logo