GIDForums  

Go Back   GIDForums > Computer Programming Forums > MySQL / PHP Forum
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 15-Aug-2003, 08:25
zuzupus zuzupus is offline
Junior Member
 
Join Date: Jul 2003
Posts: 70
zuzupus is an unknown quantity at this point

select problem


Hi,

I got problem when selecting some directories i have to show users name which have rights to particular directories but according to my code its just printing all customers in some specified field.

so i want when select some directories then only i can see users not like what i did it always show user

Please look at the link and let me know is it possible to get user name when select the radio button in this link.

server2.vitodesign.com

PHP Code:

<input type="radio" name="ddir"  onCLICK="" value="<?=$r->sys_pk ?>" id="dir<?=$r->sys_pk ?>" /></td> 

<td class="black2">Benutzer und Rechte:</td>
 <?php
 $query = "SELECT u.name FROM t_user u INNER JOIN tr_directories_user r ON r.fk_t_user=u.sys_pk WHERE r.fk_t_directories=".$r->sys_pk;//some wrong in assigning this 
 $result = mysql_query($query) or die("Query failed : " . mysql_error());
   while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  print "\t<tr>\n";
  foreach ($line as $col_value) {
      print "\t\t<td class='black2'>$col_value</td>";
                                                  }
                    print "\t</tr>\n";
              }

   ?> 


If anything not clear please let me know

Thanks in advance
what should i have to write on ONCLICK
Thanks in advance
 
 

Recent GIDBlogAccepted for Ph.D. program by crystalattice

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with php5 cgi installation fab13 Apache Web Server Forum 3 19-Nov-2003 10:11
unwanted scrollbar problem kelly001 Web Design Forum 3 24-Oct-2003 11:44
link problem [1][2]----- zuzupus MySQL / PHP Forum 0 16-Sep-2003 06:16
join problem zuzupus MySQL / PHP Forum 0 14-Aug-2003 06:11
combo box select problem zuzupus MySQL / PHP Forum 2 23-Jul-2003 12:25

Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 13:01.


vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.