DaniWeb Forum Index > Web Development > PHP

I know nothing and need help please

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2007

Posts: 2

Reputation: purplephp is an unknown quantity at this point

Solved Threads: 0

purplephp

Offline

Newbie Poster

I know nothing and need help please

Jul 24th, 2007

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.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?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)
?>
<?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)
?>