No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
47 Posted Topics
 | hi guys, i have a site which is protected using php and stored username and passwords in mysql database. is there a script which will protect a directory and run off the mysql database username and password as opposed to just a standard htaccess file? help urgently need for this … |
| | hi there, I have tried numerous queries on my database but 0 rows affected. Basically the Documents table has the ProductID's held in here. so say they have 100 docs for a Product it would record the ProductID for in every Document entry. This works fine. issue is now we …  |
| | hi there, i have tried numerous fixes on the net but none are working. basically my form sends an email in php script but after the form has been submitted. this works if i physically press the submit button on my page. i want to have it where it will … |
| | hi there, looking to get some help. i have created a view which pulls together from different product tables a review date. the thing is that a client could have review dates for the same product and i need it to only display the most recent review date. i tried … |
| | hi there, i have a site which has a jquery datepicker in it. i went onto jquerys site and downloaded the timepicker code and tried to add this in but it is not working. currently my code is: $('.datepicker').datepick({ dateFormat: "dd/mm/yyyy", alignment: 'bottom', showOtherMonths: true, selectOtherMonths: true, renderer: { picker: … |
| | hi, i need a way to allow my users to replace placeholders with data from my recordset in mysql. situation is: 1. the create a letter and have keywords defined from my recordset columns such as {Name}, {DOB}, {Email} and so on. 2. currently i can generate the ltter but … |
| | Hi does any of you guys know a free way to sync outlook contacts, emails, tasks etc with my php mysql web application? Thanks |
| | hi there, need some urgeny help. is there a way to from my web application php/mysql create an email which will go to outlook and send via outlook? so user uses the web application to input customer details. create message with attachments from the server and then presses a button … |
| | hi, i was wondering is someone could give me an example of how i could do this in sql query. basically the application has a product table and when they are inserting they have the option to select monthly payments. put in the start date so say 30/3/2013 what i …  |
| | Re: letter merge thanks for this, what if i wanted to bulk create the letters? this is good for one letter at a time. but say i wanted to generate 100 in one go and print off? thanks |
| | hi, i am using autcomplete to call my php page which displays results. all is working except when they click off the list it does not hide the search results again. so searching works and so does selecting from the results but if they did not want to select a …  |
| | hi, i am adding in a basic accounts table to my system. what i need to know is what is the best way to insert repeat payments. such as rent monthly? many thanks |
| | hi, i have looked on net all over and cannot find an occupations table. basically for my application i need a table of occupations so if anyone has this in sql or excel please can you post up here? many thanks |
| | hi, i have been struggling to find a good autocomplete script with mysql backend. i now have an easy to use one and all is working, however in my page after the search has been typed and user selected instead of the users name appearing in the search box i … |
| | hi, ok so i hae googled and looked on many sites. basically i created my database application using dreamweaver. i now want to convert it over to an android app. i have came across tools that can convert html to this. however is there any tools to convert my php … |
| | hi, i am looking at using a html5 script that helps draw on a canvas, how can i then save this to my database in a blob to then be shown again on the page at a later date? the code is: function RoSave(frm) { var strImageData = canvas.toDataURL(); $.ajax({ … |
| | hi how can i have it setup where a user can only send 2 gifts a day on my website? many thanks |
| | hi guys, i need a mail script that will launch after the insert record on my page. problem is at the moment it works fine if ony one address is entered. however i have 3 queries on my page that is needs to get the email addresses from. so i … |
| | hi guys, not sure where to start so thought i would see if any you guys have any knowledge on recording calls into a backend website running on php/mysql? site is running a sales order system and working fine however they want to record calls into the database so guess … |
| | hi, my application i have built which runs on php/mysql i now need a way to have it insert a value into a table every set date. so, on the isnert form just now they would enter the amount of money the company would receive and which date they were … |
| | hi, been trawling the web trying to find anything on this but cant find anything to hand. my query:[CODE]SELECT monthlycommission.DatePaid, monthlycommission.MonthPaid, monthlycommission.YearPaid -1 year FROM monthlycommission where YearPaid = now() group by MonthPaid order by DatePaid ASC[/CODE] basically this query works however it is not what i want it to … |
| | hi i have a query which should work however it returns nothing. i have at least 2 entries where completed = No and the date of the task is today. the code is: [CODE]SELECT count(TaskID) AS DueToday, DATE_FORMAT(`TaskDueDate`,'%d.%m.%Y') AS XLABEL FROM tasks WHERE 'XLABEL' = CURDATE( ) AND Completed = … |
| | hi, i was wondering if any you guys knew of a simple way to sync from an access database offline to a mysql online database? currently my system is running on php/mysql. there is another company who have a system that uses an access database behind it. i can access …  |
| | hi, i was wondering if any you guys knew of a simple way to sync from an access database offline to a mysql online database? currently my system is running on php/mysql. there is another company who have a system that uses an access database behind it. i can access … |
| | hi, i have a text area on a form which a user will enter a letter into it. on the page i have a recordset which holds all the clients names and addresses from the table. i want the user to be able to key in <<FirstName>> or <<Address>> into …  |
| | hi, what is the best password encryption to use on a website with mysql backend? i have used md5 and sha1 in the past however which is best? crypt? â—¦RJINDAEL ? what is best to use? they wont be recovering the password only sent a new password if forgotten. so …  |
| | hi, i am looking at a way of integrating an email system where users can check their own email from within the system and email from it. basicaly within the cms they should have the ability to login to their pop3 email if possible. only problem is that the cms … |
| | hi, is it possible for me to embed part of my site into another? i want to give someone a piece of php code maybe a page of code which will embed my whole intranet site into theirs so it looks like they are still on the other persons site … |
| | hi, i have designed an application for a company in php/mysql. they want an app version of it, just a cut down version of the app. simple question, what is the easiest way to convert php/mysql to an app for ipad or iphone etc? is there a compiler out there … |
| | hi, i have asked something similar to this before. basically i have looked around and i can see that it seems it is possible to send email from a different email account using php. but what is the best way to stop the server being blacklisted? it want be used … |
| | hi guys, i have a site which is built using php/mysql with some jquery etc in it. is there an easy way to create an offline installation package of this which syncs to the online version? what is the easiest way to do this? thanks again for the help |
| | hi guys, i have a script [CODE]<script>KT_self_url = "pageToRedirect.php";</script> [/CODE] basically it is a script that runs after a flash multi upload. problem is that the script does not refresh the page. so if i set for example [CODE]script>KT_self_url = "members_Detail.php?MemberID=<?php echo($row_WADAmembers['MemberID']); ?>#tabs-11";</script>[/CODE] it hangs with the flash upload on … |
| | hi guys, i have a script [CODE]<script>KT_self_url = "pageToRedirect.php";</script> [/CODE] basically it is a script that runs after a flash multi upload. problem is that the script does not refresh the page. so if i set for example [CODE]script>KT_self_url = "members_Detail.php?MemberID=<?php echo($row_WADAmembers['MemberID']); ?>#tabs-11";</script>[/CODE] it hangs with the flash upload on … |
| | hi guys, i have a folder which stores uploaded documents and images. the site is password protected using php with mysql database behind it. problem is the pages are secure which is great but the directory in which the documents and images sit is not protected. i was looking at … |
| | hi, looking for some tips, using dreamweaver as my tool and wondering if someone could help. i basically have 2 tables. 1 which is partsused and the other stocklevels. the stocklevels contains stock details and also if it is in the van or unit. on my page i have an … |
| | hi, i have in a table"visitdate1, visitdate2, visitdate3 and visitdate4" i also have in this table address fields of "housenumber, street, city, zip" i want to run a query which shows me the amount of visits to a house. should these be stored in different tables? thanks |
| | hi, i have a table setup where the user selects multiple check boxes from a form and it inserts into the table. this works fine and when i do a report i can do something like this: [CODE]SELECT COUNT(*) as MembersCount, MemberCounty FROM membersDetails WHERE MemOpportWith LIKE '%msg%' GROUP BY … |
| | hi guys, i am working on a project and i am slightly unsure how to structure this in the database. basically it is a job card sheet that could have multiple part numbers selected and suppliers along with quantity. so basically i thought how can i store this in the … |
| | hi guys, quick question. i have 2 tables. Client Table: ClientID INT PK AI, ClientName VarChar Folders table: FolderID INT PK AI, FolderName VarChar, client_ClientID INT The issue i have is that i have created this virtual folder appliaction in the site and have created it now where when they … |
| | hi guys, i am looking at purchasing this ssl for my cpanel dedicated box: [url]http://www.positivessl.com/ssl-certificate-products/addsupport/ssl-positive_wildcard.html?ap=ce048[/url] i have asked the salesman if 1 static ip address for the box will cover all sub domains on the one domain ssl and he has confirmed yes however my hosting provider support engineers said … |
| | hi, i have a client request which i am unsure how to achieve. i need to be able to search the mysql database for the closest post code to a person who enters in their post code. so for example a user types in post code nn1 1ne and the … |
| | hi, i am currently going to be setting up a linux dedicated box and have a few questions if somenone could give me some input into it. not too in depth so lamens terms would be best. 1. can someone recommend a good hosting company for a dedicated box? 2. … |
| | hi, i have a site which i want to generate a weekly report of activity from. the monthly report should be fine as i could set the query to format the date into month and where "date" is NOW() however how can i generate a weekly report in mysql? any … |
| | hi, i have found a few ways on the internet to import an excel sheet into mysql. one of which is save to a csv and upload to a site which creates the sql statements and this is great and i have used in past. however my problem is i … |
| | Hi, I have tried to Google this but cant find anything. I want to use a select AS statement to select multiple columns. i.e. [CODE]Select unitno country price AS propertyref[/CODE] is this possible using multiple columns AS one reference? many thanks |
| | Hi, I have been trying to execute a query and for some reason it returns 0 when there should be 1 in the result. [CODE] SELECT count(TaskID) AS DueToday FROM tasks WHERE TaskDueDate = CURRENT_DATE AND Completed = 'No'[/CODE] I have tried NOW() and various others reference [url]http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_current-date[/url] however it …  |
| | hi, i need to do a query which joins multiple tables but i need to join the same 2 tables multiple times. is that possible? [CODE]SELECT timeline.TimelineID, timeline.SIPPorCASH, timeline.clients_ClientID, timeline.UserID, timeline.IFAID, timeline.RegionalSalesManager, timeline.AreaSalesManager, timeline.AgencyTradingAgreementSigned, timeline.DateOfClientMeeting, timeline.EstimatedPensionFundAmount, timeline.DateAuthorityMandateSentToIFA, timeline.DetailsOfPensionFunds, timeline.ProductID, timeline.PropertyRef, timeline.NPW, timeline.CaseComplete, clients.ClientID, clients.App1FirstName, clients.App1LastName, clients.App2FirstName, clients.App2LastName, users.UserID, users.FullName FROM … |
The End.