kadriirdak

Hi, I have a range of *start* and *end* dates return from database in while loop i need to find, how many of them are continuing. The example return data; Array ( [start_date] => 2014-09-22 [end_date] => 2014-09-28 ) Array ( [start_date] => 2014-09-15 [end_date] => 2014-09-21 ) Array ( …

Hi I have a query and I like to see the result until the condition match. I am trying to find if the end date(+1day) is equal to next row start date if so list it. I have the below query does the job but it also list whole table …

Hi There, I have an XML data [code] <coordinators branch="xx"><coordinator cnum="xx"> <value key="role" type="string">BC</value> <value key="role_desc" type="string">role</value> <value key="name" type="string">xx</value> <value key="tel_number" type="string"/> <value key="email_address" type="string">xx</value> </coordinator> <coordinator cnum="xx"> <value key="role" type="string">BC</value> <value key="role_desc" type="string">role</value> <value key="name" type="string">xx</value> <value key="tel_number" type="string"/> <value key="email_address" type="string">xx</value> </coordinator> </coordinators> [/code] I need to …

Hi There, I have an XML file and I list them by check boxes, categorized by their parent (branch). After selection of the check box, I take them and give the values `$branch`(only one at a time) and `$roles`(can be many eg. SBP|BNA) to web services. And run this web …

Hi There, I have a usage problem with CURL output. I have a web services and I use CURL to get the data, However this web services set up as XML output and I want to convert it to array to use the result in the web form. My CURL …

Hi Guys, Can anybody spot the error on this code? it gives me error: SQL Server Database Error: Incorrect syntax near the keyword 'inner'. 5 0 [CODE]Select e.event_number,e.start_date ,event_desc, venue_desc,s.location from events e inner join venues v on v.venue=e.venue inner join sessions s on s.event_number=e.event_number and session_type='0' (inner join contact_categories …

Hi There, I create an SQL statement to retrieve some data from DB. However I can not do the third if statement! my code; [CODE] $search = care_query(" SELECT contact_number, role, is_active FROM contact_roles WHERE contact_number='$mn' AND is_active='Y' AND role like 'S%'; "); while($row = care_fetch_array($search)) { $role= $row['role'];echo "<pre>"; …

Hi There, I am using a sql query to show a row to users. The Problem is in the database there are single as well as duplicate records. My 1st code is – Works good if user has no duplicate records; [CODE] SELECT contacts.forenames, contacts.surname, addresses.postcode, contacts.contact_number FROM contacts LEFT …

Hi There, I do have 2 tables; Contacts table, Communications table Contacts table rows are; contact_number, forename, surname Communications table rows are; contact_number, number (number is used for emails) What I have is a little form to check/find out the contact number by filling; surname forename and email. Once they …

Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked …

Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. …

Hi there, I do have a database and I am using sql command to insert data in it. Date field is set to datetime (03/01/1900 00:00:00) In the field either there is a date only or it is empty. What I want to do is: Insert current+2yrs date even the …

Hi There, For some reason I need my form to be submitted twice (in one go). Is there any way to do that instead of submitting once go back and submit again? My form based on PHP and Javascript... Thanks!

Hi There, I do have an array; [CODE] $result = array( 'Database' => $database, 'UserID' => $contactAmendedBy, 'OldContactNumber'=> $_SESSION["CONTACTNUMBER"], 'OldActivity'=> $OldActivity, 'OldActivityValue'=> "ANT", 'OldSource'=> $OldSource, 'OldValidFrom'=> "25/08/2010", [*]'OldValidTo'=> "26/08/2110", 'Source'=> $Source, 'ValidTo'=> $ValidTo )); [/CODE] What I want to do is to give move values to dates. like; [CODE] 'OldValidFrom'=> …