Search results for query: *

I have tried something similar and added tomcat user to apache's group. They both get access to the main dir which is chmod'ed to 775. The problem occures when either tomcat or apache create a directory within that main directory. That then becomes read-only for the other user apart from the...

Hi, I have a user rights issue that I need some help with and would appreciate any solutions/suggestions. I have to run an app which has a few servlets that run through tomcat and some php files that are on apache web server. Code in all scripts and servlets need to access a directory on the...

i dont wana be pain but would you mind explaining why this query doesn't work and yours do. becuase this is meant to produce similar results.. select distinct u.* from users u, user_remove_search urs where urs.user_id=1 and u.user_id<>urs.rem_user_id

IT WORKED!!!! you guyz've just put a smile on my face after 4 days is misery... :D Thanks Tony, you are a star mate!!

Hey guyz, i'm gonna try and explain the previous post again with more details okay lets say USERS table have got these entries in it USER_ID USER_NAME 1 zeeshan 2 jack 3 martin 4 kathrine 5 John 6 George 7 Leeane Now USER_ID...

i didnt try the previous query but it didnt bring any results back. and also looking at the query it says bring all user from users tabel where u.user = urs.rem_user_id. I actually want it to bring all users from users table where u.user_id is not equal to urs.rem_user_id.

I think i didnt explain it properly again well lets just take it this way...this query brings all users in colums REM_USER_ID against USER_ID 1 select distinct u.* from users u, user_remove_search urs where urs.user_id=1 and u.user_id=urs.rem_user_id Now if i make this change where...

i'm sorry if i didnt make it clear enough. I'll give it another go. okay lets say USERS table have got these entries in it USER_ID USER_NAME 1 zeeshan 2 jack 3 martin 4 kathrine and following entries in USER_REMOVE_SEARCH table USER_ID REM_USER_ID 1...

hey Tony, I have tried this query but it didnt work either...this query's been on my nurves all weekend and i still cant sort it... btw, your query required a little change with table names so here's the changed query. SELECT u. * FROM users u LEFT JOIN user_remove_search urs USING (...

I wish i could run this query but unfortunately i'm running on an old version of mysql 3.23. It doesnt allow sub queries. Any other suggestions.?? Thanks

Hey i'm using mysql 3.23 for my DB. I am trying to run a simple mysql query with a join. Although i'm normally good at joins but for some reason i cant get this query to work and its just a simple join. right have a users table USERS user_id int user_name varchar(200) USER_REMOVE_SEARCH...

Hey, I have got PHP 4.3.10 Installed on my local system (windows) and server (Fedora). foreach loop runs perfectly on my local system but it gives me problems on the server. here is a sample code. $FilenameParameters1 = array('ar', 'bg', 'bc', 'far'); foreach ($FilenameParameters1 as...