PHP Question

slipondajimmy · 02-24-2007, 10:09 AM

I am working on a site and I need some info. I have a "Friends" Module (picture myspace) and I need to to only pull members of a certain group ID. I think this is where pulls th list of members to add....

$sqlstr ="SELECT uid, uname, level FROM ".$db->prefix("users")." WHERE level>0 AND uid!=$myid LIMIT $inf, $tranche";

But I need to to pull from 2 tables so it will also get the groupid . I have written the sql statement to pull from where I need to but cant figure out how to write it into php . here is the sql statement

SELECT pop_users.uid, pop_users.uname, pop_groups_users_link.groupid
FROM pop_users, pop_groups_users_link
????: NamePros.com http://www.namepros.com/programming/298094-php-question.html
WHERE pop_users.uid = pop_groups_users_link.uid
AND groupid =4

This pulls the info I need.

Any help would be great.

Barrucadu · 02-24-2007, 10:19 AM

In php you will need to use the mysql_query function:

PHP Code:

  <?php

????: NamePros.com http://www.namepros.com/showthread.php?t=298094
mysql_connect('localhost', 'username', 'password')or die(mysql_error());

mysql_select_db('database')or die(mysql_error());

 
$result = mysql_query('SELECT pop_users.uid, pop_users.uname, pop_groups_users_link.groupid FROM pop_users, pop_groups_users_link WHERE pop_users.uid = pop_groups_users_link.uid AND groupid =4')or die(mysql_error());

 
mysql_close();

?>

slipondajimmy · 02-24-2007, 10:38 AM

So there is no way just to add to this

$sqlstr ="SELECT uid, uname, level FROM ".$db->prefix("users")." WHERE level>0 AND uid!=$myid LIMIT $inf, $tranche";

So it will pull from 2 places?

Or maybe just add a groupid field to the user table?

Barrucadu · 02-24-2007, 11:59 AM

after looking at your pm, is this the sql you want?

PHP Code:

  $sqlstr = "SELECT u.uid, u.uname, g.groupid FROM ".$db->prefix("users")." AS u, ".$db->prefix("user_group_link")." AS g WHERE u.uid = g.uid AND g.groupid =4"; 

????: NamePros.com http://www.namepros.com/showthread.php?t=298094

slipondajimmy · 02-24-2007, 12:13 PM

i think that did it once I changed it to groups_users_link

I still need to limit the result but I think I can handle that part . Thanks a bunch. There will be some more stuff I need to do im sure this thread should stay open..lol

slipondajimmy · 02-24-2007, 03:56 PM

I do have another question.

Lets say I have a list of 10 people and i would like people to post a bulletin on a site such as myspace, Like a train script. how would I go about doing that?

All I really need is something what will display the code and the bottom of a page that a user can copy/paste into a bulletin

could I use any information from my above posts to do that?

any ideas?

02-24-2007, 10:09 AM	THREAD STARTER #1 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,026	PHP Question I am working on a site and I need some info. I have a "Friends" Module (picture myspace) and I need to to only pull members of a certain group ID. I think this is where pulls th list of members to add.... $sqlstr ="SELECT uid, uname, level FROM ".$db->prefix("users")." WHERE level>0 AND uid!=$myid LIMIT $inf, $tranche"; But I need to to pull from 2 tables so it will also get the groupid . I have written the sql statement to pull from where I need to but cant figure out how to write it into php . here is the sql statement SELECT pop_users.uid, pop_users.uname, pop_groups_users_link.groupid FROM pop_users, pop_groups_users_link ????: NamePros.com http://www.namepros.com/programming/298094-php-question.html WHERE pop_users.uid = pop_groups_users_link.uid AND groupid =4 This pulls the info I need. Any help would be great.

02-24-2007, 10:19 AM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	In php you will need to use the mysql_query function: PHP Code: `<?php ????: NamePros.com http://www.namepros.com/showthread.php?t=298094 mysql_connect('localhost', 'username', 'password')or die(mysql_error()); mysql_select_db('database')or die(mysql_error()); $result = mysql_query('SELECT pop_users.uid, pop_users.uname, pop_groups_users_link.groupid FROM pop_users, pop_groups_users_link WHERE pop_users.uid = pop_groups_users_link.uid AND groupid =4')or die(mysql_error()); mysql_close(); ?>` __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

02-24-2007, 10:38 AM	THREAD STARTER #3 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,026	So there is no way just to add to this $sqlstr ="SELECT uid, uname, level FROM ".$db->prefix("users")." WHERE level>0 AND uid!=$myid LIMIT $inf, $tranche"; So it will pull from 2 places? Or maybe just add a groupid field to the user table? Last edited by slipondajimmy; 02-24-2007 at 10:42 AM.

02-24-2007, 11:59 AM	#4 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	after looking at your pm, is this the sql you want? PHP Code: `$sqlstr = "SELECT u.uid, u.uname, g.groupid FROM ".$db->prefix("users")." AS u, ".$db->prefix("user_group_link")." AS g WHERE u.uid = g.uid AND g.groupid =4"; ????: NamePros.com http://www.namepros.com/showthread.php?t=298094` __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

02-24-2007, 12:13 PM	THREAD STARTER #5 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,026	i think that did it once I changed it to groups_users_link I still need to limit the result but I think I can handle that part . Thanks a bunch. There will be some more stuff I need to do im sure this thread should stay open..lol

02-24-2007, 03:56 PM	THREAD STARTER #6 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,026	I do have another question. Lets say I have a list of 10 people and i would like people to post a bulletin on a site such as myspace, Like a train script. how would I go about doing that? All I really need is something what will display the code and the bottom of a page that a user can copy/paste into a bulletin could I use any information from my above posts to do that? any ideas?

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