RE: [PHP-DB] Resource ID
| From: | Walter, Marcel | Date: | Tue, 28 Aug 2001 07:08:31 +0000 |
| Subject: | RE: [PHP-DB] Resource ID | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11881@lists.php.net to get a copy of this message | ||
I don´t know what your class does ... but normally queries work like this:
open database
$qresult = query("select blah",$link_id);
// Now, in $qresult is a number with which you can go through your resultset
...
// For Example:
while ( $Recordset = ezi_fetch_array($qresult) ) {
print $Recordset["ColumnName"];
}
close database
...
Hope I am right (because I don´t know your class ...)
> -----Original Message-----
> From: Scott Mebberson [SMTP:scott@redbluedesign.com]
> Sent: Tuesday, August 28, 2001 07:06
> To: php-db@lists.php.net
> Subject: [PHP-DB] Resource ID
>
> Hi Guys,
>
> I am querying my MySQL database with this sql:
>
> $q->ezi_query($db, "SELECT id FROM words WHERE word='$word'");
>
> ezi_query() is just a class - an database layer so the databases can be
> swapped.
>
> Then I check the result to see if it worked. But all I get in the result
> is
> Resource id #5 - this number can very sometimes as I am doing these query
> in
> a loop and it just counts up..... to 8. But I am querying for $word which
> is
> a string which is not in that table in the database?
>
> Does anybody now what this means?
>
> Thanks.
>
> Scott
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net