[PHP] Function Not Working...Little help

(user_list.php, user_list.php); There are parts of the code I was trying to debug. Any help would be appreciated. Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit your business needs. Need assistance

[PHP] Suppress Right-Click and Hide hover URL

want to REMOVE the assoication of this Area with this Inlet?')\\Remove/a Please let me know if this can be tweaked to work... Thanks! Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit

[PHP] Build Categories based on an static Array

(No Area found.); while($row2 = $results2-fetch_assoc()) { $AreasList .= option value='{$row2['Area_id']}'{$row2['Area']}/option; } $AreasList .= /optgroup; } $AreasList .= /select; Don Wieland D W D a t

[PHP] File To Blob Corruption

(file_get_contents($_FILES['img'] ['tmp_name'])); $db-query(UPDATE Areas SET Image = '$file') or die(1.$db-error); Has anyone else ever run into this type of UPDATE error with images and PDF? We really need to get this dealt with ASAP. Thanks! Don Wieland D W D a t a C o n c e p t s

[PHP] Query based on Server offset TimeStamp

ServerOffsetTimeStap = Row_Start_TimeStamp AND ServerOffsetTimeStap = Row_End_TimeStamp How would I do this? Appreciate any help you can offer. Thanks! Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data

[PHP] Create Days for a specified YEAR...

a ERROR. If they are not existing, create ONE RECORD for each day in that year. If you can, please include the mySQL procedure code and the PHP that would call it. Appreciate any help that be offered. Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com

[PHP] Weird Array Issue...

(CALL Get_OHC_Years()) or die(Records not found.); $yRow = $years-fetch_array(); echo pre; print_r($yRow); echo /pre; But the result it returns on my page is: Array ( [0] = 2007 [ohc_year] = 2007 What am I missing? Thanks! Don Wieland D W D a t a C o n c e p t s

[PHP] PHP / mySQL Project...

, AJAX, and JQuery. Developer may work remotely. Please contact me via email, PRIVATELY, with your skills and sample of online project you have done. Also, this will be an hourly job - so what Hourly Rate you expect to get paid would be nice. Thanks! Don Wieland D W D a t a C o n c e p

[PHP] Stored Proc - Date not inserting into the Record

. Frustrating. My code looks right and I echoed the value on the page and it is formatted properly. The field in mySQL is formatted as a DATE type. Little help please :-) Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771

[PHP] PHP and schedules tasks/events

this... Thanks! Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit your business needs. Need assistance in dialing in your FileMaker solution? Check out our Developer Support Plan at: http

Re: [PHP] PHP and schedules tasks/events

at 4/9/2010 @ 10:45am 1 month(s) = email sent at 3/16/2010 @ 10:45am 1 year(s) = email sent at 4/16/2009 @ 10:45am This is really what I need... Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 -- PHP General Mailing List

[PHP] CSS - Image or object Slide left/right and fade in using jquery

Does anyone have any resources that demonstrates using jquery to have an image or object slide in from the left and then fade in. I would appreciate it. Thanks! Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771

[PHP] PHP - Header ERROR

'].comment=.$_POST['comment']); exit(); } Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit your business needs. Need assistance in dialing in your FileMaker solution? Check out our Developer

Re: [PHP] PHP - Header ERROR

On Jun 13, 2010, at 7:53 AM, Ashley Sheridan wrote: On Sun, 2010-06-13 at 07:50 -0700, Don Wieland wrote: Yeah - I thought about that, but I don't know how to do this. I have a partner who admins my virtual private server. Oh well ;-) It is probably something I need to do to the header

[PHP] NULL Date Entries...

','applicant_dob_3'), 'req'=0, 's'='/'), This enters in the DB fine when there is a DATE, but when these fields are left empty, it inserts into the the DB as 2069-12-31. How does one deal with this? Don Wieland -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP] Date Test...

['f']):$_POST[$ffield['f']]; $query_values[] = '.mysql_real_escape_string($ffield['s']=='/' !empty($fval) ?date('y-m-d',strtotime($fval)):$fval).'; } Will anyone point out the problem with this CODE? Don Wieland -- PHP General Mailing List (http://www.php.net

Re: [PHP] Date Test...

On Jul 8, 2010, at 10:09 AM, Ashley Sheridan wrote: thanks Ash, I figure it out. I was not entering the full year. date('y-m-d',strtotime($fval)) needed to be date('o-m-d',strtotime($fval)) Duh ;-) Thanks, Don On Wed, 2010-07-07 at 13:28 -0700, Don Wieland wrote: Hello all, I am

