[PHP-DB] E-mail marketing tool?

Hi there, I've been trolling through hotscripts.com etc, looking for a tool that I can buy/download to use as a email marketing tool. My company has requested the ability to allow users to sign up for certian offers, news items etc, and need the following functionality: Multiple lists, and each

[PHP-DB] online test, plz help

i'm developing on_line entry test facility in it. Any student who wants to take this test follows the following steps 1. he/she registered him/her self. 2.secondly he enters his user name password in a login form,if these entries are valid another form appears ,prompting him to enter his

[PHP-DB] Re: Calculating time unused

David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given

[PHP-DB] Hours available in a day

Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given any day how can I calculate how many hours are available between the hours of 09.00 and 17.30 so a user can see at a glance how many hours

[PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script

On Thu, 2003-10-02 at 22:28, Michael Scappa wrote: Ruprecht, Make sure you have PHP pointing to the right location for the mysql.sock. locate mysql.sock. Sometimes its in the /tmp dir. If it is in another location you can point to it specifically when you call mysql_connect (refer to

RE: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script

Looks possible that php isn't using that particular ini file. Make sure it's the correct ini file, because your error message has it looking in a different location. Try mysql_connect(127.0.0.1:3306:/tmp/mysql.sock, etc etc etc) for your connect (that might supposed to be the path to socket, not

[PHP-DB] Round a number

Hi, I have a query that returns a number from culculation in my table. It returns say 4.00, 8.75, 0.00, 12.50 etc. How can I get MySQL to return the number without any zeros, i.e. 4, 8.75, 0, 12.5 etc? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] Round a number

Try the rtrim function in php Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 10:12 AM To: [EMAIL PROTECTED]

Re: [PHP-DB] Round a number

SELECT TRIM( TRAILING '.' FROM TRIM( TRAILING '0' FROM mycol ) ) Ignatius _ - Original Message - From: Shaun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 03, 2003 5:12 PM Subject: [PHP-DB] Round a number Hi, I have a query that returns a

Re: [PHP-DB] Round a number

On Fri, 3 Oct 2003, Shaun wrote: I have a query that returns a number from culculation in my table. It returns say 4.00, 8.75, 0.00, 12.50 etc. How can I get MySQL to return the number without any zeros, i.e. 4, 8.75, 0, 12.5 etc? You can't in MySQL. At least not that I could figure out.

RE: [PHP-DB] Round a number

This should do it: http://www.mysql.com/doc/en/Miscellaneous_functions.html FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimals, and returns the result as a string. If D is 0, the result will have no decimal point or fractional part: mysql SELECT

[PHP-DB] RE: Hyperlinks in MySQL dB

-Original Message- From: Gary H. Holabird [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:06 AM To: [EMAIL PROTECTED] Subject: Hyperlinks in MySQL dB This has got to be really simple I feel really stupid having to ask but... I'm a very green n00b writing my first php

[PHP-DB] PHP Issue

I'm trying to 'run' a php pgoram by loading it into my browser, but instead of running, it only displays it to me - how can I fix this?

RE: [PHP-DB] PHP Issue

check your apache httpd.conf (or iis configuration or whatever your webserver is) see if you told it to parse php scripts before presenting it to the web. *** LoadModule php4_module c:/php/sapi/php4apache2.dll AddType application/x-httpd-php .php *** or

[PHP-DB] Re: Hours available in a day

Shaun [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given any day how can I calculate how many hours are available between the

[PHP-DB] Re: Calculating time unused

Shaun [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have a table called Bookings which has two important columns; Booking_Start_Time