Search options

They really aren't comparable, it's like asking the difference between a search engine and a discussion forum. A CMS is a software program designed to help you manage a site; a portal is a type of website or webpage page that directs you to various other websites or pages, kind of in a hierarchy.

The only difference I can see is the SERIAL columns. The equivalent of "SERIAL" in MySQL is "INT NOT NULL AUTO_INCREMENT". However, you can't have more than one auto_increment column in one table in MySQL, so you'll have to change your disp_position to something else. Other than that it should work fine.

I don't think the PayPal API is that bad. Can those of you who want a PayPal mod give a little more detail on what you're looking for?

You can't change exit to echo, they aren't the same thing. For example profile.php has in numerous places the following line:

require PUN_ROOT.'footer.php';

and it expects the script will stop at that line.  If you change the exit to echo, it will continue on doing things that aren't supposed to happen.

Then you need to get the form variable first.  Add the following to the beginning of your index.php:

$lang = $_GET['lang'];

Create a new table with the columns you want, copy the contents of original table to the new one, drop the original, and then create another new table with the original name and copy the contents again. You can wrap the whole thing in a transaction if you want.

CREATE TEMPORARY TABLE mytable2 (col1, col2, col3);
INSERT INTO mytable2 SELECT col1, col2, NULL [or default value for col3] FROM mytable;
DROP TABLE mytable;
CREATE TABLE mytable (col1, col2, col3);
INSERT INTO mytable SELECT col1, col2, col3 FROM mytable2;
DROP TABLE mytable2;

Check what version of SQLite you are using. ALTER TABLE ADD COLUMN did not come until SQLite 3.2.

Actually, I figured out a way to do this with one query (this won't work on MySQL 4.0.X or earlier, though). I tried it out myself on your test data and the result is exactly what you wanted.

SELECT idx, relate_idx, creation FROM table WHERE (relate_idx, creation) IN (SELECT relate_idx, max(creation) FROM table GROUP BY relate_idx) ORDER BY creation DESC;

I selected it because it's fast and efficient and the default theme/layout is simple and clean. Most other forums are so visually cluttered it makes my head spin.