Search found 45 matches
- 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.
- 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...
- 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 =...
- 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.
- 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.
- 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...
- Sat Mar 18, 2006 5:08 pm
- Forum: PHP - Code
- Topic: stupid OOP
- Replies: 2
- Views: 446
- 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...
- 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...
- Wed Mar 15, 2006 11:47 am
- Forum: PHP - Code
- Topic: deleteFileFromServer();
- Replies: 3
- Views: 253
- 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
Thanks
- Sat Mar 11, 2006 4:01 pm
- Forum: PHP - Code
- Topic: can i skip a page?
- Replies: 2
- Views: 122
- 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...
- 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...
- 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...