Random Quote Generator (Filter by Category)

[xerox02]

Hello everyone

              I am new here, and I had a quick question. I am trying to program a random quote generator; where I can filter the quotes generated by the buttons pressed on my website(Filtered by different Categories). How would I be able to achieve this so I can have the quote fit into a box on my website?

 

Thanks a lot!

[teamatomic]

<input type=submit name=category value=sports_baseball>

$category=$_POST['category'];

Do what you want from here

 

 

HTH

Teamatomic

[xerox02]

Awesome, I have to figure out a way to connect this to the mysql databases, and put the quotes into the mysql database.

[ignace]

SELECT * FROM quotes q, quotes_categories c WHERE q.category_id = c.id AND c.id = $category_id LIMIT 1

[xerox02]

I had another quick question, I have "id"ed all my data in the database by int. Is there a way I can get the total number of entries in my database; like something that will give the minimum and maximum entries in a database at the time. 

(is there a way I can take the total number of entries in the database and assign it a variable to use?)

Also, is there a way I can make a html box where you can submit data to my database?

One other quick question , is there a way I can put check box on my page, and depending on which boxes are checked it will narrow the results of the databases.

 

Thanks,

Xerox02

[xerox02]

I had another quick question, I have "id"ed all my data in the database by int. Is there a way I can get the total number of entries in my database; like something that will give the minimum and maximum entries in a database at the time. 

(is there a way I can take the total number of entries in the database and assign it a variable to use?)

Also, is there a way I can make a html box where you can submit data to my database?

One other quick question , is there a way I can put check box on my page, and depending on which boxes are checked it will narrow the results of the databases.

 

Thanks,

Xerox02

 

I actually found a solution for this by using  mysql_num_rows(),  and I am in the middle of finding a solution to having a html box to submit data to the database. I am still trying to find a way to narrow results with check boxes, and depending on what boxes are checked, it will choose a table from a database.