fabzster

Hi I am using razorflow chart software to create a dashboard, this works perfectly on my dev server(Locally) but when I upload it to hosted server(Web) it does not load properly. https://www.razorflow.com/ I get the following errors: value is not a number Uncaught TypeError: Cannot read property 'split' of undefined …

Hi I have a php file with html forms and variables in php. I generate a policy document that is displayed in the web page and is then created in PDF and emailed to the client. I create the PSF via using EZPDF but This runs slow when creating the …

Hi I am having issues with a function that I created, I execute the below function on load on another page. I would like it to enable all the inputs if a check box is selected or disable all inputes if it is not. This works but it only works …

Hi I managed to get the tutorial from the below link to work. http://www.blueicestudios.com/chained-select-boxes-using-php-mysql-ajax/comment-page-11/#comment-34199 I would love to know how to edit this script so as to get the first dropdown to populate an already existing dropdown without the loader image and without the hiding of any dropdowns. I would …

Hi I use the following Query: SELECT DISTINCT COUNT(tblpolicies.PolicyNumber)AS Figures, tblstores.GroupName, tblstores.StoreName, tblstores.StoreType FROM tblpolicies, tblstores WHERE DateReceived BETWEEN '2012-06-01' AND '2012-06-30' AND tblstores.StoreType='FLAGSHIP' AND tblpolicies.PolicyStatus='ACTIVE' AND tblstores.StoreStatus='ACTIVE' AND tblpolicies.StoreId=tblstores.StoreId GROUP BY StoreName ORDER BY Figures DESC What this does is give me a result: 95 GroupName StoreName StoreType This …

Hi I have 2 MYSQL servers One on a LAN and one on a dedicated server at an ISP. I cannot run normal replication as my ISP does not allow this. I have however written a script that will dump the data to a .sql file and ftp it to …

Hi I have a MYSQL DB hosted on a Win 2003 server on my LAN and a Mysql DB on a dedicated (linux) server at our ISP. I would like to dump a few tables to a .sql file and ftp it to the server and then import the .sql …

Hi I pull data from a MYSQL database to populate a Drop down <td class="<?php print $Bank_ca_error;?>">Bank Name</td> <td> <select name="Bank" id="Bank" tabindex=24 style="color: <?php print $TextColour;?>"/> <option><?php print $_SESSION['Bank_ca'] ;?></option> <?php //Get Data to populate drop down $BankQuery = "SELECT BankName FROM tblbank ORDER BY BankName"; $BankResult = mysql_query …

Hi We have a competition running that I would like to automate getting the results with PHP from my MYSQL DB. I can run a query on the Database to get the following results Consultant1 20 sales Consultant2 10 sales Consultant3 5 sales Consultant4 1 sales Consultant5 3 sales Consultant6 …

Hi I have a script that is scheduled to run with task scheduler will download a file via FTP and import it to a mysql DB How would I go about handling the retries if there is either a problem with the connection or something. I tried going about it …

Hi I have a join query which I use for a report ok I have a query to give me results for a report that will give me all the stores that sold policies from a group during a period. It works however I cannot get it to give me …

Hi I am using the following join query to get a list of stores that have sold policies during the day. But I need it to be distinct [CODE] $Query = mysql_query("SELECT tblpolicies.StoreId , tblpolicies.DateReceived , DailyGroup.GroupName , DailyGroup.StoreName , DailyGroup.PortfolioName FROM tblpolicies LEFT OUTER JOIN (SELECT StoreId , GroupName, …

Hi I am trying to get this function to work but having issues [CODE] // check that policy number not entered on the DB if no policy is entered skip Mysql query function validatePolicyNumber($PolicyNumber){ //Return Session Value so user does not have to retype entry return $_SESSION['PolicyNumberAdd'] = $PolicyNumber; $Connection …

Hi I have a db that has the following Data for example: PolicyNumber, StoreId, ConsultantName,ClientName, ClientSurname I would like to have a report that will give me a list of policies done for that day seperated by store printed to PDF. So Basically Store - 12CEL 24Hr001 Bob Joe Soap …

Hi I am creating a web form but seem to have a problem with my table I have attached the form and css file but renamed the styles.css to styles.txt to allow me to upload it My problem is I cannot get the paydate to slot left, I have tried …

Hi Normally I would use the mysql_fetch_array command to get vallues from a DB array to print in seperate tables like below: [code=php] echo "<table width=\"100%\" border=\"1\"body bgcolor=\"#ffffff\"align=\"center\"text=\"#ffffff\">"; echo "<th>THUMBNAIL</th><th>NAME</th><th>SIZE</th><th>LOCATION</th>"; while($r = mysql_fetch_array($TagSearch)) { $Code = $r["Code"]; $Name = $r["Name"]; $Size = $r["Size"]; $ImgPath = $r["ImgPath"]; $PurchaseDate = $r["PurchaseDate"]; $StartCycle …

Hi I have a query which i run to give me the monthly amount of money that needs to get loaded to our consultants cards. Our system has changed and I need to get the same data but differently The query needs to join three tables consultants,voucher,gift_cards. The only difficulty …

Hi I have an xml file which i get data from using the simplexml_load_file function I then grab values and store them in variables now the thing is that the amount of games displayed will be different I need to grab the values from them with a while loop or …

Hi Im not sure if i need a join here, i cant seem to grasp the concept of joins really batteling with this I allocate points to id numbers in the points table and i have a list of all id numbers in the consultants table the id numbers only …

Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total …

Hi This is my first post here and I have just started using php so please be kind LOL I have tried to use the script below to do a search on the database but it keeps spitting out [B](Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource …