[UKSwift]

Hi,

I am currently in the middle of trying to get a system working for a registration plate website. At the moment i am trying to use OsCommerce, but due to the number of rows in the database things grind to a dramatic hault whenever you query it with a search.

Does anyone know of any other system that is already released that may help me?

I also a slight grasp of PHP and MySQL and am able to write basic enter data into database then retrieve it using a search function and output this data on a page scripts very easily, is this something i could look into doing as opposed to using a big system such as OsCommerce. The only i would struggle on is sending the data to the payment system in place. At the moment we are using paypal.

here is an example of what I would like the site to look like and more importantly the sort of speed i will ultimatley be aiming for..

http://www.right-reg.co.uk

Would a simple search on a table containing 20 million rows surfice or do i need to look in alot more detail at searching a database on such a scale?

Any help on this matter would be greatly appreciated.

Regards

Tim

[perleo]

Hi, i have a function, that creates the code for a HTML table. Within that function i have a variable, called $title. This contains text, which is declared on each page, that is shown in the table, i have put

PHP Code:

global $title; 

in the function, but it doesnt show.

This function is used for blocks for a menu, each block has its own file, which is included, and within the file, is the declaration for the variable.

Heres the code for the function

PHP Code:

function block_open() {

global $title;

        echo "<table align=\"center\" bgcolor=\"#000000\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" width=\"100%\">";

        echo "<tr bgcolor=\"#009999\">";

        echo "<td class=\"content-menu-cat\" bgcolor=\"#008080\"><span class=\"content-menu-cat\"><font face=\"Arial, Helvetica, sans-serif\" color=\"#FFFFFF\"><img src=\"images/icon.gif\" alt=\"\" align=\"left\" />";

        echo $title;

        echo "</font></span></td>";

        echo "</tr>";

        echo "<tr bgcolor=\"#FFFFFF\">"; 

        echo "<td>";

                       }

            

           

//close table                      

function block_close() {

        echo "</td>";

        echo "</tr>";

        echo "</table>";

        echo "<table><tr><td></td></tr></table>";

                       } 

Then a typical block file looks like this

PHP Code:

$title = 'Navigation';

block_open();





block_close(); 

But the $title doesnt show!!

[nd2]

the indexes on the tables may be all that needs changing but at the same time i have no idear how many querys OsCommerce makes what you should be looking for with such a large database is a very small.

perleo he means a database table and not a html table.