PHP and HTML

[emo]

I have a DB created in Filemaker. I have download PHP pad. I want to create a search feild. I want to be able to type in a course number and have it pull out the books it needs for that class from the db(filemaker) and list the books that course id needs. Can anybody help me figure this out?

I am using Filemaker's Custome web publishing engine and need to pull information out of the DB using php and write code in HTML. Help please.

[clamcrusher]

maybe someone can recomend you a book to help you learn php and mysql.

bump

[The buzzing bee]

What is in your database? I would make a table called 'books' listing all the books with four columns - 'id', 'courseidsneededfor', 'nameofbook', and 'nameofauthor'. I would then have another table called 'courses' for listing all the courses with two columns - 'id' and 'nameofcourse'. Then create your form in HTML, with a sumbit button called 'submit' and a text box called 'typein'. I would then do something like this. Disclaimer: I am quite new to PHP and have not checked this code, so use with caution!

<?php

if(isset($_POST['submit'])) and ($_POST['typein'])!=""){
$course = mysql_query ("SELECT * FROM courses WHERE nameofcourse == ($_POST['typein'])", $connection);

$results = mysql_query ("SELECT * FROM books WHERE courseidsneededfor LIKE ($course[1])", $connection);

echo="<TABLE>"
while($row = mysql_fetch_row($results))
{
echo="<TR><TD><P>".$row[2]."</P></TD><TD><P>".$row[3]."</P></TD></TR>
}
echo="</TABLE>"
?>

[The buzzing bee]

oops, forgot to close the if. put in a } at the end just before the ?>