| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #1339 | PEAR::DB select distinct ( text field ) Error | ||
|---|---|---|---|
| Submitted: | 2004-05-04 20:07 UTC | ||
| From: | tingham at coalmarch dot com | Assigned: | danielc |
| Status: | Bogus | Package: | DB |
| PHP Version: | 4.3.2 | OS: | OSX |
| Roadmaps: | (Not assigned) | ||
[2004-05-04 20:07 UTC] tingham at coalmarch dot com
Description:
------------
Selecting distinct( category_name ) from a table containing that field as
type varchar(255) produces an error on either query or getAssoc.
This same query runs fine in mysql terminal.
Reproduce code:
---------------
create table products(
product_id INT NOT NULL AUTO_INCREMENT,
product_category varchar(255),
product_name varchar(255)
PRIMARY KEY(product_id)
);
<?
$que = "select distinct( product_category ) from products;";
$rs = /../->query($que);
$rs is error.
Expected result:
----------------
List of results from mysql.
Actual result:
--------------
Output to a <select> returns something of the form:
"
D
s
"
Comments
[2004-05-04 20:50 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!