| | |
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:
Solved Threads: 0
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.
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 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) ?>
![]() |
Other Threads in the PHP Forum
- Previous Thread: IIS Integrated Auth. & Redirect upon login
- Next Thread: Previewing PHP frameset files in browser
| Thread Tools | Search this Thread |
.htaccess alerts apache api archive array autocomplete beginner binary broken cakephp checkbox class cms code convert cron curl database dataentry date display duplicates dynamic echo email emptydisplayvalue error execute explodefunction file files firstoptioninphpdroplist folder form forms function functions google hack href htaccess html htmlspecialchars image include insert ip javasciptvalidation javascript joomla keywords limit link login mail matching menu methods mlm multiple mysql network object oop paypal pdf php problem query radio random recursion recursive redirect remote script search securephp server sessions shot sms source space sql subscription syntax system table tutorial tutorials update upload url validator variable video web youtube






