Brandonisio <[EMAIL PROTECTED]> writes
>Hi,
>
>I did run into one challenge when using a join. I created my tables
>with the primary key using a common name `ID`. When I'd
>mysql_fetch_object the key would be over written. Changing this field
>to something unique allow it to be part of the returned fields in the
>object.
I like to use three letters at the beginning of each fieldname, to
identify the table, in your case it would be proID, grpID, and criID. It
makes things much easier to code, because then the ID can always have
the name ID, description can always have the name desc, etc. No need to
remember most fieldnames.
I have often wondered if there is any slowdown in execution, since the
query does not immediately know which table the fields are in. If there
is a delay, it must be infini-thingy, because I have never noticed a
difference.
--
Pete Clark
Free advertising for your website, business, or organisation at:
http://www.hotcosta.com/resources.php
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
SPONSORED LINKS
| Php mysql | Job postings |
YAHOO! GROUPS LINKS
- Visit your group "php-list" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