[PHP] Trapping for PDF Type and file size in a UPLOAD form...

selects a PDF file greater than 1MB, display an javascript alert File uploads may not exceed 1M in file size. Please try again. I appreciate any help that can be offered. Thanks in advanced! Don Wieland -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP] PHP upload hangs on Safari

should be looking at to remedy this hanging? Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit your business needs. Need assistance in dialing in your FileMaker solution? Check out our

[PHP] Little Parsing help...

sure that EXACT Case is only changed. For example, there might be a chord like Asus add 9 where I would not want the a of add9 to change. Any suggestions would be appreciated. Don Wieland -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Little Parsing help...

The logic I need is pretty straight forward, but I am having a hard time replicating it using PHP functions. I will try to break it down to it's simplest form: I have a field that has several lines of text. Chords and Song Lyrics. The Chord lines begin with an asterisk * and end with the

[PHP] Firs Day Of Week UNIX

of the week. So if my preference is Monday and Today's date is 10/19/2010, I want to return a value of: 1287374400 (which is 10/18/2010) if my preference is Wednesday and Today's date is 10/19/2010, I want to return a value of: 1286942400 (which is 10/13/2010) Appreciate any help. Don

[PHP] Firs Day Of Week UNIX

Hi gang, I need a bailout. I have a fields called sys_first_day_of_week and the user can select one value which will be from a menu with these options: Monday Tuesday Wednesday Thursday Friday Saturday Sunday Based on this Preference and TODAYS DATE, I want to calculate the first day of

[PHP] Fiscal Years and Quarters

Hello, I have a preference field called Fiscal_Year_Start_Month which has the Month Names as options. Based on this value, I need to calculate the following date in UNIX: Current_1st_Quarter_Start_Date Current_1st_Quarter_End_Date Current_2nd_Quarter_Start_Date Current_2nd_Quarter_End_Date

[PHP] Weird Behavior

) $qCur = 1; if($CD = $q2s $CD = $q2e) $qCur = 2; if($CD = $q3s $CD = $q3e) $qCur = 3; if($CD = $q4s $CD = $q4e) $qCur = 4; it returns 4 Don Wieland -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Reply to an EMAIL get posted in a mySQL TABLE

Hi gang, I use a Project Management System (PM) that generates emails to my account. I can REPLY to that email and it will be inserted into the PM. I believe the ID is in the subject. I assume the email is sent to a specified email and there is a CRON JOB that runs a PHP script to query

[PHP] PHP importing CVS data with field mapping

Hi gang, I have a need to to allow users to import into my web app via PHP. Is there any functions or javascripts out there will allow user to pick a cvs file, bring up a file mapping UI, then process data based on mapping and insert into mySQL DB. Any help or resources would be

[PHP] Open Source PHP/ mySQL Project Management

Hi gang, I am looking into Project Management apps for my projects. Any suggestions: I am interested in tracking Projects, Milestones, Tickets, Files, Discussions, Documents, Time Tracking, etc... Also, would like to have the system have robust email integration Reminders, Email Ticket

[PHP] Securing Use of PHP site

with SESSION VARS. I am doing some experimenting. Any words of wisdom or resources would be helpful. Thanks! Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 336-4828 Integrated data solutions to fit your business needs. Need assistance

[PHP] Strange Query Error...

Hi gang, I am executing a query via PHP that gives me a PHP error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.`Preferred_First_Name` LIKE 'Don' AND m.`Preferred_Last_Name` LIKE 'Wielan' at

Re: [PHP] Strange Query Error...

On Nov 27, 2010, at 10:07 AM, Bastien wrote: Try removing the backticks around the table names. If you do use them, then all values (field names and table names) need it. I tried that and still chokes... select m.* from Members m inner join Member_Years my on m.aucciim_id = my.member_id

Re: [PHP] Strange Query Error...

