RE: [PHP-DB] "resource ID #3"
| From: | Beau Lebens | Date: | Fri, 12 Jul 2002 01:20:29 +0000 |
| Subject: | RE: [PHP-DB] "resource ID #3" | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20501@lists.php.net to get a copy of this message | ||
Jonathan,
most (all?) of the database query-related functions in PHP return a
"Resource ID" which contains the data resulting from your query. To access
that information, you need to pass the Resource ID thru a function like
(assuming u r using MySQL) mysql_fetch_array() or mysql_fetch_row()
Have a look at those 2 (or their equivalents for different DBs) in the
manual and go from there :)
HTH
Beau
// -----Original Message-----
// From: Jonathan [mailto:jsl@brandeis.edu]
// Sent: Friday, 12 July 2002 9:18 AM
// To: php-db@lists.php.net
// Subject: [PHP-DB] "resource ID #3"
//
//
// I am a newbie to php (as i have announced several times on
// this bulletin
// board =) so I thank you all for your help.
//
// Mi problemo:
//
// I have a database of events going on at local colleges. The
// names of the
// tables are the abbreviated names of the colleges. I grab
// those with a 'SHOW
// TABLES' command to the mysql que. Then, I have a second
// database which
// matches each abbreviation with the proper name. When I try
// to run any query
// on the second database, the only output I recieve is
// "resource id #3" Any
// suggestions?
//
// Jonathan
//
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//