Added: 1 year ago
From: h0rny0toad
Views: 3,618
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (8)

Sign In or Sign Up now to post a comment!
  • 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...

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

  • New Blog and SQL file at tskmatrix . com

  • 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??

  • @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.

  • @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!

  • @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 '/'

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

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more