No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
24 Posted Topics
I have some crystal reports that i would like to use PHP in order to execute the reports and then either view the reports in the browser as is or to generate PDF files. Does anybody know how to do this and what is required to be installed on the … | |
I have a table in and MSSQL DB that list period and week start dates for any date in a financial year but the page is only display the week numbers and period number none of the dates does any body have any ideas please. <?php $serverName = 'DESKTOP-R7RU80H\SQLEXPRESS'; $connectionInfo=array('Database'=>'WebPortal', … | |
Does anybody know how i can connect a PHP web site to an OpenEdge Progress Database. I have the following as a connection file that when I run it does not error but there is also nothing to say it has connected either. I have System DSN 32bit ODBC connection … | |
A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is … | |
The following code is erroring on the connection string line 5 it used to work but then i had to move the sql server to another box and now it fails have i forgotten to do something on the sql server or is there error in my code my error … | |
I have a couple of SQL databases that i am trying to link results from. My first database is calendar that i need to return the details for today so current date and targets for sales and orders that works my second data base is for orders which i can … | |
I have two values in my code one is from a SQL Server query echo to the screen as formattedNum10d my second value is stored in a MySQL database and echo to the screen as formattedNum10f. In a seperate column i would like to subtract foramattedNum10f from formattedNum10d and echo … | |
I have an If Statement that isnt loading the right image any help would be great <?php if($formattedNum6 > $PeriodSalesTarget):{ echo '<img src="images/TargetMetGreen.png" alt="" />';} elseif($formattedNum6 > $CummulativePeriodSalesTarget):{ echo '<img src="images/TargetMet.png" alt="" />';} else:{ echo '<img src="images/TargetNotMet.png" alt="" />';} endif; ?> $formattedNum6 = 515,839 $PeriodSalesTarget = 1,366,000 $CummulativePeriodSalesTarget = 503,600 … | |
How do i formatt the dates do the come out as DD/MM/YYYY please <?php $convar = mysqli_connect("localhost","root","","ffp_calendar"); if(mysqli_connect_errno()) { echo "Error occured while connecting with the database ".mysqli_connect_errno(); } $sqlvar = "SELECT * FROM `calendar` WHERE `CurrentDate` = curdate()"; $resultvar = mysqli_query($convar, $sqlvar) or die("Bad Query: $sql"); while($rowvar = mysqli_fetch_assoc($resultvar)) … | |
How do i format my Query result so it has thousand seperator and only to 2 decimal places <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Daily Sales</title> <link rel="stylesheet" href="../styles/login.css" media="all" /> </head> <body class="normal"> <?php include("../includes/x3connect.php"); ?> <?php $sql="SELECT SUM … | |
Hi I have the following code that i can run in MSSQL Query and the result are returned correctly but when i try to run it in PHP it errors what do I need to change to get it to work please. SELECT SUM (CASE WHEN FFP.BPARTNER.CUR_0='GBP' THEN (FFP.SORDERQ.YORIQTY_0 * … | |
I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I … ![]() | |
Any ideas why this is not actuall writing to the database <form method="post" action=""> <p> </p> <table width="300" border="0" align="center" cellpadding="0" cellspacing="10"> <tr> <td width="100" align="right"> Film Title : </td> <td><input type="text" name="Film_Title"></td> </tr> <tr> <td width="100" align="right"> Film Format : </td> <td> <select name="Format_ID"> <option>- Select Film Format -</option> <option … | |
How do i get this to write to a txt file instead of message box pleaseWr Function ReceiveSerialData() As String ' Receive strings from a serial port. Dim returnStr As String = "" Dim com1 As IO.Ports.SerialPort = Nothing Try com1 = My.Computer.Ports.OpenSerialPort("COM3") com1.ReadTimeout = 10000 Do Dim Incoming As … | |
Hi, I am new to programming and have attached my code so far, i need to insert the code to read data from serial port but havent a clue where to put it or how any help would be great Imports System Imports System.IO.Ports Public Class Form1 Private mySerialPort As … | |
Hi, I have writen web sites before but have been asked to create a VB program, but dont know where to start so hoping someone can help me. I need to create a program that sits waiting for data from the serial port which is attached to a set of … | |
Hi, We have a intranet with thousands of excel spreadsheets, we have set all the browsers so they open any excel spreadsheet in excel itself not within the browser which is how we wanted it all, unfortunately someone has now developed a spreadsheet they would like to open in the … | |
Hi, I am trying to get a random image as a background to a cell, and have tried many ideas but none work, in desperate need for help can anybody please. I have this in the header [code] <script language="javascript" type="text/javascript"> var img_rnd = new Array (); img_rnd[0] = "hp-1.jpg"; … | |
I have managed to get a random image setup to work on my cell using ASP and now want it to change the table size of the table over top of the image depending on the image, i know in my head what needs to be done (I think) just … | |
Hi, I am developing a company intranet and was wondering is it possible to open the files from the server locations rather than using href as this opens the file from your local temp directory and subsequently read only too. Regards Matthew Clay | |
when i view an internal web page i have created in IE it doesnt do the same as it does in FireFox. I have an iFrame that loads a page by default that page has the two div listed below called to centre the text both vertically and horizontially and … | |
I have a site where i am returning listings from a database based on the page links and this works fine, i then try to get it so it returns a list that matches a criteria for two fields but this errors saying I have not supplied all the information, … | |
Is it possible to Echo a Web Page link in PHP? If it is can anyone supply the code please. Matthew ![]() | |
Hi, I have got some code that allows me to click an image map link that then changes text in a DIV further down the page though this is only doing plain text and i can't get it to write in links can any one help with the code???? Cheers … |