[advanced search]
Results from the most recent live auction are here.
13 members in the live chat room. Join Chat!
Register Rules & FAQ NP$ Store Active Threads Mark Forums Read
Domain Name Industry Newsletter
Go Back   NamePros.Com > Design and Development > Programming
Reload this Page MySQL & PHP Question
User Name
Password

Old 06-06-2008, 06:29 PM   · #1
freeflow
NamePros Member
 
Trader Rating: (0)
Join Date: Dec 2006
Posts: 113
NP$: 12.00 (Donate)
freeflow is on a distinguished road
Question MySQL & PHP Question
How can I make the "if" statement do something if the mysql query finds a result?

$sql = 'SELECT * FROM `Domains` WHERE `status` LIKE \'%delete%\';

if ($sql == ???) {

Do something;

}

Thanks for your help.


Please register or log-in into NamePros to hide ads
freeflow is offline   Reply With Quote
Old 06-06-2008, 07:37 PM   · #2
Tree
NamePros Regular
 
Tree's Avatar
 
Name: Trevor
Location: Atlanta, GA, USA
Trader Rating: (3)
Join Date: Feb 2006
Posts: 334
NP$: 0.00 (Donate)
Tree will become famous soon enoughTree will become famous soon enough
PHP Code:
<?php
$query = mysql_query('SELECT * FROM `Domains` WHERE `status` LIKE \'%delete%\'');
if (mysql_num_rows($query) > 0) {
    # Do something
}
?>
__________________
NCIDev.com
Last edited by Tree : 06-06-2008 at 07:40 PM.
Tree is offline   Reply With Quote
Old 06-06-2008, 09:12 PM   · #3
psalzmann
NamePros Regular
 
Trader Rating: (20)
Join Date: Feb 2006
Posts: 517
NP$: 360.80 (Donate)
psalzmann is just really nicepsalzmann is just really nicepsalzmann is just really nicepsalzmann is just really nice
PHP Code:
$query = mysql_query("
        SELECT *
        FROM Domains
        WHERE status LIKE '%delete%'
");
if (mysql_num_rows($query) > 0)
{
         while ($res = mysql_fetch_array($query))
         {
              // $res['something']...
         }
}
psalzmann is offline   Reply With Quote
Reply

NamePros is a revenue sharing forum.
« Need a working popunder script | Help with Pagination »

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


Site Sponsors
Traffic Down Under Exdon Proof is in the Parking
Advertise your business at NamePros
All times are GMT -7. The time now is 09:39 AM.

Advertise At NamePros - Contact Us - NamePros.Com - Archive -Privacy Statement -Top

Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0