| |||||||
| Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics. |
![]() |
| | LinkBack | Thread Tools |
| | #1 (permalink) |
| Account Closed | PHP help needed - again! PHP Code: All help appreciated. |
| |
| | #2 (permalink) |
| NamePros Regular | For the first part, after this: PHP Code: PHP Code: PHP Code: PHP Code: |
| |
| | #5 (permalink) | |
| NamePros Regular | Quote:
PHP Code: ALso, you could change it to PHP Code:
__________________ Site Armory, tools for your website | Webmaster SEO Forums | PHP Tutorial and coding forums | |
| |
| | #8 (permalink) |
| New Member | "SELECT * FROM users where username LIKE '%$search%'" is a slow query, and searches through your entire table. Why not rather have "SELECT * FROM users where username = '$search'" assuming the query is being built from the visitor's click on a username? Then also create an index on username for the first 2 or 3 characters? |
| |
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| |