Need Help

lwilliams2012

I have been working on a blog farm and I have built all my pages so far. I am having trouble with getting my data from the my database table and displaying it on the site.

I have a form that sends the data to the table

Name, URL, Category, Description

I want to be able to pull the data so when someone clicks on (example) Category 1 then the first 10 sites for this category will be displayed.

Can someone lead me in the right direction. The tutorials in my book doesn't help.

anoopmail

SELECT * FROM category WHERE category_id=$_GET['category'] LIMIT 10

johanafm

Except you should never ever use unsanitized data from external input, since it can't be assumed to be safe.

"SELECT * FROM category WHERE category_id=". (int) $_GET['category']. " LIMIT 10";

anoopmail

wrong thread, sorry. I don't know how to delete

Coruba67

mysql_real_escape_string should help out there..

johanafm

Except that category_id most likely is an integer which means you shouldn't be using mysql_real_escape_string.

samuelcook

floor($_GET['category'])

johanafm

A cast is more efficient and also more clear when reading the code. It tells you straight off that the value is being turned into an integer.

A call to floor on the other hand will require a cast to int (implicitly), as well as either unnecessary code being inlined or the regular pushing of return address etc to the stack, only to eventually return the exact same number that you provided the function with.

Furthermore, even if you're dealing with a decimal number, floor and int will have the same effect for positive numbers. So the only reason to use floor would be for negative decimal numbers.