Spent the past few days moding cubecart but having some problems..
I have an sql query that outputs tracks (new db table mp3 audio). It should out put 4 tracks but it is only outputting 1.
This what I'm using:
// START GET ARTIST PREVIEW
$query = "SELECT * FROM `tracks` WHERE `preview` = 'Yes'";
$result = mysql_query($query) or die("Error: " . mysql_error());
while ($row = mysql_fetch_array($result))
{
$track_title = $row["title"];
$preview_length = $row["preview_length"];
$track_num = $row["num"];
$track_length = $row["length"];
}
// END GET ARTIST PREVIEW
Is this a cubecart thing or have a messed somthing up?😕