[Koksi]

Hey,

i have this code :

Code:

$cmtx_page_id = $id;
$cmtx_reference = $row[name];
$cmtx_path = "comments/";
define('IN_COMMENTICS', 'true'); //no need to edit this line
require $cmtx_path . "includes/commentics.php"; //no need to edit this line

$id = $_GET['id'];

URL : script.php?id=5

in the MYSQL Database is always the false page id .. from 1 next to 5 ..

Only i have this bug?

Mfg

[Steven]

Hi,

Can you explain what you mean:

always the false page id .. from 1 next to 5 ..

[Koksi]

the script.php?id=51 and the page id in the database is for example 3

[Steven]

There are two ID related columns in the pages database table.

One is called 'id' and the other is called 'page_id'.

The 'page_id' stores the $cmtx_page_id value, in your case 51.

The 'id' is an auto increment column, so it may be 3 in your case.

[ambius]

I have noticed that in the comments table the page_id is a number.
in pages table the page_id is a string and the id is a number
WHERE comments.page_id = pages.id
but comments.page_id != pages.page_id

seems like an odd naming structure, but that is how it works for me.

I believe the $cmtx_page_id is looking for a string that matches the pages.page_id not the pages.id or the comments.page_id

if you are trying to write a query to get comments or ratings about a page, then you should JOIN the tables WHERE comments.page_id = pages.id

I hope this helps!

[Koksi]

There are two ID related columns in the pages database table.

One is called 'id' and the other is called 'page_id'.

The 'page_id' stores the $cmtx_page_id value, in your case 51.

The 'id' is an auto increment column, so it may be 3 in your case.

i know.. but the page_id is not an increment auto column and is not 51..

[Koksi]

I want to tag a comment counter in another div. I wanted to include the Comments table with the Page ID but it doesnt work.