My web designer disapeared and left me with my site done in PHP and MySQL.

It was all ok until the other day when something suddenly stopped working.

I don't know anything about MySQL or PHP.

On my site when you click 'recently added' it used to display products in date order and there is a php file called recent.php.

This stopped working the other day and put all the files in title order.
I looked inside the control panel and managed to change it to date order, but this is now all the files, not just the 'recent' ones.

The recent.php seems to have stopped working.

Can anyone help me please?

Here is the code that stopped working.

<?php


$result = mysql_query("SELECT * FROM products WHERE owner LIKE '%Lady Lita%' AND released NOT LIKE '' ORDER BY 'released' DESC")
or die(mysql_error());

//Add the rows to an array called result
$row = mysql_fetch_array( $result );

$i=0; //A counter

//For each entry found, grabs its variables and stick em in a table
while ($i < 5) {

include ("variables.php"); //Take the database variables and make them useable in php

if ($type != "Spell"){include ("product_table.php");}
if ($type == "Spell"){include ("spellsandhexes_table.php");}

$i++; //Repeat until all 5 entries have been populated
}
//Disconnect from database on each page refresh (keeps things secure)
?>
Member Avatar for iamthwee

ORDER BY 'released'

So is released a date then?

ORDER BY 'released'

So is released a date then?

Yes, the date the file is released.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.