Re: [PHP-DB] mysql results with limit
Excellent ... thanks that is exactly what I wanted. Michael. On Sat, 04 Sep 2004 20:21:46 -0600 Doug Thompson [EMAIL PROTECTED] wrote: Michael Gale wrote: Hello, Right now I have a mysql select statement with the LIMIT option of 500. Is there a way to find what the total number of selected results would of been with out doing a mysql select first with out the limi and using mysql_num_rows ? Thanks You could use SQL_CALC_FOUND_ROWS as it works somewhat differently, and probably faster, than the approach you suggest above. This function was introduced in mysql 4.0.0. http://dev.mysql.com/doc/mysql/en/Information_functions.html Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Hand over the Slackware CD's and back AWAY from the computer, your geek rights have been revoked !!! Michael Gale Slackware user :) Bluesuperman.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: chmod
Hi, chmod used to change the permisssion level. you can set your chmod on command line via chmod commnad or if you are using any ftp programme(In case files are on remote server) you can just right click on the file or directory to get the option of chmod setting in most ftp clients. revert back with any problem ;) zareef ahmed --- Torsten Roehr [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear friends, In quiz there is a dir called saved and chmod it to 0755 How do I chmod directory to 0755 Guidance, please. Typing chmod into the search input field on php.net (search whole site) would have lead you to: http://de3.php.net/chmod Please do a bit of research before posting to the list. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Zareef Ahmed :: A PHP Developer in Delhi(India). Homepage :: http://www.zasaifi.com __ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Displaying Text From A Data File
Thanks for your responses guys. I got it to work. Ron - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB [EMAIL PROTECTED] Sent: Saturday, September 04, 2004 2:00 PM Subject: Displaying Text From A Data File I am still new to PHP and I wanted to ask a question. I am wanting to create a PHP script to randomly display one of many greeting messages on my web site. I was going to store them in a text based file. I wanted PHP to randomly select one of them and display it each time the script was loaded. I am still new at PHP and I am not sure where to get started. But I was thinking about this and I am sure this has already been done many times ... I am not sure where to look on the web. Can any of you help me get started? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] This is awesome
Hi, If you have been marketing on the Internet for any length of time, chances are you have heard of Corey Rudl. Corey is one of the most successful REAL-LIFE Internet marketing experts online today. As one of my mentors, I have learned more about the hard- hitting Internet marketing strategies that really work directly from Corey than any other so-called Internet marketing expert. So when I saw Corey's newest idea it only took me a few minutes before I was once again amazed by the POWERFUL STRATEGIES he had uncovered. I am talking about a monthly publication that gives you the NO BS EXAMPLES of real people making real money and the exact STEP-BY-STEP DETAILS of how they're doing it! Corey introduces you to people just like you and me -- real people who are making real money on the Internet -- and shows you the exact strategies they have used to generate incomes in excess of $100,000 to $600,000 online every year... most of them working from home! I was in his new private site just yesterday, and even though I've personally been marketing on the `Net for quite some time, I learned some killer new tricks from people like... Robert who turned his $275 a week paycheck into a site of online investigative resources that takes him only 2 hours each day to run... while earning him OVER $250,000 A YEAR in profits! Ellen, a work-at-home mom who generates a great income by simply selling her homemade soaps from her site! Ken who made $300,000+ IN HIS SECOND YEAR OF BUSINESS by teaching people how to daytrade on the Internet... all from his beachfront condo in Hawaii. Andy, who makes $600,000 a year educating others about the hairloss industry and showing people how he managed to reverse his own hairloss! ... and these are just a few of the people that have already been EXTENSIVELY INTERVIEWED for Corey's brand new private web site. With his monthly subscription you will be exposed to 2 additional interviews every single month. IMPORTANT NOTE: These are not the typical amateur interviews... You will hear these people answer some extremely tough questions about the exact strategies, software, and tools they used to start, build, and grow their businesses to their current success. You'll even hear about the mistakes they made, and how they suggest YOU avoid them! So if you want to skip the failing promotions and get a personal tour of REAL WEB SITES built by REAL PEOPLE making REAL PROFITS on the Internet, then go to... http://dynamic.secretstotheirsuccess.com/t.cgi/823254 ... and take advantage of the invaluable tips and tricks that these Internet successes reveal so that you can start applying them to your business today. All the best, P.S. As an extra bonus, you'll also have the opportunity to enter a special draw for a site review done by Corey and his team (valued at $5,000). Each month, a member's site is drawn and then reviewed by Corey and his team, who dissect the site and give tips and tricks they can use to really accellerate their growth and sales. PLUS! Even if your site isn't chosen, you get the benefit of seeing all of the profitable suggestions that Corey and his team make -- many of which will likely apply to your site, too! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] tool to increase your web sites profitability
Dear Friend, Would you be excited if I told that YOU COULD EARN $3,500 EVERY DAY from a web site that gets only 100 visitors a day... and sells a product that costs less than $150? You could be earning over $100,000 every month! This isn't hype. And this certainly is no joke! It's rare that I am this impressed by a marketing technique... but this literally blew my mind! This is information that we are sharing with our subscribers only -- so listen up! I watched in utter amazement as this guy (who we'll call Mr. H for the moment) turned... 100 visitors a day into $1,277,500 a year in profits! ... and he's just starting out! Get this -- he expects to be earning $10,000,000 a year when he's finished implementing this SIMPLE, yet totally INGENIOUS MARKETING STRATEGY! This isn't about banner advertising... search engines... or newsgroups. And it's certainly not about some rare, high priced product... or huge volumes of traffic. It's about none of that. This guy has developed AN ENTIRELY NEW WAY TO MARKET YOUR BUSINESS on the Internet! And he's blown the gimmicky theories of those so-called marketing experts right out of the water! He's proven that -- using this one totally brilliant marketing strategy -- the small business owner can EARN HUGE PROFITS CONSISTENTLY! Day after day, month after month... the sales just keep rolling in! What's his secret? I can't tell you here. There's not enough room in this e-mail! It took a 90-minute audiotape to capture the original interview with this marketing genius... and ANOTHER tape to answer the questions of 130 participants! However, you're in luck! For the FIRST TIME EVER, Mr. H's blueprint for success is being released... Like I said before, it's really rare that I endorse marketing material... but as soon as I heard his unique success formula, I knew that I had a responsibility to share this EXTREMELY PROFITABLE information with our subscribers. This guy has really proven that ANY SMALL ONLINE BUSINESS can earn big money... using the right approach! To begin learning Mr. H's proven techniques and start making your web site a huge success story, I highly recommend that you check out http://www.marketingtips.com/t.cgi/823254/directsales And don't hesitate! This limited-time opportunity to discover his secrets will only be available for a few more days! Sincerely, theeb basheer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: This is awesome
Theeb Basheer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, If you have been marketing on the Internet for any length of time, chances are you have heard of Corey Rudl. Corey is one of the most successful REAL-LIFE Internet marketing experts online today. As one of my mentors, I have learned more about the hard- hitting Internet marketing strategies that really work directly from Corey than any other so-called Internet marketing expert. So when I saw Corey's newest idea it only took me a few minutes before I was once again amazed by the POWERFUL STRATEGIES he had uncovered. I am talking about a monthly publication that gives you the NO BS EXAMPLES of real people making real money and the exact STEP-BY-STEP DETAILS of how they're doing it! Corey introduces you to people just like you and me -- real people who are making real money on the Internet -- and shows you the exact strategies they have used to generate incomes in excess of $100,000 to $600,000 online every year... most of them working from home! I was in his new private site just yesterday, and even though I've personally been marketing on the `Net for quite some time, I learned some killer new tricks from people like... Robert who turned his $275 a week paycheck into a site of online investigative resources that takes him only 2 hours each day to run... while earning him OVER $250,000 A YEAR in profits! Ellen, a work-at-home mom who generates a great income by simply selling her homemade soaps from her site! Ken who made $300,000+ IN HIS SECOND YEAR OF BUSINESS by teaching people how to daytrade on the Internet... all from his beachfront condo in Hawaii. Andy, who makes $600,000 a year educating others about the hairloss industry and showing people how he managed to reverse his own hairloss! ... and these are just a few of the people that have already been EXTENSIVELY INTERVIEWED for Corey's brand new private web site. With his monthly subscription you will be exposed to 2 additional interviews every single month. IMPORTANT NOTE: These are not the typical amateur interviews... You will hear these people answer some extremely tough questions about the exact strategies, software, and tools they used to start, build, and grow their businesses to their current success. You'll even hear about the mistakes they made, and how they suggest YOU avoid them! So if you want to skip the failing promotions and get a personal tour of REAL WEB SITES built by REAL PEOPLE making REAL PROFITS on the Internet, then go to... http://dynamic.secretstotheirsuccess.com/t.cgi/823254 ... and take advantage of the invaluable tips and tricks that these Internet successes reveal so that you can start applying them to your business today. All the best, P.S. As an extra bonus, you'll also have the opportunity to enter a special draw for a site review done by Corey and his team (valued at $5,000). Each month, a member's site is drawn and then reviewed by Corey and his team, who dissect the site and give tips and tricks they can use to really accellerate their growth and sales. PLUS! Even if your site isn't chosen, you get the benefit of seeing all of the profitable suggestions that Corey and his team make -- many of which will likely apply to your site, too! Wow, we'll all be billionaires in a fortnight!!! ;) Torsten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] here are Coreys e-mail trade secrets
Hi, It's not often that I am surprised by something I see online. And it's even more rare that I stumble upon a book that causes me to literally stop what I am doing and write a letter to everyone I know. But I just discovered that Corey Rudl -- probably one of the best-known and most well-respected experts on the subject of e-mail marketing -- has just released all the details behind how he used e-mail marketing to make $213,705 and attract 41,409 new opt-in subscribers in the last 30 days alone! The truth is, I still can't figure out exactly WHY Corey has made this information available, since it gives everyone -- including his competitors -- the chance to steal the secrets he's spent the last 6 years perfecting! He shows you everything from growing a super-responsive opt-in list as quickly as possible, to generating the highest possible revenue from every e-mail you send, to protecting your business from being wrongly accused of spamming and knowing how to effectively deal with it if you are... He also teaches you when you should mail, how you should mail, what you should write, and when you should send it so that you are guaranteed the best possible results from each and every e-mail... His years of testing are going to completely eliminate all of YOUR guesswork! The thing is, the e-mail marketing industry HAS changed dramatically over the past few years. And while company after company has gone out of business just trying to keep up with all these changes, Corey has continued to generate over $2.4 million every year with e-mail marketing. And this book shows you step-by-step what he did and how he did it so you can take his strategies and model them to create your own success. With over 430+ pages that include tons of great real-life examples, I was especially impressed by the way Corey's book breaks down exactly HOW you can implement -- and test -- all the tips and techniques that he teaches into your own business. I still think that Corey's going to regret giving all this information away, so I would advise you to grab this book while you can! It really does tell you everything you need to do to grow your business successfully with e-mail marketing. Find out more at: http://www.marketingtips.com/emailsecrets/t.cgi/823254/ All the best... theeb basheer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: This is awesome
I'm confused. How does this pertain to php-db? Let's keep this shit off the list please. Yours Truely, Randy On Sun, 5 Sep 2004 17:47:15 +0200, Torsten Roehr [EMAIL PROTECTED] wrote: Theeb Basheer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, If you have been marketing on the Internet for any length of time, chances are you have heard of Corey Rudl. Corey is one of the most successful REAL-LIFE Internet marketing experts online today. As one of my mentors, I have learned more about the hard- hitting Internet marketing strategies that really work directly from Corey than any other so-called Internet marketing expert. So when I saw Corey's newest idea it only took me a few minutes before I was once again amazed by the POWERFUL STRATEGIES he had uncovered. I am talking about a monthly publication that gives you the NO BS EXAMPLES of real people making real money and the exact STEP-BY-STEP DETAILS of how they're doing it! Corey introduces you to people just like you and me -- real people who are making real money on the Internet -- and shows you the exact strategies they have used to generate incomes in excess of $100,000 to $600,000 online every year... most of them working from home! I was in his new private site just yesterday, and even though I've personally been marketing on the `Net for quite some time, I learned some killer new tricks from people like... Robert who turned his $275 a week paycheck into a site of online investigative resources that takes him only 2 hours each day to run... while earning him OVER $250,000 A YEAR in profits! Ellen, a work-at-home mom who generates a great income by simply selling her homemade soaps from her site! Ken who made $300,000+ IN HIS SECOND YEAR OF BUSINESS by teaching people how to daytrade on the Internet... all from his beachfront condo in Hawaii. Andy, who makes $600,000 a year educating others about the hairloss industry and showing people how he managed to reverse his own hairloss! ... and these are just a few of the people that have already been EXTENSIVELY INTERVIEWED for Corey's brand new private web site. With his monthly subscription you will be exposed to 2 additional interviews every single month. IMPORTANT NOTE: These are not the typical amateur interviews... You will hear these people answer some extremely tough questions about the exact strategies, software, and tools they used to start, build, and grow their businesses to their current success. You'll even hear about the mistakes they made, and how they suggest YOU avoid them! So if you want to skip the failing promotions and get a personal tour of REAL WEB SITES built by REAL PEOPLE making REAL PROFITS on the Internet, then go to... http://dynamic.secretstotheirsuccess.com/t.cgi/823254 ... and take advantage of the invaluable tips and tricks that these Internet successes reveal so that you can start applying them to your business today. All the best, P.S. As an extra bonus, you'll also have the opportunity to enter a special draw for a site review done by Corey and his team (valued at $5,000). Each month, a member's site is drawn and then reviewed by Corey and his team, who dissect the site and give tips and tricks they can use to really accellerate their growth and sales. PLUS! Even if your site isn't chosen, you get the benefit of seeing all of the profitable suggestions that Corey and his team make -- many of which will likely apply to your site, too! Wow, we'll all be billionaires in a fortnight!!! ;) Torsten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- randy [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Search page
K, first off I'm brand new to PHP and databases. So I
hope my question isn't stupid or unfitting to the
list.
I am creating a search and results page of, right
now 3 fields with more to add.
Perhaps not necessary to my question, I have created a
working SQL statement which involved one main
transactional table and a number of joins to static
tables where the id codes inserted into the main table
are referenced. All is fine.
I thought I could use AND / OR statements, but both
don't allow for any number of fields unusued or force
a return if the first condition is met. I have a
variable in the SQL statment , like LocationCity =
'resset1', LocationState = 'resset2', etc.
Just sure how to get the code to see if it was passed
a value or not. Also to treat each field
independently, so if the user leaves the first 2
unchanged , and only enters the 3rd it will search for
that particular condition.
Also I should mention, that when the Search form comes
up, all the drop down menus say Please Select, that
label actually has a value, which I assume is common.
Regardless on submit that value is going.
I was looking at the following code but the !='' tells
me that it's looking for an empty string. So if my
dead Please Select value is sent , do I need to put
the value in there, i.e. !='XXX' ?
?php
if (isset($HTTP_GET_VARS['states'])
$HTTP_GET_VARS['states']!=''){
if (!isset($isNotFirst) OR $isNotFirst==false){
$isNotfirst = true;
$KT_search = '1=1 AND ';
}else{
$KT_search .=' AND ';
}
$KT_search .='LocationState =
\''.$HTTP_GET_VARS['states'].'\' ';
}
?
Well I hope I don't get flamed since I'm obviously
clueless and seeking some advice when perhaps I should
be finding it on my own.
Thank you ,
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie Questions
On Thu, 2 Sep 2004, Torsten Roehr wrote:
mysql_query() will return a result set. There are
different functions to extract the rows from it. I
would recommend mysql_fetch_assoc() - it returns an
associative array of the current row/record set where
the field names of your table become the keys of the
array. So if you select firstname, lastname you will
get an array like this:
array('firstname' = 'My firstname', 'lastname' = 'My lastname')
Just loop through your result set to output/process
the data. Try this:
$result = mysql_query('SELECT firstname, lastname FROM table');
while ($row = mysql_fetch_assoc($result)) {
echo $row['firstname'] . ' ' . $row['lastname'];
}
Well, I have this:
$result=mysql_query('SELECT * FROM $table ORDER BY surname, street, housenumber ASC');
while ($row=mysql_fetch_assoc($result))
{
echo $row['surname'].' '.$row['firstname'].' '.$row['housenumber'].'
'.$row['street'];
}
and I get Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
resource in /home/.fanny/pjh/4seasonsatmapleton.org/4sam/directory/showForm-mod.php on
line 26
Line 26 is the while statement.
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie Questions
On Sun, 5 Sep 2004, Pete Holsberg wrote:
Well, I have this:
$result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum ASC');
while ($row=mysql_fetch_assoc($result))
{
echo $row['lastname'].' '.$row['firstname'].' '.$row['housenum'].'
'.$row['street'];
}
and I get Warning: mysql_fetch_assoc(): supplied
argument is not a valid MySQL result resource in
/home/.fanny/pjh/4seasonsatmapleton.org/4sam/directory/showForm-mod.php
on line 26
Line 26 is the while statement.
blush I have to learn to keep a 3x5 card with my column
headings nearby!!
But having corrected that, I'm running into another
problem.
I added:
if (!$result) {
echo Could not successfully run query ($sql) from DB: . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo No rows found, nothing to print so am exiting;
exit;
}
And they output nothing nowm so I assume that there are
things to print. But the while statement produces nothing
also.
Also, I think I misunderstood something someone saod
earlier. Is it true that the above mysql_query call does
not change the way the database is stored by simply sorts
the copy that's in memory?
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie Questions
On Sun, 5 Sep 2004, Pete Holsberg wrote: blush I have to learn to keep a 3x5 card with my column headings nearby!! But having corrected that, I'm running into another problem. Additional blushing CASE-SENSITIVITY, Dummy! ;-) sigh -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Name searches for the spelling impaired
Is there a way to program MySQL so that it can find the name Smyth if the user looks for Smith? And similar mispellings that are similar in sound. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Name searches for the spelling impaired
On Mon, 6 Sep 2004 11:09, Pete Holsberg wrote:
Is there a way to program MySQL so that it can find the
name Smyth if the user looks for Smith? And similar
mispellings that are similar in sound.
The SOUNDEX string function in mysql may be what you want.
http://dev.mysql.com/doc/mysql/en/String_functions.html
Something like
SELECT fields FROM table WHERE SOUNDEX(name) = SOUNDEX('searchvalue')
Cheers
--
David Robley
Lead me not into temptation, I can find it myself.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
