On Monday 22 April 2002 12:54, Vania Smrkovski wrote:
> Hello, folks, and I apologize in advance if I break any rules here. This
> is my first post on this list and I couldn't find any archive to review
> existing posts for the answer to this question.
> a) How would you change the following the automatically find the tables and
> run through the iteration.
Using mysql running the query:
Would return the names of the tables in the currently selected database.
> I'm new at PHP, and I learn by doing, so
> forgive me for not doing the RTFM thing, but I just haven't found the
> answer yet.
Does that mean you haven't RTFM so you haven't found the answer yet?
> So instead I created a table called tableNames with one field,
> which I personally populated with the names of all tables.
> How should I have done it so that wouldn't be necessary.
> b) When I grab the values of the table names using my prepared table
> tableNames, I couldn't figure out how to get the TEXT value of that record.
> When I put in a debug statement, all I got was a value of "Array", rather
> than a name of a table.
It helps to RTFM. In any case the name of the function mysql_fetch_array()
kind of gives the game away :)
> You'll see below that I hacked a work-around by
> using a "foreach()" statement, which works flawlessly.
That is common practice when dealing with arrays.
> How can I grab a specific field of an array without using a foreach()?
> while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
If you know the names of the fields, then you can access them directly by:
$value_of_field = $line['name_of_field'];
If you had used:
while ($line = mysql_fetch_array($result, MYSQL_NUM))
Then you would have to reference the fields using:
$value_of_field_0 = $line;
Remember the manual is your friend. If you haven't already done so, download
a copy (it's available in various formats) and make use of it!
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
I don't know half of you half as well as I should like; and I like less
than half of you half as well as you deserve.
-- J. R. R. Tolkien
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php