Re: [PHP] Streaming video BLOBs from MySQL

2005-04-16 Thread J J
owser is simply going to load that 1mb only, right? How do I keep looping and refreshing the users browser, or in this case, flash player? Thanks for any ideas! --- Marek Kilimajer <[EMAIL PROTECTED]> wrote: > J J wrote: > > I have a case where video files (mov, flv, etc) > ha

[PHP] Streaming video BLOBs from MySQL

2005-04-14 Thread J J
I have a case where video files (mov, flv, etc) have been stored in a MySQL database as blobs. I'm loading them into a flash video player and everything works fine except it takes longer it seems and it doesn't allow streaming the actual video. If I load the same videos with a direct link to the

[PHP] Finding records within 15 minutes from now?

2005-04-12 Thread J J
I'm struggling with the php or mysql query to find records within my database that are within 15 minutes from now and prior. Example: It's 2:30pm on 4/12/05 I need to find all records with a RecordTime of 2:45pm and previous. So it should find: rec1 time: 2:45 date: 4/12/05 rec2 time: 2:00 date:

Re: [PHP] Unique ID system - need help/ideas

2004-03-10 Thread J J
Wow I think you are on to something!!! I'll give it a whirl! Thanks! --- [EMAIL PROTECTED] wrote: > On 10 Mar 2004 J J wrote: > > > My problem is how do I recreate this in PHP to > make > > sure any newly added records follow this same > unique > > ID? &g

RE: [PHP] Unique ID system - need help/ideas

2004-03-10 Thread J J
Yeah thanks for the feedback, I'm already including a primary key auto_increment field in place to tie the tables together with an ID I *know* will be unique. This other ID scheme is just to work within their existing system that uses this. I'm just trying to mirror/maintain that scheme for their

RE: [PHP] Unique ID system - need help/ideas

2004-03-10 Thread J J
Will it be able to figure out what the last number is if it's a character type and the number is something like 3? So it'll add one to make it 4 and not something like 10003. ?? --- "Chris W. Parker" <[EMAIL PROTECTED]> wrote: > > yeah that makes sense. hmm.. well i'll give you my > ide

RE: [PHP] Unique ID system - need help/ideas

2004-03-10 Thread J J
ke KY3, AL4, KY5, etc. Make sense? --- "Chris W. Parker" <[EMAIL PROTECTED]> wrote: > J J <mailto:[EMAIL PROTECTED]> > on Wednesday, March 10, 2004 3:46 PM said: > > > Any ideas? Thank you in advance! > > does it all have to be in th

[PHP] Unique ID system - need help/ideas

2004-03-10 Thread J J
I was given a database that has uniques IDs such as: AL1 AL2 AR1 AR2 MI1 etc... The first two letters are based on the state they live in, then it would need to look at the next 5 characters to determine the next ID. My problem is how do I recreate this in PHP to make sure

RE: [PHP] PHP form to fax?

