Search found 45 matches

by modplod
Sun May 03, 2009 9:24 am
Forum: Databases
Topic: PHP MS-SQL Query problem
Replies: 1
Views: 333

Re: PHP MS-SQL Query problem

sorted, There was no problem, turned out to be a typo in my mssql class I was writing at the same time.
by modplod
Sun May 03, 2009 9:20 am
Forum: Databases
Topic: mssql dates returned incorrectly
Replies: 0
Views: 231

mssql dates returned incorrectly

$query = "SELECT hlc_ticket, convert(varchar, getdate(), 21) hlc_until FROM table WHERE  (hlc_ticket LIKE '$prefix' ) AND (hlc_until >= '$date')"; Hi all, I'm having a problem with pulling dates from mssql DB with php, The above query pulls all the correct rows, but when I look at the dat...
by modplod
Fri May 01, 2009 6:56 pm
Forum: Databases
Topic: PHP MS-SQL Query problem
Replies: 1
Views: 333

PHP MS-SQL Query problem

Hi, all, Just a wee problem with a mssql query. The following query works when I enter it in to server mngt studio, and gives the correct results, but when I pipe it through mssql_query I get a whole bunch of errors. Can anyone see the problem with it or suggest an alternative query, thanks $query =...
by modplod
Sun Apr 12, 2009 8:38 am
Forum: PHP - Code
Topic: mysql DATE_ADD usage in PHP
Replies: 4
Views: 157

Re: mysql DATE_ADD usage in PHP

yes I did, and as far as I can tell it looks good.
by modplod
Sun Apr 12, 2009 12:48 am
Forum: PHP - Code
Topic: mysql DATE_ADD usage in PHP
Replies: 4
Views: 157

Re: mysql DATE_ADD usage in PHP

yes, I set up the object,, the error does not generate a error message, but manifests its self later in the code, I tracked it to this query, which just fails to retrive any records or return any results.
by modplod
Sat Apr 11, 2009 6:37 pm
Forum: PHP - Code
Topic: mysql DATE_ADD usage in PHP
Replies: 4
Views: 157

mysql DATE_ADD usage in PHP

Hi all, I'm trying to create a report using a collection of records dated within the 7 days follow a given date. The sql statement I'm using is $query = "SELECT * FROM swnb_cards WHERE department = '$department' AND issue_date BETWEEN '$start_date' AND DATE_ADD('$start_date', INTERVAL $interval...
by modplod
Sat Mar 18, 2006 5:08 pm
Forum: PHP - Code
Topic: stupid OOP
Replies: 2
Views: 446

cool thanks, but how would I go about that?


edit: err I think I just thunk how to do :P
by modplod
Sat Mar 18, 2006 4:19 pm
Forum: PHP - Code
Topic: stupid OOP
Replies: 2
Views: 446

stupid OOP

HI all. I'm realy stuck on this, yet another illogical opp thingy... I have created a set of objects needed to control my site in index.php, one called configObj which has all the config methods and one called $secObj which holds some simple security methods, My problem is how can I acces the meatho...
by modplod
Wed Mar 15, 2006 12:15 pm
Forum: PHP - Code
Topic: deleteFileFromServer();
Replies: 3
Views: 253

using what you gave me I threw this togeather, do you think it will work to prevent people from removing files out side of the fileRoot dir? function deleteFileFromServer($filepath) { if ($filepath){ // check that the file is within public root folder and not a system file if(stristr($filepath, $thi...
by modplod
Wed Mar 15, 2006 11:47 am
Forum: PHP - Code
Topic: deleteFileFromServer();
Replies: 3
Views: 253

cool thanks, I'll give that a try later
:) and let you know the results,
by modplod
Tue Mar 14, 2006 12:54 pm
Forum: PHP - Code
Topic: deleteFileFromServer();
Replies: 3
Views: 253

deleteFileFromServer();

hi all, I was wondering what the easest way to enable a user to remove a file from the server would be? and where I may find an example to get me started?

Thanks
by modplod
Sat Mar 11, 2006 4:01 pm
Forum: PHP - Code
Topic: can i skip a page?
Replies: 2
Views: 122

As thats way over my head and seems a little redundant to my objectives, I think I'll skip it
by modplod
Sat Mar 11, 2006 3:37 pm
Forum: PHP - Code
Topic: can i skip a page?
Replies: 2
Views: 122

can i skip a page?

hi, I need help with this. I have this $out .= "<img src=\"thumbnail.php?id=12345\" width=\""."80"." height="."60".">"; which uses this <?php header("Content-type: image/jpeg"); // act as a jpg file to browser $oDatabase = my...
by modplod
Fri Mar 10, 2006 11:52 am
Forum: PHP - Code
Topic: simple image gallery>>>>
Replies: 0
Views: 1283

simple image gallery>>>>

hi all, over the last two weeks i've been working on my first OOP script, I finnished the first phase, and thourght it was worth posting, even just to find ways to improve the code.. This class reads a directory structure, creates thumbs and displays them in a table with links to view a lager versio...
by modplod
Thu Mar 09, 2006 2:07 pm
Forum: PHP - Code
Topic: newest images, how to find
Replies: 7
Views: 309

i just thourht of a better flow for my script... if I was to look at the directories instead of the files first to derive wich has had files added, then just search the files within thoes folders, for the newest files kind of like ->find the 3 newest (or last updated) folders -->look within newest f...