- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
59 Posted Topics
 | 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 … |
| | if this is a web app, i would personally store the pdf in a seperate folder and only the document name in the database. i am sure this would be the way without it being web based also. is it web based? |
| | 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. … |
| | Hi , i have used some gui tools to generate my php code from database and i need some help with the search form. basically the tools only created the search of dates in US format so someone had to write a cusotm function for it to display as UK … |
| | Hi, got some help from tesu on another thread but i am struggling to get this working. my individual query returns 2 results which is correct from the database. however when i try it with a view joining the multiple table with same query it returns 2 results but only … |
| | Hi, I am setting up a notes table, and wondered what the best type would be? Currently i have set it to Varchar with length 500 Would that take up more space than say a Lontext type in the database? Thanks |
| | Hi, I got some great help on the forum to create my total due query. However it produces it with just total due, how could i have it by month? each table has a DueDate column which i would like to show on the query along with the users FullName … |
| | Hi guys, Need some help here. I have created an individual query for each product which works absolutely fine. However i want to be able to join it so i can display on my page who is due for a review. [CODE]SELECT clients.*, protection.* FROM (clients JOIN protection ON protection.clients_ClientID=clients.ClientID) … |
| | Hi, This is a real simple answer but for the life of me i cant seem to work out. I am trying to display my notes on one side of the page however the notes are long and are running right across the page instead of automatically going into a … |
| | Hi, I was looking for a quick answer on this as i have been wondering what is the advantage of using javascript files in an includes folder rather than on page? So for example i have a javascript validation on my page, does it make a difference to the way … |
| | Hi, this is probably a simple one for someone, but i have on my page a button rather than a text link. when they click cancel i want it to back to my details page but pass the parameter id back. so currently it is like this [CODE] <input type="button" … |
| | Hi, I was wondering if someone could help me, i have nearly complete my site and need some help creating the queries to produce my commission and pipeline. my table structure is: [CODE]CREATE TABLE `pipeline_commission` ( `ProductID` varchar(75) NOT NULL, `Pip_CommID` int(11) NOT NULL auto_increment, `PipComm_UserID` int(11) default NULL, `clients_ClientID` … |
| | Hi, I have tested this and get no errors. However when i am updating a mortgage record for a client it changes the client id?? So if i am updating a mortgage for clientid = 1 Test Case and Mortgage ID = 1 once i click update in my php … |
| | Hi, I have used Dreamweaver to create my php/mysql data driven site. I have managed to secure the site with it and generate my pages. problem is users should only see their own clients which works on the results page, however if say UserID 1 had a client registered to …  |
| | Hi, I am trying to insert into 2 tables at once. The first table i have a hidden field InsuranceID and that gets an auto increment from mysql database. In my other hidden fields i am inserting into table 2 which has a hidden value of ProductID This is set …  |
| | Hi, I was wondering if some of you guys could give me some advice. I have a normally setup websites for clients on a reseller account from a hosting company. However I was looking at setting up my own PHP/MYSQL server in a new office. We are looking at business … |
| | Hi, I currently am calculating the age based on Date of Birth from the database. However I am told that I cannot search an AS on my recordset query from mysql database with PHP. Is this true and if so how can i search the age calculated from their Date …  |
| | Hi, I have been using some tools to generate my php code as i have little knowledge of php. the tools are ok but the support is rubbish. everything is generated in US date and time format and i need it to be in UK. anyway to cut a long … |
| | Hi, I was looking for some help with how i would go about setting up my commission table. Basically i have currently: Users Table UserID Username Password Email Clients Table: ClientId Client_UserID FirstName LastName Address PostCode Tel Email Insurance Table: InsuranceID Clients_ClientID Provider Commission DatePaid CarInsurance Table: CarInsuranceID Clients_ClientID Provider … |
| | hi, fairly new to mysql. i have been working on a site which would have say 100 + agents. basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company. the database … |
| | Hi, Fairly new to MYSQL, still learning. I have create basic web databases before but the project i am working on just now is slightly more complex than before and need some advice. i have had some help qith queries which has been great however i need some advice from … |
| | hi, i have been trying to write a query which will return all clients and the related tables so that i can then allow the users to filter in a php website. at moment i tried this but returned no results even though there are records: [CODE]SELECT * FROM clients …  |
| | hi, could anyone recommend a free mysql query builder? i have been working on a database and had some help with some small queries, however i need to create a large recordset through dreamweaver and wondered what tool i could use to generate my query visually? many thanks |
The End.