PHP Question

slipondajimmy · 02-24-2007, 09: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
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, 09:19 AM

In php you will need to use the mysql_query function:

PHP Code:

  <?php

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, 09: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, 10: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";

slipondajimmy · 02-24-2007, 11:13 AM

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, 02: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, 09:09 AM	#1 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,010 117.50 NP$ (Donate)	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 WHERE pop_users.uid = pop_groups_users_link.uid AND groupid =4 This pulls the info I need. Any help would be great. __________________ Mascot Factory- Custom Plush, Promotional Plush, and Personalized Teddy Bears\|The Squidget - The tiny travel trailer you build from plans\|

02-24-2007, 09:19 AM	#2 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	In php you will need to use the mysql_query function: PHP Code: `<?php 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 \| Uzbl (my branch) 9thSeptember2009.com

02-24-2007, 09:38 AM	#3 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,010 117.50 NP$ (Donate)	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? __________________ Mascot Factory- Custom Plush, Promotional Plush, and Personalized Teddy Bears\|The Squidget - The tiny travel trailer you build from plans\| Last edited by slipondajimmy; 02-24-2007 at 09:42 AM.

02-24-2007, 10:59 AM	#4 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	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";` __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

02-24-2007, 11:13 AM	#5 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,010 117.50 NP$ (Donate)	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 __________________ Mascot Factory- Custom Plush, Promotional Plush, and Personalized Teddy Bears\|The Squidget - The tiny travel trailer you build from plans\|

02-24-2007, 02:56 PM	#6 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,010 117.50 NP$ (Donate)	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? __________________ Mascot Factory- Custom Plush, Promotional Plush, and Personalized Teddy Bears\|The Squidget - The tiny travel trailer you build from plans\|

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