SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:30 PM
| ||||
| ||||
 Re: SQL statement work in mysql4 but not mysql5 I had this problem here and i change my query to: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc, c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid FROM ibf_forums f INNER JOIN ibf_categories c on f.id_cat=c.id_cat LEFT JOIN ibf_moderators m ON (f.id=m.forum_id) WHERE c.id=f.category ORDER BY c.position, f.posit It works fine to me. ""Jason Chan"" <eg_ckhag@yahoo.com.hk> escreveu na mensagem news:egg8kn$v31$1@sea.gmane.org... >I am going to upgrade my database from version 4 to 5. > However I found some of my web application doesn't work on MySQL5 > > e.g following statement works in 4 but not 5 > > SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as > cat_state, c.name as cat_name, c.description as cat_desc, > c.image, c.url, m.member_name as mod_name, m.member_id as > mod_id, m.is_group, m.group_id, m.group_name, m.mid > FROM ibf_forums f, ibf_categories c > LEFT JOIN ibf_moderators m ON (f.id=m.forum_id) > WHERE c.id=f.category > ORDER BY c.position, f.position > > Error: > Unknown column 'f.id' in 'on clause' > > The alias seem not working? > What should I do, I dont want to rewrite all my sql statement.... > > Thanks. > > Jason > > > >      |
 |
« validating, filtering price value for a decimal column from various strings
|
MySQL 5.0.26 has been released (part 2) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:15 AM.
