On Jan 28, 2008 10:35 AM, [EMAIL PROTECTED] wrote:
While I don't believe this is a solution for most developers in this
group, I'll mention this only because you've stated this is a media
company. It strikes me that you may want to consider doing an RIA,
like Flex (SDK is open source), and
While I don't believe this is a solution for most developers in this
group, I'll mention this only because you've stated this is a media
company. It strikes me that you may want to consider doing an RIA,
like Flex (SDK is open source), and using PHP as a service. In fact,
I'll be doing one
I just remembered that on installation of Drupal, they have a feature that lets
you add a prefix to your database tables. But, when you use the queries and
fetches with drupal's built-in functions they return the tables as if they
don't have a prefix. So, you could see what they are doing as
Scott Hill wrote:
with renaming all of the columns in the SQL statement. If you are using
Postgres or something besides MySQL you might do something like this in a
stored procedure although I have never tried it. It would be neat if
someone could figure out a nifty way to do this.
Are you
I really should have reviewed this before I sent it. I forgot one piece of
importance. The first line needs to have the parameter MYSQL_ASSOC sent with
mysql_fetch_array. Plus, you would need to do more tweaking to get this to work
for if you were returning multiple rows, but I think I got my
On Jan 28, 2008 4:21 PM, Craig Jackson [EMAIL PROTECTED] wrote:
I just remembered that on installation of Drupal, they have a feature that
lets you add a prefix to your database tables. But, when you use the queries
and fetches with drupal's built-in functions they return the tables as if
Wade Preston Shearer wrote:
The AS option in an SQL command allows you to rename a field, like this:
select username as user, password as secretcode
Is it possible to rename all of the fields that you pull at once? Here's
what I want to do:
I have a table of fields that are all named with
The AS option in an SQL command allows you to rename a field, like this:
select username as user, password as secretcode
Is it possible to rename all of the fields that you pull at once?
Here's what I want to do:
I have a table of fields that are all named with the same prefix. I
want to
Off the top of my head, you cannot do anything like this in MySQL (the only
database I have a solid knowledge of). But, I would imagine you could maybe do
something like this in PHP. Lets say you are returning one row, and the prefix
is 5 characters long.
$a =
The AS option in an SQL command allows you to rename a field, like this:
select username as user, password as secretcode
Is it possible to rename all of the fields that you pull at once?
Here's what I want to do:
I have a table of fields that are all named with the same prefix. I
want to
On 28 Jan 2008, at 10:35, [EMAIL PROTECTED] wrote:
While I don't believe this is a solution for most developers in this
group, I'll mention this only because you've stated this is a media
company. It strikes me that you may want to consider doing an RIA,
like Flex (SDK is open source),
Wade Preston Shearer wrote:
Are you using a version of MySQL that supports Views? If so, just
make a View that has the column names the way you want, and then
SELECT from the View instead of directly from the table.
That doesn't actually eliminate having to list each field though, right?
Lamont Peterson wrote:
On Monday 28 January 2008 03:51:28 pm Wade Preston Shearer wrote:
The AS option in an SQL command allows you to rename a field, like this:
select username as user, password as secretcode
Is it possible to rename all of the fields that you pull at once?
Here's what I
13 matches
Mail list logo
