Good evening!
I need to setup a user, 'commerce' with a password, that can be accessed
from any web server in our farm 'blackmesa-isp.net'. What "GRANT" statement
do I need to make this work? I've tried a bunch of the examples in the
manual and can't get it right. Specifically, I need the user to
"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 column
"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
> betwe
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
insta
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?
-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 sc
I just realized that this does not work with integers such as 80,
so one should add a test condition:
SELECT
IF(
ROUND( mycol ) = mycol,
mycol,
TRIM( TRAILING
'.'
FROM TRIM( TRAILING '0' FROM mycol )
)
)
Ignatius
_
- Original Message -
From: "Ignatius
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 FORMAT(12332
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.
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 r
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 PROTE
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, visi
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, no
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
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 the
"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
> > D
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 comple
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
18 matches
Mail list logo
