On Mon, Jul 03, 2006 at 11:14:48AM -0400, Mike wrote:
I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need
to compile it with MS SQL support. Per PHP docs, I installed FreeTDS
and tested it and it works. Now I need to (re)compile PHP to get the
support I need to access MS SQL
I see they call mysql_query twice which doesn't look like I'm gaining
anything over running the 2 queries:
SELECT count(*) as MyCount FROM aTable
SELECT * FROM aTable LIMIT 5
But I suppose I need to time it for my app.
http://us3.php.net/mysql_num_rows
mancini at nextcode dot org
14-Nov-2005
So how do I get this information on the PHP side?
mysql SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
- WHERE id 100 LIMIT 10;
mysql SELECT FOUND_ROWS();
I count 2 queries above (unless there is some caching magic). Whatever. I
was hoping to add another column (like FOUND_ROWS) to an
Here are some thoughts on the couple of methods shown:
1.
SELECT count(*) as MyCount FROM aTable # Fast query done on server size
SELECT * FROM aTable LIMIT 5 # Fast limited data return query done server side
2.
SELECT * FROM aTable # Potentially slow query, lots of data stored in PHP
Team,
I was wondering if anybody can help me or guide me
On what tables to make. I want to do all the data entry
I just do not know what to do. It's for a fantasy football
League.
Here is my project!
Let me know if anyone can help me directly, through
Email, AIM, or MSN.
Karl James wrote:
Team,
Heh!
I was wondering if anybody can help me or guide me
On what tables to make. I want to do all the data entry
I just do not know what to do. It's for a fantasy football
League.
Here is my project!
Let me know if anyone can help me directly, through
Email, AIM,
MySQL 4.1/PHP 4.2
I am trying to generate a email to send to people with a list of events
happening through out the month.
I am pulling the email addresses from the database with no problem, but
when I put the list of events inside of the mail(), it barks at the do
while statment.
Here is
I don't see you closing the single quote at the end of the statement before
do loop
Bastien
From: Mark Bomgardner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Php-Db php-db@lists.php.net
Subject: [PHP-DB] Do while loop inside of mail()
Date: Wed, 05 Jul 2006 16:55:23 -0500
MySQL
Team,
When I receive an email from this list and only this list,
I receive 6 copies.
Can any one suggest any ideas why this is happening.
I didn't sign up 6 times.
Thanks, for your advise.
Its becoming annoying, obviously!
Karl
Karl James (TheSaint)
mailto:[EMAIL PROTECTED]
Mark Bomgardner wrote:
MySQL 4.1/PHP 4.2
I am trying to generate a email to send to people with a list of events
happening through out the month.
I am pulling the email addresses from the database with no problem, but
when I put the list of events inside of the mail(), it barks at the do
10 matches
Mail list logo