you can use PHPMyAdmin to create the database tables if you do not know how to write your queries. Or you can use this super simple template for creating a table:

CREATE TABLE tablename (
`id`...

ok... the flow should go like this:

1. the user visits register.php which shows a form with name-value pairs.

2. the user clicks submits and the name-value pairs will all get submitted to...

If you have altered the table to include additional fields, then you have to show us. same for your queries also, the full "INSERT ... " statements otherwise we wont know where you went wrong.

I'm...

You should post your entire query and let use know the structure of your table you are querying.

this might be the case that certain values are not accepted by the table structure definition.

does this work?

SELECT COUNT(x.*) AS countx, COUNT(y.*) AS county, COUNT(z.*) AS countz, (countx+county+countz) AS total FROM mytable1 AS x, mytable2 AS y, mytable3 AS x

Edit: No. but the...

Hi,

I don't know what is LEFT JOIN at all, but i accidentally made this query work. Can someone tell me if there is a shorter version of this query?


SELECT j . * , k.report
FROM (
SELECT x...

thanks tesu,

All that infomation helped alot. I'll try to work from there on. Now, changing the structure will be quite a pain... =(

Thanks for the tip! Joe Celko trees present some interesting concepts that's quite new to me and probably a bit too much to digest at the moment.

Are you saying that with my current table (aka...

Actually I think the lowest part would the LIKE clause... isn't it?

Hi,

I have a table

`Categories` with fields (category_id, category, parent_category_id)

I want to write in a single query to replace the parent_category_id with the corresponding...