Search found 92 matches

by JimiH
Thu Jul 30, 2009 4:08 am
Forum: PHP - Code
Topic: schedule tasks Batch file
Replies: 6
Views: 183

Re: schedule tasks Batch file

Reinstalled PHP 5, now everything working correctly :D
by JimiH
Wed Jul 29, 2009 6:28 am
Forum: PHP - Code
Topic: schedule tasks Batch file
Replies: 6
Views: 183

Re: schedule tasks Batch file

Ok, you where right I had two php.ini's

Now the code executes from the command line but throws an error about a missing dll "php4ts.dll"

Thanks

Geoff
by JimiH
Wed Jul 29, 2009 5:48 am
Forum: PHP - Code
Topic: schedule tasks Batch file
Replies: 6
Views: 183

Re: schedule tasks Batch file

Thanks, I'm using PHP CLI Shown by typing php -v C:\Documents and Settings\ajlsvradmin>php -v PHP 5.2.5 (cli) (built: Nov  8 2007 23:18:51) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies Also there is only one php.ini on the IIS server and this ha...
by JimiH
Wed Jul 29, 2009 4:26 am
Forum: PHP - Code
Topic: schedule tasks Batch file
Replies: 6
Views: 183

Re: schedule tasks Batch file

No none of them work when called from the batch file. I did have an "include" to a connection php file but have moved all this into my main php file. Now its fails on the mysql_connect() Its like when mysql is called from the command line it doesn't exist, but if called from the browser it...
by JimiH
Tue Jul 28, 2009 7:13 am
Forum: PHP - Code
Topic: schedule tasks Batch file
Replies: 6
Views: 183

schedule tasks Batch file

Hello I have the following bat file that calls up a php script @echo OFF   "c:\Progra~1\php\php.exe" email_open_vsi.php %* This is supposed to run a php script that fires off an email however I cant get it to work from the batch file, running the php script from the browser is not a proble...
by JimiH
Mon Mar 02, 2009 6:27 am
Forum: PHP - Code
Topic: Query was empty
Replies: 0
Views: 95

Query was empty

Hello I have a tick box on my form ($commupdate) which decides if extra data is posted to a DB or not. The code if ( $commupdate == 'on' ) {               $sql="update projects set VSI_NUMBER='$VSI_NUMBER',DESC1='$DESC1',Salesman='$Salesman',ENGINEER ='$ENGINEER',Prod_Spec ='$Prod_Spec'        ...
by JimiH
Thu Jan 08, 2009 7:35 am
Forum: PHP - Code
Topic: Insert into mysql condition checkbox
Replies: 3
Views: 241

Re: Insert into mysql condition checkbox

Finally sorted it by commenting the below line out, dont know what it was doing there but
it was causing the page to display "Query was empty" error, due to $sql1 being empty

Code: Select all

//$result=mysql_query($sql1,$connection) or die(mysql_error());
Thanks
by JimiH
Thu Jan 08, 2009 4:20 am
Forum: PHP - Code
Topic: Insert into mysql condition checkbox
Replies: 3
Views: 241

Insert into mysql condition checkbox

Hello I have the following code which insert values into two mysql tables "projects" and "project_comments" $sql="update projects set VSI_NUMBER='$VSI_NUMBER',Salesman='$Salesman',ENGINEER ='$ENGINEER',Prod_Spec ='$Prod_Spec'             ,CUSTOMER ='$CUSTOMER',SALESGROUP ='$...
by JimiH
Wed Jul 16, 2008 9:33 am
Forum: Databases
Topic: MSSQL Query on a Query??
Replies: 4
Views: 633

Re: MSSQL Query on a Query??

Found the answer here

http://forums.devshed.com/ms-sql-develo ... 54974.html

The dreaded, evil "select star" apparently!

thanks

Geoff
by JimiH
Wed Jul 16, 2008 8:26 am
Forum: Databases
Topic: MSSQL Query on a Query??
Replies: 4
Views: 633

Re: MSSQL Query on a Query??

Thanks

I added

Code: Select all

 
 
HAVING Finmth ='0'
 
 
I now get this?

Server: Msg 207, Level 16, State 3, Line 2
Invalid column name 'Finmth'.
by JimiH
Wed Jul 16, 2008 7:34 am
Forum: Databases
Topic: MSSQL Query on a Query??
Replies: 4
Views: 633

MSSQL Query on a Query??

Hello I have a query which displays data in a specified way SELECT Count([ECR].ECR_Number) AS CountOfECR_Number,CAST(DATEPART(mm, CreatedDate) AS NVARCHAR) + '/'+ CAST(DATEPART(yy, CreatedDate) AS NVARCHAR)AS fn,CASE CAST(DATEPART(mm, CreatedDate) AS NVARCHAR) + '/'+ CAST(DATEPART(yy, CreatedDate) A...
by JimiH
Fri Jul 04, 2008 8:57 am
Forum: PHP - Code
Topic: Order by specified Array?
Replies: 2
Views: 159

Re: Order by specified Array?

Thanks Chris I managed to generate the require sort order within SQL using ms access first now I need to convert the sql used by access, there are difference between the two, IIF in access and CASE in mssql. SELECT Count([dbo_ECNs by month].ECN_Number) AS CountOfECN_Number, [dbo_ECNs by month].theda...
by JimiH
Thu Jul 03, 2008 6:32 am
Forum: PHP - Code
Topic: Order by specified Array?
Replies: 2
Views: 159

Order by specified Array?

Hi I have this code which returns 12 results, I would like them ordered by a specified Array, ie 10/2007, 11/2007, 12/2007, 01/2008 etc etc at the moment they are ordered like below. 33 1/2008 30 10/2007 28 11/2007 22 12/2007 30 2/2008 35 3/2008 35 4/2008 23 5/2008 27 6/2008 31 8/2007 38 9/2007 $con...
by JimiH
Mon Jun 02, 2008 9:19 am
Forum: PHP - Code
Topic: Dropdown Refresh problem!
Replies: 3
Views: 426

Re: Dropdown Refresh problem!

Ok, solved

If anyone else has this problem the fix was to change

Code: Select all

$cat=$HTTP_GET_VARS['cat'];
to

Code: Select all

$cat=$_GET['cat'];
Not to sure why it worked but it does.

thanks

Geoff
by JimiH
Thu May 29, 2008 5:41 am
Forum: PHP - Code
Topic: Dropdown Refresh problem!
Replies: 3
Views: 426

Re: Dropdown Refresh problem!

Think it may be something to do with this section //////////        Starting of first drop downlist ///////// echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['cat_id']==@$ca...