DaniWeb Forum Index > Web Development > PHP

php mySQL Problem

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 4

Reputation: djcritch is an unknown quantity at this point

Solved Threads: 0

djcritch

Offline

Newbie Poster

php mySQL Problem

Dec 19th, 2007

heres the deal, i have created a table called tvprograms on a mySQL database and have added the fields id, program and comments and have populated the database.

The first thing i need to do is list just the programs in a php form but not the comments.

I then need to allow the user to select one of these programs and then display programs comments.

And finaly i need to allow the user to add a new program and comment to the database.

Can anyone help me with this as my coding is pretty poor!

Thanks guys

Merry Christmas!

•

Join Date: May 2004

Posts: 256

Reputation: FireNet will become famous soon enough

Solved Threads: 6

FireNet

Offline

Posting Whiz in Training

Re: php mySQL Problem

Dec 20th, 2007

If you need multiple comments, use 2 tables. One for the program details, and one for the comments. Use an id tag (preferably the unique key from the program details)

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
CREATE TABLE tvprograms (
p_id int(11) NOT NULL UNIQUE AUTO INCREMENT,
p_name char(40),
p_desc tinytext,
p_misc tinytext
);
 
CREATE tvprograms_comment(
pc_id int(11) NOT NULL UNIQUE AUTO INCREMENT,
p_id int(11) NOT NULL,
pc_text text
);
 
-- SQL QUERY MAY CONTAIN ERRORS
CREATE TABLE tvprograms (
p_id int(11) NOT NULL UNIQUE AUTO INCREMENT,
p_name char(40),
p_desc tinytext,
p_misc tinytext
);

CREATE tvprograms_comment(
pc_id int(11) NOT NULL UNIQUE AUTO INCREMENT,
p_id int(11) NOT NULL,
pc_text text
);

-- SQL QUERY MAY CONTAIN ERRORS

Use simple select queries to list the programs. Then use the p_id value to list single program and the comments for the program.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
SELECT * FROM tvprograms ORDER BY p_id DESC LIMIT 5; -- to list last 5 programs
 
SELECT * FROM tvprograms WHERE p_id=' $X '; --- to select one program
 
SELECT * FROM tvprograms_comment WHERE p_id=' $X '; -- to select all the comments for a single program.
SELECT * FROM tvprograms ORDER BY p_id DESC LIMIT 5; -- to list last 5 programs

SELECT * FROM tvprograms WHERE p_id=' $X '; --- to select one program

SELECT * FROM tvprograms_comment WHERE p_id=' $X '; -- to select all the comments for a single program.

I hope you get the idea how the 2 tables are being used to do what you need. One stores all the program details and the second stores all the comments, with each comment being tagged with an id number from the program details table.

Last edited by FireNet; Dec 20th, 2007 at 12:45 am.

See what you can, remember what you need

Fourzon | Earn via Coding

•

Join Date: Dec 2007

Posts: 2

Reputation: jyshr is an unknown quantity at this point

Solved Threads: 0

jyshr

Offline

Newbie Poster

Re: php mySQL Problem

Dec 20th, 2007

to get the programs
you can try this
$aq = " select * from tvprograms";
$sh = mysql_query($aq);

$n = mysql_numrows($sh);
for($i = 0; $i < $n; $i++)
{$pro = mysql_result($sh,$i,"fieldname");
//here give link
}