andydeans

hi there, i have a vps which has crashed and now have a new build of mysql and server. the old drive is mounted and i can access all the web files from the old drive an have download the mysql raw files from the var/lib folder. i uploaded to …

hi, i have a site where the user can copy and paste a letter they typed on their pc into an HTML editor in the site and when inserted goes into the database. what i need to be able to do is have a button when inserting or a specific …

hi, i have just applied a view to my database and when tested works fine if their is a value from the tasks and allrenewals tables of "clientID" or clients_ClientID however i need to be able to view the entries even if the clientid or clients_clientid from the 2 tables …

hi, this is probably easy so hope someone can help asap. i have an existing bit of code here: [CODE] <img src="images/<?php echo (($row_rsTimelineActive['ReservationFormSentToPP']==0)?'no.gif':'yes.gif'); ?>" > [/CODE] instead of it being ==0 i want to be able to display no.gif if ReservationFormSentToPP is null and yes.gif if not null. hope …

hi, never done this before and wondered if anyone could point me to a fairly simple step by step guide on how to add an rss feed from a site into our own web site? many thanks

hi, this is probably a simple solution but nothing is coming up in searches except date and time pickers. i basically have a datetime column in mysql database. i have an input field for my date part and i want to create a second input field in my form to …

hi, i am struggling and it will prob be a simple answer but cannot figure it out at all today. checked online but no use. my to create my view i need to compare a column to a yes or no. at the moment i have tried this but no …

hi, this is following on from a previous thread. i have looked around and openssl documentation is a bit unclear. can it secure all sub domains? i would like to use openssl to secure all sub domains and easily add them/manage via cpanel? can anyone help guid me on this? …

hi, i have a view in the database which queries about 6 tables to produce the results and works great. however i need to create a view based on the info from this view along with data from another table. when creating the view that queries the view and table …

hi, are there any issues of using a php script that sends via a dedicated linux box to an address from an email address different from the domain on this box? so for example domain is: mydomain.com on dedicated box, someone comes to the site and sends an email to …

hi, i want to add an end time in my query using my time to call column. at the moment i have a time to call which will be the start time however i want to add timetocall as endtime which is 15 mins after the timetocall column. i am …

hi i need some help with a project i am working on. i basically have a back end site php/mysql with clients addresses etc, i need to be able to send that data to another site where they have login and passord for and it pre populate the forms in …

hi guys, need some urgent help from you. i need 2 things to work out, looked around on net and found some scripts but wondered if someone could help point me to a good way of doing this. i need to be able to mail merge to word/wordpad whatever the …

hi, i have installed xammp on my win 7 pc, i have a static ip address and wondered if i could use this to host my website? is there any disadvatanges of using a win 7 pc rather than linux server to host it? should i use windows server to …

hi i found this thread: [url]http://www.daniweb.com/forums/thread197057.html[/url] will this script backup all databases in the mysql directory? what do you need to backup and restore all mysql databases in xampp? do i just copy and paste the directory to another location everyday or is there a particular way? i know you …

hi, i have read around and all i seem to find is one and in the where clause along with an OR or either but i was wondering if it was fine to use 2 or maybe 3 AND in the where clause? most of my where clauses in past …

hi, i need some advice, looking for someone to point me to somewhere which would be a cheap/free sms text gateway to integrate with my existing mysql/php site. need to be able to record texts that are sent to clients. do we need an sms gateway provider? many thanks

hi, need some major help with this. i have a site which has nots page etc and is great for recording data like this however i need to record calls and integrate into the site. no idea where to start with this one, has anyone got some suggestions on this? …

hi, i have never used a dedicated linux server, however i am going to be switching one of our sites from shared hosting to a dedicated server due to traffic etc. the host is giving cpanel which i just wanted to check with you guys if this is fine to …

hi, this is prob really simple but what is the best way for me to add time to call on a form? i have created a column in my tesk table called timetocall with type = TIME what is best way to allow the user to key on the time? …

hi, i have been trying to work out how to list all the users on the database for my website with a particular access level and also only the user id that the client is associated to however i end up with duplicated users. here is my query so far …

hi, i get this error on one of my pages, however if i move the session start code to check if user is logged in down a few lines below some query code for searching the site it works fine. why would moving the session start down a bit on …

hi, i have applied sha1 encryption to my update password page for users and it is encypting into the database fine. however i have a script that should at login check the encrypted sha1 password in the database and login however it does not work. i am not great with …

how to insert and retrieve a 20mb pdf file from mysql database?

Hi, Is there any scripts that would logout a user if they were already logged in with that username and password? many thanks

hi, i have a site which is secure with a username and password combination with mysql backend database. the encryption is sha1 for the password. what about securing the url? at the moment it displays for example: page_name.php?ID=24 if you modify the ID other users can see other pages they …

hi, i have been working on creating a view in my database: [CODE] CREATE OR REPLACE VIEW productnotgot( ProductID, Product, ClientID, ClientFirstName, ClientLastName, Email1, Tel1, Email2, Tel2, ProductSold) AS SELECT Product2ID, 'Product2', c.ClientID, c.App1FirstName, c.App1LastName, c.App1Email, c.App1Phone, c.App2Email, c.App2Phone, p.clients_ClientID FROM clients c JOIN Product2 p on c.ClientID = p.clients_ClientID …

hi, i have a database that i have done for a client, which has about 5 CREATE VIEWS in the mysql database, i need to backup the database and then import it into a new database for another client who wants the same thing. problem i have is i can …

Hi, been looking all night on net but cannot find ORDER BY Month anywhere. This is my query: [CODE]SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE FROM monthlycommission WHERE YearPaid= NOW( ) GROUP BY MonthPaid[/CODE] However when i display this it goes June, March then May I want to add an …

Hi, New to PHP, wondered if anyone could point me to a script that would do the following: get email address from a website. Basically there is a site that is open for public viewing with addresses and phone numbers and email addresses that my client would like to target. …