[advanced search]
 

Go Back   NamePros.com > Discussion > Web Design & Development > Programming

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.


Closed Thread
 
LinkBack Thread Tools
Old 11-03-2005, 08:21 PM   #1 (permalink)
NamePros Member
 
Join Date: May 2005
Location: Portsmouth, UK
Posts: 191
495.00 NP$ (Donate)

Cooper is on a distinguished road


Caution Querys

I'm running IPB 1.3 Final
I wrote this simple script to get members e-mail addresses from my forums database.
Code:
<?PHP
//Connect to DB
mysql_pconnect("localhost","cooper","password");
mysql_select_db("cooper_forum");

//Tell the script what to look for and where
$result = mysql_query("SELECT email FROM `ipbmembers`");

//Tell Script what infromation to collect
while($r=mysql_fetch_array($result)) 
{
$email = $r["email"];

//Display info
print "$email, ";

}
?>
Now i need it to somehow link with `ipbpfields_content`so that if "field_2" = "n" then the members email address is not displayed when the query is run.

I'm new to PHP and not sure how to do it. Any advice on how then that would be great
__________________
:kickass: Brand New Media Site Script MyMediaScript.com:kickass:
Alpha Web Directory - Permanent $15 Solid PR3 Inner Pages
Burnout 5
Cooper is offline  
Old 11-10-2005, 03:07 PM   #2 (permalink)
NamePros Member
 
Join Date: Nov 2005
Posts: 116
26.50 NP$ (Donate)

cytech is on a distinguished road


Hey there.

Give this a go:

Code:
<?PHP
//Connect to DB
mysql_pconnect("localhost","cooper","password");
mysql_select_db("cooper_forum");

//Tell the script what to look for and where
$result = mysql_query("SELECT m.email,i.field_2 FROM ipbmembers AS m LEFT JOIN ipbmembers AS i ON i.UNIQUEID=m.UNIQUEID");

//Tell Script what infromation to collect
while($r=mysql_fetch_array($result)) 
{
if($r[field_2]!="n"){
$email = $r["email"];
}

//Display info
print "$email, ";

}
?>
Where I have UNIQUEID be sure to place the unique identifier.
cytech is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Site Sponsors
Advertise your business at NamePros

All times are GMT -7. The time now is 01:14 PM.


Powered by: vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Template-Modifications by TMS
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85