Querys

Cooper · 11-03-2005, 09:21 PM

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

cytech · 11-10-2005, 04:07 PM

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.

11-03-2005, 09:21 PM	THREAD STARTER #1 (permalink)
Cooper NamePros Member Join Date: May 2005 Location: Portsmouth, UK Posts: 191	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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)