Yii Music Store Tutorial Step 4

[tallesdop1]

it shows me an error

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.'Name','t1'.'ArtistId' FROM `tbl_artist` `t1` LEFT JOIN 'tbl_album' ON 'tbl_alb' at line 1. The SQL statement executed was: SELECT DISTINCT 't1'.'Name','t1'.'ArtistId' FROM `tbl_artist` `t1` LEFT JOIN 'tbl_album' ON 'tbl_album'.'ArtistI...

[idevric]

@tallesdop1 he wrote some none comment comments, like these dashes -------------, you'll have to get rid of them

[h0rny0toad]

New Blog and SQL file at tskmatrix . com

[idevric]

When you move very very fast, i missed the gid part,

it displays

undefined index: gid for the line

14:  if($_GET["gid"]) {

what have i missed??

[h0rny0toad]

@idevric GID is the Genre ID found on the address line of the browser. gid=5 would be the index key value of the genre in the dB.

[idevric]

@h0rny0toad left Yii for a while, just came back again on your tut, just found the issue with the undefined 'gid'

the url on my one displays browse/5 instead of browser?gid=5, when i hand type ?gid=5 it works.

how to write the url?? from ?gid= to just /

By the way nice tutorial!

[idevric]

@h0rny0toad found the issue, i think i left out the 'gid' => $Genre->GenreId in the views/site/index.php

although is there anyway to make the url pretty instead of ?gid= and make it become just a slash '/'

[h0rny0toad]

SQL file has been uploaded to SkyDrive. Do a search for Yii Music Store Tutorial and you should be able to get it there.