[PHP-DB] filtered searches

2001-10-01 Thread WebDev
Hi all, I could use some advice, here is my problem: I need to run filtered searches on my database (mysql) and return records that fall within the bounds, not hard! I need to be able to select sporting stats of athletes (goals, assists, etc)in a table stats as well as their personal stats (hei

[PHP-DB] padding an id field

2001-10-04 Thread WebDev
Is there anyway to pad an id field in MySQL? I have a table with a PK field (id). This field is auto incrementing a 6 digit number ie. 000223. Is there anyway to pad this id so that it is padded with a code along with the auto incrementing part, such as ABC000223. Now I wouldn't want the ABC p