Hello
Trying to CONCAT several fields into one with carriage in a Dreamweaver/php
recordset
I found an example for MS SQL
SELECT recid, CoName, Drive, Del_Proj,
'Co: ' +CoName + CHAR(13) + 'Acct: ' + Acct + CHAR(13) +'Drive: ', Drive) AS
Info
FROM data
ORDER BY recid ASC
Desired Result:
Working on a routine to export a Filemaker data to mySQL for php
application.
Using scripts I build a calculated field below:
INSERT INTO abctable (JobNumber, JobTitle, AE, Client, StartDate) VALUES
(9997, ' ABC ' , 'jrt' ,1234, '')
or
UPDATE abctable SET
Hello
Query:
SELECT Name, St, PNumber
From TABLE
WHERE St = FL
ORDER BY PNumber
Would like output to be:
1 Joe Jones 123-123-1234
2 Mary Adams 123-123-4567
3 Ted Smith 145-456-8974
etc
How can I generate a record number
SELECT recnu(), Name, St, PNumber ??
thanks
jrt
Working with new clean install of Redhat 8.0 and
Apache 2.0.40 / php 4.2.2 / mySQL 3.23.52
I have a phpinfo page and mySQL is setup
I can access tables thru mysql
When ever I try to attach remotely to mySQL
thru php (DreamweaverMX, phpmysqladmin, Access ODBC export)
I get the following error: