On 03/06/15 09:37, Aziz Saleh wrote:
On Wed, Jun 3, 2015 at 12:25 AM, Ron Piggott
ron.pigg...@actsministries.org
mailto:ron.pigg...@actsministries.org wrote:
On 02/06/15 23:20, Aziz Saleh wrote:
On Tue, Jun 2, 2015 at 11:08 PM, Ron Piggott
ron.pigg...@actsministries.org
On 02/06/15 23:20, Aziz Saleh wrote:
On Tue, Jun 2, 2015 at 11:08 PM, Ron Piggott
ron.pigg...@actsministries.org
mailto:ron.pigg...@actsministries.org wrote:
On 02/06/15 22:58, Aziz Saleh wrote:
On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott
ron.pigg...@actsministries.org
On 02/06/15 22:58, Aziz Saleh wrote:
On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott
ron.pigg...@actsministries.org
mailto:ron.pigg...@actsministries.org wrote:
I am working through the process of removing \'s from the
database. I am trying to get this query using a variable
it will execute correctly --- only removing \'s from the database table
text columns?
Thank you.
Ron
of foreach loop
-end of foreach loop
Ron
This is extremely helpful. Thank you very much.
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='.$val.'
* where $val is a database
On Wednesday November 5 2014 2:14 AM, Roberto Spadim wrote:
with mariadb/mysql:
2014-11-05 4:20 GMT-02:00 Ron Piggott ron.pigg
I am working on. If you need
clarification please ask me. Thank you for helping me. Ron
Ron Piggott
www.TheVerseOfTheDay.info
names?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
it be? Ron
===
form action=add_my_image.php method=post
enctype=multipart/form-data
label for=fileFilename:/label
input type=file name=filebr
input type=submit name=submit value=submit
/form
===
mySQL table structure:
===
reference – INT 10 auto_increment primary
caption – VARCHAR 250
image_type
quality and not hap hazard.
Thank you for any help you are able to provide me with.
Ron Piggott
www.TheVerseOfTheDay.info
=contact_center_email_template_maintenance_user_input_data /
Ron Piggott
www.TheVerseOfTheDay.info
?
Ron Piggott
www.TheVerseOfTheDay.info
() BETWEEN `member_subscription_suspensions`.`subscription_begins` AND
`member_subscription_suspensions`.`subscription_expires`
AND
`member_subscriptions`.`list` = 1
How do I change this query to exclude any one who has a suspension record for
“today”. IE CURDATE()
Thanks for your help. Ron
Ron
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
Hi Everyone.
I manage an e-mail list. I am trying to add a new function into it:
suspensions. The idea is that someone wouldn’t have to unsubscribe.
Instead there would be a record of their suspension
still getting use to Prepared Statements, this is why I am asking these
questions --- Thank you for helping me. Ron
===
?php
$dsh = 'mysql:host=localhost;dbname='.$database;
$dbh = new PDO($dsh, $username, $password);
#query for the authorization code
$query = SELECT `authorization_code` FROM
a comma legitimately exists in the
middle of a field.
I am wondering how phpmyadmin makes Excel files on the fly --- Is it a
class?
I am unsure how to proceed.
Ron Piggott
www.TheVerseOfTheDay.info
-Original Message-
From: Jimi Thompson
Sent: Tuesday, November 08, 2011 4:59 PM
What is the preferred method used to export mySQL to Excel within the context
of PHP? I have looked on Google and found a wide variety of options. Ron
Ron Piggott
www.TheVerseOfTheDay.info
Trying to setup so within the administration screen the users may download
the database.
Ron Piggott
www.TheVerseOfTheDay.info
-Original Message-
From: Bastien Koert
Sent: Tuesday, November 08, 2011 1:33 PM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB
the day #?
Ron
www.TheVerseOfTheDay.info
, but this is the idea I am trying to achieve:
SELECT `trivia_answer_`answer`` FROM `Bible_trivia`
Thanks in advance,
Ron
www.TheVerseOfTheDay.info
= new PDO($dsh, $username, $password);
Is there a way to amend this with a second database connection?
Ron
www.TheVerseOfTheDay.info
AS discount
FROM `subscriber_details`
WHERE `email` = '$client_email'
LIMIT 1
), 10, 0 ) )
) AS discount_percentage
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
From: Amit Tandon
Sent: Monday, August 22, 2011 5:45 AM
To: Ron Piggott
Cc: php-db@lists.php.net
)
- 5% (for a purchase made between 4 months and a year ago)
Is there a way to do this all within the context of 1 query?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
” column
Is there a similar way to do what I am trying:
SELECT `reference` FROM `sitemap_pages` WHERE `last_record_update` NOT LIKE (
CURDATE() . % ) ORDER BY `reference` +0
Thanks for helping.
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
for your help. Ron
SELECT cross_reference_article_2 FROM
(
SELECT `cross_reference_article_2` FROM
`frequently_accessed_passages_of_scripture_cross_reference` WHERE
`cross_reference_article_1` = 1
) UNION ALL (
SELECT `cross_reference_article_1` FROM
need to do this within PHP?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Geoff Lane
Sent: Thursday, June 23, 2011 2:15 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: mysql COUNT row results
Hi Ron,
On Thursday, June 23, 2011, 6:14:38 AM, you wrote:
Is there a way that
SELECT COUNT(auto_increment
the the COUNT result appended to each row.
Thoughts anyone? Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-05-30 12:00:01 27 27.
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
for helping me,
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
error. These are the permissions I have available.
SELECT
INSERT
UPDATE
DELETE
INDEX
CREATE TEMPORARY TABLE
EXECUTE
CREATE
ALTER
DROP
LOCK TABLES
REFERENCES
CREATE ROUTINE
How to resolve the error?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-execute();
I am looking for the equivalent of mysql_numrows
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( Unable to select database);
$result=mysql_query($query);
$num=mysql_numrows($result);
Ron
The Verse of the Day
“Encouragement from God’s Word”
http
I figured out last night’s query and it’s a dozy.
The sub query
SELECT * FROM `verse_of_the_day_Bible_trivia` WHERE
`verse_of_the_day_Bible_trivia`.`live` =1 ORDER BY
`verse_of_the_day_Bible_trivia`.`date_added` DESC
puts the questions into descending order making the INNER JOIN link
condition is to eliminate categories
with less than 10 questions.
- See table structures below
Thank you for your help.
Ron
===
SELECT `verse_of_the_day_Bible_trivia`.`Bible_trivia_category_reference` ,
`verse_of_the_day_Bible_trivia`.`date_added` , COUNT(
`verse_of_the_day_Bible_trivia
these WHERE conditions
which will still allow all 8 categories to be included in the result?
Thank you,
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
thank you for explaining this to me Amit. It works. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
From: Amit Tandon
Sent: Friday, May 06, 2011 5:49 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] COUNT and OUTER JOIN results
a reserved word in mySQL? Is this the
reason the query fails?
Ron
===
SELECT SUM( impressions ) AS impressions, SUM ( usage ) AS usage FROM (
(
SELECT IF ( SUM( `web_advertisements_our_clients_usage`.`impressions` ) ,
SUM( `web_advertisements_our_clients_usage`.`impressions` ) , 0
Thank you for the suggestion. This is the actual query that I implemented:
Amazing how this works. Ron
SELECT SUM( `impressions_total` ) AS impressions_total , SUM( `usage_total` )
AS usage_total FROM (
(
SELECT IF ( SUM( `web_advertisements_our_clients_usage
I am programming the search feature for a directory. I am trying to make the
query display the results in order of relevance (Greatest to least). I thought
I had to perform the query similar to a column being selected in order to sort
the results by relevance. What changes do I need to make
I have found mySQL commands for LCASE and UCASE, but nothing equal to the PHP
command “ucwords”.
Is there a mysql command or will I need to use PHP to manipulate the strings?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
Is there a command in mySQL that would allow me to SELECT the rows where the
`fax` column is more than 11 characters long?
OR
Do I need to use PHP to assess this?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
of the toll free phone number in tact.
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
I was wondering this Bastien. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Bastien Koert
Sent: Tuesday, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue
I found a way to do this Bastien:
UPDATE `database`.`table` SET `toll_free` = CONCAT( '1-', `toll_free` )
WHERE `toll_free` LIKE '866-%'
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Bastien Koert
Sent: Tuesday
someone help me please?
Ron
SELECT `ministry_profiles`.`reference`, `ministry_profiles`.`organization`,
`ministry_profiles_activity`.`activity`
FROM
(
(
( `ministry_profiles` LEFT OUTER JOIN `ministry_profiles_listing_details` ON
`ministry_profiles`.`reference` =
`ministry_profiles_listing_details
?
I want to make a WHILE loop to display the search results for the listing the
user is editing. (You can see where I have started the ul ... /ul ... I
want that area in the loop)
Ron
$dbh = new PDO($dsh, $username, $password);
$stmt = $dbh-prepare(SELECT `reference`, `organization
Does mySQL have the ability to figure out if it is leap year? If so, what is
the correct syntax for:
AND `day` 366 unless it is leap year
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
,
for when it is needed every 4th year)
Ron
===
$day_of_year = getdate();
#add 1 because yday starts at 0
$day_of_year = $day_of_year[yday] + 1;
$query=SELECT * FROM
`$database1`.`friends_of_the_ministry_Bible_reading_plans` WHERE `plan` =1 AND
`day` = $day_of_year ORDER BY `day` DESC LIMIT 15
',
`assigned_reading` varchar(65) NOT NULL DEFAULT '',
`content_summary` varchar(500) NOT NULL,
PRIMARY KEY (`reference`)
)
Are you able to offer me some more help with this table structure?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original
`.`bible_dictionary_reference` =1
LIMIT 1
Thank you for helping me. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
I had an extra “=” sign by the WHERE, my mistake, I couldn’t see it originally.
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
From: Ron Piggott
Sent: Saturday, January 08, 2011 7:42 AM
To: php-db@lists.php.net
Subject: Top 10 Query
I am trying
is for scoring how many
the user got right.
Ron
This works very well. Thank you for your assistance Dan. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Daniel Brown
Sent: Wednesday, January 05, 2011 9:34 PM
To: Ron Piggott
Cc: php-db@lists.php.net ; Mike Stowe
PHP to display the definitions in random order? OR Is there a way
do this in mySQL that would mix and match results from different rows? This is
the query gives me the 5 results
SELECT `reference` , `word` , `explanation`
FROM `Bible_dictionary`
WHERE `live` =1
ORDER BY RAND( )
LIMIT 5
Ron
) {
echo $word . br /\r\n;
}
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
From: Ron Piggott
Sent: Sunday, January 02, 2011 5:54 PM
To: php-db@lists.php.net
Subject: Word Activity Application
I am working on a word activity --- matching words
The INSERT INTO query successfully executes EXACTLY as it is. The bind’s
aren’t working. :{Variable name] is being saved to the database. What do I
need to change? I am not understanding this yet. Ron
$dsh = 'mysql:host=localhost;dbname='.$database2;
$dbh = new PDO($dsh, $username
have supported me this year when I have had
questions. I am physically handicapped, although I don’t want to make a big
deal about it. I have appreciated the opportunity to continue developing my
PHP / mySQL programming skills in 2010. The Internet is a life line to me.
Ron
$dbh = new mysql
because the SELECT queried for the information I am using
for this RSS Feed.
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
From: Ron Piggott
Sent: Sunday, December 19, 2010 11:38 PM
To: php-db@lists.php.net
Subject: SUM() Math in mySQL
I am working
appreciate it.
Ron
SELECT new_rss_feed_listings.reference, new_rss_feed_listings.last_update,
SUM(`include_in_rss_feed`) AS current_rss_feed,
`ministry_profiles`.`organization`, `ministry_profiles`.`city`,
`ministry_profiles`.`province_state`, `ministry_profiles`.`postal_zip_code
What change is needed to this query so if “currently_in_rss” is NULL it will be
assigned a value of 0
SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
`ministry_profiles` WHERE `rss_feed_include` = 1 GROUP BY `rss_feed_include`
Ron
The Verse of the Day
“Encouragement from
of: ( `os1`
) VALUES ( NULL ) . There are a number of records where `os1` is NULL. I
would like these rows to retrieve as well. How do I make a WHERE clause for a
cell that is NULL ?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
Hello,was searching online for MLM platforms to use and came across your
information with MLM can you tell me, how do you tie in with this and how is it
working for you.
Sincerely,
Ron Orth
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE `name` =
'$name'” occurs will $_SESSION['referral_clients_reference'] be populated with
the mysql_insert_id() value? If not, should I just query for it? Ron
mysql_query(INSERT INTO `referral_clients` ( `reference` , `name
I have a column that is VARCHAR 250. I need it to be able to accept french and
spanish accents. The purpose of the column is organization names. The
“Collation” default is “latin1_swedish_ci” What do I need to do? Ron
The Verse of the Day
“Encouragement from God’s Word”
http
I have moved the GROUP BY outside now Chris.
In the queries that make up the UNION ALL (such as below) is there a way to
only SELECT matches that are 70% or greater based on the users input? Right
now each and every listing is a search result.
Ron
===
SELECT `ministry_profiles`.`reference
, lastname,comments FROM users WHERE
MATCH(firstname,lastname,comments) AGAINST ('$searchterm')
Ron
`
(`ministry_profiles_reference`,`ministry_categories_reference`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1568 ;
Ron
--
From: Bastien phps...@gmail.com
Sent: Thursday, October 21, 2010 7:12 AM
To: Artur Ejsmont ejsmont.ar...@gmail.com
Cc: Ron
`
`ministry_profile_categories`
`ministry_profiles_listing_details`
The bare minimum for a listing is only a record in he table
`ministry_profiles`
Is there a way to modify this query to accommodate only a record in the
table `ministry_profiles`
Ron?
SELECT `ministry_profiles`.`reference
Very much so. Thank you Bastien. I have never used an OUTER join before
and didn't know it would be required for this project. Ron
--
From: Bastien phps...@gmail.com
Sent: Thursday, October 21, 2010 8:03 PM
To: Ron Piggott ron.pigg
to be part of the
MATCH. I have made this category column a FULLTEXT index in the
ministry_categories table. The query that produces the error is below.
Is there a way this will work?
Ron
===
SELECT `ministry_profiles`.`reference`, `ministry_profiles`.`organization`
FROM
the
results? Can I do this some how with results.reference and
results.organization (I made the UNION ALLs sub queries)
Thanks for the help.
Ron
SELECT reference, organization FROM (
SELECT `ministry_profiles`.`reference`, `ministry_profiles`.`organization`
FROM
(
(
( `ministry_profiles` LEFT
Is there a query you could help me write a SELECT query that would search table
`ministry_profiles` for where column `organization` has the same organization
more than once? I am trying to delete the duplicate organization records, but
I am working with 1,000+ businesses and I can't go
For a query similar to:
SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor'
how do I escape the ' for 's?
in the words database.
Is there any way of achieving this?
Ron
The Verse of the Day
Encouragement from God's Word
www.TheVerseOfTheDay.info
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to
your MySQL server version for the right syntax to use near 'SOUNDS_LIKE
`word` ORDER BY `word` ASC
I think it wants me to specify an actual word, not the `word` column.
Is there a way to tweak either of the syntaxes I have started?
Ron
Hello, Ron:
I apologize if I was supposed to reply
no
activity, how can i make it in such a way it won't expire unless the
user logs out?
regards
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
into a sub query and
have a main query order the results of the sub query ORDER BY words ASC
so all the words displayed are in alphabetical order?
Ron
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to get the auto_increment value to be added in order of
sequence of when the visits occurred.
Thank you.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
` ORDER BY `initial_access`;
I don't understand the error, your way of creating a table is new to me.
Did something small get missed?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I figured it out, the permissions weren't set on the user to allow the
command to work. Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am wondering why:
SELECT * FROM `bible_concordance_usage` WHERE `date_accessed` = CURDATE()
Doesn't work when `date_accessed` is column type timestamp
And
What would work?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
`.`bible_concordance_words_reference`)
AS occurrences FROM `bible_concordance_words` INNER JOIN
`bible_concordance_word_reference` ON
`bible_concordance_words`.`reference` =
`bible_concordance_word_reference`.`bible_concordance_words_reference`
WHERE `word` LIKE '$letter%' ORDER BY `word` ASC
Thanks for your help.
Ron
: $segment wasn't submitted through a form.
Thanks.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks, Ron
--
-Original Message-
From: Andrés G. Montañez andresmonta...@gmail.com
To: ron.pigg...@actsministries.org
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] NULL to 0
Date: Sat, 17 Jul 2010 23:20:20 -0300
SELECT
IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered
is the
middle and if the user has answered it then this record on the right hand
side, otherwise the fields are NULL. Does this make sense? Ron
SELECT `verse_of_the_day_Bible_trivia`.`reference` FROM
( `my_Bible_trivia_knowledge_profile` LEFT JOIN
`my_Bible_trivia_knowledge_questions_answered
---
with the user profile on the left hand side and then the question is the
middle and if the user has answered it then this record on the right hand
side, otherwise the fields are NULL. Does this make sense? Ron
SELECT `verse_of_the_day_Bible_trivia`.`reference` FROM
Thanks. That answer worked. Ron
--
-Original Message-
From: Kesavan Rengarajan k...@trk7.com
To: ron.pigg...@actsministries.org ron.pigg...@actsministries.org
Cc: ron.pigg...@actsministries.org ron.pigg...@actsministries.org,
php-db@lists.php.net php-db@lists.php.net
Subject: Re
What modification does this query need that if either total_score or
questions_answered have a value of NULL that it will be changed to 0
(ZERO) Ron
SELECT SUM(`my_Bible_trivia_knowledge_questions_answered`.`score`) AS
total_score, `my_Bible_trivia_knowledge_profile`.`questions_answered` FROM
. How do I get the value of `Bible_trivia_category_reference` from the
second SELECT query to be used in the first? What change is needed? Ron
SELECT * FROM `verse_of_the_day_Bible_trivia` WHERE `assigned_date` =
'-00-00' AND `seasonal_use` = $bible_trivia_application AND `live` =1
Yes I have checked that $last_mailing_date contains a date.
I was wrong, It doesn't work when it is live. I had only ran the first
query before I added the AND NOT portion, sorry.
Ron
I am trying to write a query to select a trivia question, but I don't want
the trivia question category
is increased by 1.)
I would like to display a fifth one that is ORDER BY RAND () LIMIT 1
--- Only I don't know how to ensure it isn't one of the four that are
being displayed already. Any suggestions?
Ron
SELECT `highlights`.`reference`, `highlights`.`page_command`,
`highlights`.`page_title` FROM
I am received the error message:
Unknown column 'title' in 'field list'
from the query below. I am not understanding what I have done wrong. The
goal of the query is with for a RSS feed determining the 15 most current
articles.
Ron
SELECT title, content_date, content, reference FROM
Ok. I have received help and got it fixed. I didn't have the variables
matching the first query. I haven't done a UNION ALL recently. Thanks.
Ron
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
I have done something like you have said below Chris.
I put the code which is common to be loops in it's own file and I did an
INCLUDE
Ron
-Original Message-
From: chris smith dmag...@gmail.com
To: ron.pigg...@actsministries.org
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB
{ confuses PHP. I am not sure what I should be doing.
$_SESSION['user_reference'] stores the value of the logged in user. This
is how I tell if s/he is logged in or not --- and which loop I want to
invoke.
Suggestions?
Ron
if ( $_SESSION['user_reference'] 0 ) {
$user_reference = $_SESSION
Is there a way to round up in mySQL? This result may give 3.2 --- so I
want the result to be 4?
SELECT ( count(`reference`) / $items_per_page ) AS total_pages FROM
`store_product_profile` WHERE `store_category_reference` =$reference AND
`live` =1
--
PHP Database Mailing List
Does mysql_close() close all open database connections?
How would I specify which connection to close?
Ron
Guys thanks for your help.
When I went back to my code I figured out what threw me off: I only used
one database connection to begin with ... I had created a user that
exists on the two databases for the part of the application I am
writing. I forgot about this.
Thanks!
Ron
-Original
if the user has the wrong password. Is there a
better way to do this?
Ron
1 - 100 of 372 matches
Mail list logo