Google Groups Home
Help | Sign in
How to list columns
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  6 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
UCFirefly@gmail.com  
View profile
 More options Feb 9 2006, 11:35 pm
From: "UCFire...@gmail.com" <UCFire...@gmail.com>
Date: Fri, 10 Feb 2006 04:35:01 -0000
Local: Thurs, Feb 9 2006 11:35 pm
Subject: How to list columns
I'm at wit's end as there doesn't seem to be any documented way to do
this. My old MySQL api library had some functions in it to pull all the
column names out of a query and display everything in a table form.
This seems simple enough, but I can't seem to find out how to get the
column names to iterate through.

There's probably a very simple solution I'm overlooking so far.

Also, if someone has any mini api libraries set up to eliminate extra
lines of code for SQLi, I would love to see them.

Thanks.

-Alex


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Jawed  
View profile
 More options Feb 10 2006, 1:17 am
From: John Jawed <johnja...@gmail.com>
Date: Thu, 9 Feb 2006 22:17:41 -0800
Local: Fri, Feb 10 2006 1:17 am
Subject: Re: [MySQLi-g] How to list columns

Alex,

I think this is what you maybe looking for:

http://us2.php.net/manual/en/function.mysqli-fetch-fields.php

Regards,
John

On 2/9/06, UCFire...@gmail.com <UCFire...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
UCFirefly@gmail.com  
View profile
 More options Feb 20 2006, 1:41 pm
From: "UCFire...@gmail.com" <UCFire...@gmail.com>
Date: Mon, 20 Feb 2006 18:41:09 -0000
Local: Mon, Feb 20 2006 1:41 pm
Subject: Re: How to list columns
This doesn't seem to work in conjuction with my_sqli's prepare and
execute statements.

-Alex


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Jawed  
View profile
 More options Feb 20 2006, 10:50 pm
From: "John Jawed" <johnja...@gmail.com>
Date: Mon, 20 Feb 2006 19:50:58 -0800
Local: Mon, Feb 20 2006 10:50 pm
Subject: Re: [MySQLi-g] Re: How to list columns

You need to use result_metadata() for prepared statements:

http://us2.php.net/manual/en/function.maxdb-stmt-result-metadata.php

On 2/20/06, UCFire...@gmail.com <UCFire...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
UCFirefly@gmail.com  
View profile
 More options Feb 21 2006, 9:45 am
From: "UCFire...@gmail.com" <UCFire...@gmail.com>
Date: Tue, 21 Feb 2006 14:45:43 -0000
Local: Tues, Feb 21 2006 9:45 am
Subject: Re: How to list columns
That's for a totally different database. As a my_sqli list, I was
looking for a my_sqli solution.

I'm guessing there is some jury-rig way of sending my_sqli data into
that to get to work, or perhaps you're simply pulling my chain?  =)

-Alex


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John Jawed  
View profile
 More options Feb 21 2006, 11:40 am
From: "John Jawed" <johnja...@gmail.com>
Date: Tue, 21 Feb 2006 08:40:38 -0800
Local: Tues, Feb 21 2006 11:40 am
Subject: Re: [MySQLi-g] Re: How to list columns

I didn't check twice...

http://us2.php.net/manual/en/function.mysqli-stmt-result-metadata.php

Either way, the function you are looking for carries the same name and
objective in both MaxDB and mysqli.

Regards,
John

On 2/21/06, UCFire...@gmail.com <UCFire...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google