[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 exchang

[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 chan

[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 and

[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] Partner needed...

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] 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 D

[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] 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 w

[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 (http://ww

[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: http://www.php.net/unsub.ph

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 anot

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 inn

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 w

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 m.AUCCII

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 un

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 wh

[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 lin

[PHP] Securing Use of PHP site

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] 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 ec

[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 appreciat

[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 a

[PHP] Weird Behavior

= $q1s && $CD <= $q1e) $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] 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] 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

[PHP] Firs Day Of Week UNIX

942400 (which is 10/13/2010) Appreciate any help. 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 in dialing in your FileMaker solution

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] Little Parsing help...

1/2 step, it would look like this: *B C#m7D#m This is the first line of my song * B/D# D#m7C#m7 and I know it can get real long * F#m7 G#m7 If you know I will say * F#/A#B That it will help

[PHP] PHP upload hangs on Safari

else that I 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? Che

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

file that IS NOT a PDF file, display an javascript alert "You can only upload PDF files. Please try again." If the user 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 th

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

[PHP] Date Test...

ay($ffield['f'])?joinFields($ffield['s'], $ffield['f']):$_POST[$ffield['f']]; $query_values[] = "'".mysql_real_escape_string($ffield['s']=='/' && !empty($fval) ?date('y-m-d',strtotime($fval)):$fval)."

[PHP] NULL Date Entries...

y('applicant_dob_1','applicant_dob_2','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

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 h

[PHP] PHP - Header ERROR

SECURITY CODE correctly. It is case sensitive.&name=".$_POST['name']."&email=". $_POST['email']."&comment=".$_POST['comment']); exit(); } Don Wieland D W D a t a C o n c e p t s ~ d...@dwd

[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

Re: [PHP] PHP and schedules tasks/events

sent 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

[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

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

$num++; } } } The records are inserting into the table BUT the field "och_Dates" is not getting the proper value. It gets "-00-00". Frustrating. My code looks right and I echoed the value on the page and it is formatted properly. The field in mySQL i

[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] Weird Array Issue...

$db->query("CALL Get_OHC_Years()") or die("Records not found."); $yRow = $years->fetch_array(); echo ""; print_r($yRow); echo ""; But the result it returns on my page is: Array ( [0] => 2007 [ohc_year] => 2007 What am I m

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

- if so generate 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..

[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 Inte

[PHP] File To Blob Corruption

ry("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] Build Categories based on an static Array

query($query2) or die("No Area found."); while($row2 = $results2->fetch_assoc()) { $AreasList .= "value='{$row2['Area_id']}'>{$row2['Area']}"; } $AreasList .= "";

[PHP] Suppress Right-Click and Hide hover URL

ication of this Area with this Inlet?')\"\">Remove 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 your bus

[PHP] Function Not Working...Little help

quot;No Access"; //header("location: {$ErrorPage}?message=Unable to update user information."); exit(); } } Validate_Page_Nav("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