Posts by debasisdas

622

626

628

632

636

640

644

648

650

654

658

666

670

676

680

680

684

688

692

696

700

702

706

708

714

718

now the QF picture is getting clearer.

726

732

This is what is called a two-way communication.

Happy to help you.

648

try this

SELECT posts.*, channels.channel 
FROM posts 
INNER JOIN channels 
ON posts.channel_id = channels.id 
WHERE  (posts.id=? OR posts.id=? )   ----better to use IN clause here.
ORDER BY posts.published DESC

is franchise_name getting inserted properly into the table.

648

read the rules

6 5 2

652

what about this

1. book (book_id,book)name,author_id,....)
2. author (author_id,author_name,.......)

Composite key on book (book_id, author_id)

what about this

1. book (book_id,book)name,author_id,....)
2. author (author_id,author_name,.......)

Composite key on book (book_id, author_id)

but you are inserting a record , right ?

Is the record getting stored in database ?

Please check in backend .

Yes, you can connect to any database from PHP if you know the connection method and have the proper drivers.

yes , that is exactly how developers trouble shoot. :)

Kindly post what have you tried so far from your side and also post the proper table structure for analysis.

ok, tell me what happens when you execute this ?

getting any error ?

You need to use ALTER VIEW.

Please read this for details.

Why you need to create the following tasbles ?

1. bookauthor
2. bookreview
3. bookreference

why not have reference in the book table itself.

Why not create insert script using some tool (best in EXCEL) and insert the parent record and then the dependent child record.

Ireland proved they really deserved to be part of this World cup.

What is the problem , i don't see anything wrong with the SQL.

I am not aware of how you do things in PHP, but i was expecting some INSERT statement as part of SQL.

or are you calling any stored object like a prodecure ?

Kindly post the SQL part only.

I am not sure from this code where is the INSERT statement .