2003-12-03 Thread J J
as well. > Any fax to your jfax > number (you can get them worldwide) is turned into > an image and emailed > to you as an attachment. > > > > > -Original Message- > > From: J J [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 25, 20

[PHP] Avoiding duplicate orders?

2003-11-20 Thread J J
What is the simplest way to avoid duplicate order entry on a form? Some people aren't patient enough to wait for the SSL/credit card processing and will click the submit button two, three, or more times causing duplicate orders. Is there a quick way to disable the submit button at least in javasc

[PHP] Page breaks and printing?

2003-10-17 Thread J J
Is there a good way in PHP to determine page breaks for long reports and printing? I'd like to be able to best determine where pages should begin and end and reprint things like table/page headers and footers on each page so the reports print nicely. I'd like to avoid having to output to PDF or W

[PHP] PHP form to fax?

2003-09-25 Thread J J
I know in the past it wasn't possible to do something like have a user fill out a web form and that information would then be sent to a fax machine. This would require some sort of dialing abilities on the server. Is there anything available today that could perform such a function possibly withi

RE: [PHP] Timezones and Daylight Savings Time

2003-09-25 Thread J J
They want everything set to their time, so it would probably be easier just to determine the server time and add as necessary. I think... --- Jeff McKeon <[EMAIL PROTECTED]> wrote: > What if you set the server to use UTC and then used > the clients local > system setting to offset it for each cl

[PHP] Timezones and Daylight Savings Time

2003-09-25 Thread J J
Got a client site in Thailand that is about 13 hours different from the Web Server time so with any date/time stamping I need to add the 13 hours. However, when it comes time for DST, I'd hate to have to code for that or remember to manually change the time stamping. Is there some kind of automat

[PHP] PHP form builder?

2003-07-03 Thread J J
I've seen survey tools before to build surveys dynamically with PHP code, but I'm looking for something a bit more simple that just allows you to build HTML forms dynamically. Something where I say I need 10 fields, some checkboxes, a submit button and it then generates the form on the fly. Then

[PHP] Using PHP to read style sheet -- create drop-down?

2003-07-02 Thread J J
Is it possible for PHP or maybe javascript+php to read in a style sheet (whatever.css) and create a drop-down of all the elements within that style sheet? CSS contains: .heading {blah blah size blah} .headingBold {blah blah size blah bold} Then in PHP I'd like to have a drop down that shows thos

[PHP] Source/version control?

2003-06-23 Thread J J
What tools do you recommend or use for a team environment that will allow us to maintain source control and even offer some version tracking/history in case we need to go back to old code? We need the ability to check-in and check-out files in a team environment --- normally just HTML and PHP typ

[PHP] phpMyAdmin to output CSV to excel (including fieldnames)

2003-06-16 Thread J J
I see all the options in phpMyAdmin for CSV/excel output but I can't get it to export the fieldnames, headers as well. It'd be nice to have it automatically do that into excel so the output is easier to follow and provide to someone else. Am I just missing the option in phpMyAdmin or does it not

Re: [PHP] mysql_num_rows

2003-04-04 Thread J J
oh and your SQL statement is wrong: SELECT * FROM table WHERE you are missing the FROM... --- Mike Tuller <[EMAIL PROTECTED]> wrote: > I can't get mysql_num_rows to work for some reason. > Here is a snippet > of what I have > > > $department_name = $_POST['department_name']; > > $selec

Re: [PHP] mysql_num_rows

2003-04-04 Thread J J
Try: ($select_total_rows == 0) instead. That and maybe echo $select_total_rows; to see what it's returning. --- Mike Tuller <[EMAIL PROTECTED]> wrote: > I can't get mysql_num_rows to work for some reason. > Here is a snippet > of what I have > > > $department_name = $_POST['departme

Re: [PHP] File management system

2003-03-20 Thread J J
Yeah I think I've seen that one... looking for a php/mysql solution if possible. Thanks! --- Mike <[EMAIL PROTECTED]> wrote: > Webmin has some good stuff. (it's a java applet > though...) > > On Thu, 2003-03-20 at 06:14, J J wrote: > > Anyone hav

[PHP] File management system

2003-03-20 Thread J J
Anyone have a good recommendation for a file management system that would allow the average person to browse certain files/directory on a web server and possibly make edits. Then the front-end would sort of catalog those files and index them so the web user could browse/search and open the files?

[PHP] Mailing list/message board combination?

2003-03-11 Thread J J
Is there something available that acts as both a message board and mailing list where: - users can interact via email online (mailing list) with all message being stored in message board format for web browsing - users can reply and create new discussions via the web message board which also send

Re: [PHP] What solution to use for mass newsletter mailing & reporting?

2003-03-05 Thread J J
Interesting way of tracking everything... and I like the idea of the pop-up being able to query the database for current status. For now, I'm firing off a process with no timeout and it can run even after browser abort... but no real way to check on it other than I send a "mailing complete" type e

[PHP] What solution to use for mass newsletter mailing & reporting?

2003-03-05 Thread J J
What do you use for mass newsletter mailing say for 5000+ members every month? At the same time, I'd like to be able to track who opened the message, any links they clicked inside the message, bounced messages, etc. I keep seeing reports that PHP/mail have trouble sending more than a few hundred

[PHP] PHP & Majordomo -- front end or reporting tools?

2003-03-03 Thread J J
I'm looking for something possibly already done in PHP to manage majordomo mailing lists. Also, if there's a way to read some log files and do some reporting ie: - how many messages sent - how many bounced etc Is this possible with PHP or does anyone know of a sample like this to get started?

[PHP] WYSIWYG Content Management system?

2003-02-04 Thread J J
I've seen CMS systems like phpnuke but it's kind of overkill for what I need and almost more news like. I'm looking for something that would allow the user to change content, change/upload images, all in a wysiwyg style so it's easy to see and use. It'd be cool to be able to login to the admin ar