Search found 24 matches

by phase
Wed May 31, 2006 1:20 pm
Forum: PHP - Security
Topic: Directly viewing unauthorised files by url
Replies: 4
Views: 2204

Directly viewing unauthorised files by url

Hello everyone. I have a problem with my current project and i really hope someone could shed some light on how to rectify. Currently i have a section for clients who can login and download files in a specific folder. for example there will be 50 folders client_1 to client_50. if their session useri...
by phase
Tue Aug 02, 2005 11:09 am
Forum: PHP - Code
Topic: Sorting results from variables after a query
Replies: 5
Views: 365

hi again, i coul dreally use someone to talk through my design of this code, 3 days ive spent looking at this code and trying varying methods and i am not one step further, i really need to revise how i am approaching it... if anyone would be kind enough to chat to me on msn and go through this with...
by phase
Sun Jul 31, 2005 11:38 am
Forum: PHP - Code
Topic: Sorting results from variables after a query
Replies: 5
Views: 365

thats the thing, i need to ORDER BY $points but the $points variable is made by php after the query, and there is no db column to do a where clause, all my sql query does is get the team ids, then php goes on to create the points, won , lost etc.

so i need to order by those variables. :(
by phase
Sun Jul 31, 2005 10:53 am
Forum: PHP - Code
Topic: Sorting results from variables after a query
Replies: 5
Views: 365

Sorting results from variables after a query

hi all, i think im going to strggle even explaining what im trying to achieve here, but ill give it my best shot. im trying to get some ids from a db table, then do some further queries which then determines some values stored in variables. I would then like to order my sql results based on those va...
by phase
Tue Jun 21, 2005 7:05 pm
Forum: PHP - Code
Topic: [SOLVED] selecting results based on how often they appear
Replies: 2
Views: 469

Thank you very much, works perfectly!
by phase
Tue Jun 21, 2005 4:47 pm
Forum: PHP - Code
Topic: [SOLVED] selecting results based on how often they appear
Replies: 2
Views: 469

[SOLVED] selecting results based on how often they appear

hey, this may seem like an obvious question, but i am struggling thinking of a way to do it. what i am trying to do is to use a select query to find out who has been the most active user on my site. i have a mysql table which has a signup page, this table has the user id stored inside it. so i want ...
by phase
Thu May 19, 2005 8:42 am
Forum: PHP - Code
Topic: select query confusion
Replies: 1
Views: 337

select query confusion

hi everyone, i would really like some advice of how to construct a query to retreive the information i need, below is the sql table which contains all the information i need to get, but i keep going around in circles regarding actualy retrieving it. -- Table structure for table `fixtures` -- CREATE ...
by phase
Wed Apr 06, 2005 12:41 am
Forum: PHP - Code
Topic: [solved] getting form fields into database
Replies: 10
Views: 634

thank you very very much, finally sorted 6.40 am! lol im really grateful for your help and i didnt expect the full code, but i was very close by the end, i said line 9 for my query, its just i was getting confused, it was real early in morning an di hate going to sleep not having resolved something ...
by phase
Tue Apr 05, 2005 11:33 pm
Forum: PHP - Code
Topic: [solved] getting form fields into database
Replies: 10
Views: 634

ok this is what im thinking... $sql = "INSERT INTO $table ($names) VALUES ('$values')"; } $result = mysql_query($sql); echo "You have added / edited that record!"; thats my query i originally posted, so please please please tell me how to use that within this script, im going mad...
by phase
Tue Apr 05, 2005 11:14 pm
Forum: PHP - Code
Topic: [solved] getting form fields into database
Replies: 10
Views: 634

argh i been at this too long and still no further, would have loved a simple example instead of clues, as im totally lost after 7 hours. where does the query go, how do i do the query, what variables are going in it, etc etc its obvious i dont have a clue thats why i posted help and been sat on thes...
by phase
Tue Apr 05, 2005 9:58 pm
Forum: PHP - Code
Topic: [solved] getting form fields into database
Replies: 10
Views: 634

i have removed line 5 (global table)
i have checked my global variables and they are on
i really do not uderstand your third comment, i thought this script was to retrieve and submit form values? can youplease let me know how i would do that with the $sql ?

thanks again for your reply.

phase
by phase
Tue Apr 05, 2005 9:31 pm
Forum: PHP - Code
Topic: [solved] getting form fields into database
Replies: 10
Views: 634

thanks for that feyd, but ive been tring to get that to work for 5 hours now with no success :( grrr LOL. ive pasted my full page below, if anyone can assist i getting this working i would be sooo happy., ive tried and unfortunately failed miserably :( <? if($session->isAdmin()){ $filename = "t...
by phase
Tue Apr 05, 2005 4:29 pm
Forum: PHP - Code
Topic: [solved] getting form fields into database
Replies: 10
Views: 634

[solved] getting form fields into database

hi, i have been scouring the internet lately trying to look for an answer to my question, but im at a loss, i kno whteres a way of doing what i want, im just not sure how to go about it. so here goes, i hope somebody out there can help... my question is how do i go about making one fnction which ins...
by phase
Sun Apr 03, 2005 11:37 pm
Forum: Volunteer Work
Topic: a league scenario
Replies: 1
Views: 1640

a league scenario

i coded a leagu in php a while ago, i am hoping to update it and make it easier to use for admin and users alike but i need some inspiration of how to go about it, i will firstly explain what i have, and the problems i have encountered, maybe some php guru could shed some light on a better way of ap...
by phase
Thu Mar 03, 2005 9:43 am
Forum: PHP - Code
Topic: help with my block design
Replies: 3
Views: 548

hey, thanks for the replies, my sql structure is... -- -- Table structure for table `blocks` -- CREATE TABLE `blocks` ( `block_id` int(4) NOT NULL auto_increment, `block_title` varchar(100) NOT NULL default '', `block_file` varchar(100) NOT NULL default '', `block_side` int(1) NOT NULL default '0', ...