On Nov 27, 2010, at 10:08 AM, Daniel P. Brown wrote: one primary question: are you using the mysql_* family, mysqli_* family, or another method of interfacing with MySQL? mysql_ $results = mysql_query($query) or die(mysql_error()); Don -- PHP General Mailing List (http://www.php.net/) To

Re: [PHP] Strange Query Error...

On Nov 27, 2010, at 10:44 AM, Daniel P. Brown wrote: Note how you keep changing case here. For example, m.aucciim_id vs. m.AUCCIIM_ID. Also note that all of this is cAsE-sEnSiTiVe. You are right. But it still chokes in PHP: select m.* from Members m inner join Member_Years my on

Re: [PHP] Strange Query Error...

On Nov 27, 2010, at 10:39 AM, Tommy Pham wrote: Don, Have you tried to run the query in either MySQL workbench or the command line to ensure that query is SQL syntax error free? From the error message, it sounds more like a SQL syntax error. If you're able to run the query fine in the

Re: [PHP] Strange Query Error...

On Nov 27, 2010, at 11:35 AM, Daniel P. Brown wrote: Strange... I have no idea what to do. I got to run it via PHP. Don, on which table is the column `member_year` located? Is that on `Members`? it is Member_Years. I thought of that. I change the query: select m.* from Members m

Re: [PHP] Strange Query Error...

On Nov 27, 2010, at 12:09 PM, Daniel P. Brown wrote: At this point, can you just send the whole related snippet? The cases keep changing and there's a lot of other suggestions that you said you've tried. Just doing that on my local machine works without error, so it's likely the result of

[PHP] mySQL query assistance...

Hi all, Is there a list/form to get some help on compiling mySQL queries? I am executing them via PHP, but do not want to ask for help here if it is no the appropriate forum. Thanks ;-) Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] Little Assistance...

Hi all, I am needing to find someone with extensive mySQL chops to assist me in building a few mySQL queries to run from PHP. Compensation, of course... Probably an hour or so of effort for qualified. Please contact me PRIVATELY if interested. Don -- PHP General Mailing List

[PHP] Where is my array?

Hello, I originally had a line that built a static array: $instruments = array('Leader','Singer','Piano','Synth','A-Guitar','E- Guitar','Bass','Drums','Perc','Sax','Flute','Sound/ AV','Pastor','Producer'); Then I decided I wanted this dynamic and to pull it form the DB. So I thought this

[PHP] MP3 Player and PHP

Hello, Can someone recommend a web MP3 player? I need the following options: 1) Location and Duration of mp3 display (seconds) 2) The ability to pass a start and end parameter and play a part of the song 3) Loop parameter 4) Call to the player to grab the mp3 Location and set it to a field

[PHP] Convert Hours to Decimal

Hey Tim, I got a select string: select timediff(cast(out_1 as time), cast(in_1 as time)) tHours FROM lm_tc_trans WHERE tc_trans_id = '42' result = 08:45:00 How do i convert that to a FLOAT (5,2) = 8.75 or result = 08:15:00 How do i convert that to a FLOAT (5,2) = 8.25 Don Wieland

[PHP] Partner needed...

the services the site will provide to the public, but would require a NDA to be signed first. If you have interest in a potential back-end revenue stream in exchange for you time in coding, please contact me PRIVATELY. Thanks! Don Wieland D W D a t a C o n c e p t s -- PHP General Mailing List

[PHP] Little Info...

This is a bit related to PHP but mostly mySQL (is there a similar list for this stuff? Let me know please) In my mySQL query editor, I am trying to return a value of 0 when there is no related rows from this query: (select if(count(ip.payment_amount) IS NOT NULL, count(ip.payment_amount)

[PHP] passing /n into query ERROR

I have a query below. When I try to run it with PHP it errors: DATABASE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LINES TERMINATED BY '\n'' at line 38 IN BUT where I copy the echoed query

[PHP] Simple Email System (SES) Provider

Hi all, I built a system in PHP/mySQL where a group of users post events, sign- up for events, change their arrival times, remove thier names from events, and post related notes on the events. Each time an action is done, an email is generated to the entire group that their has been a

[PHP] PHP/mySQL Developer Partner needed...

Greetings, I have a site that I am developing and I am looking to partner/ developer with great php/mySQL skills (for share of potential profits) to assist me in finishing this site. I am looking for someone who can invest (like myself) their time and skills to complete the site in