QL

Miscellaneous Forums/General Discussion/QL

The forum is locked. These are the original blitzbasic.com forums, kept so they can still be read. No new topics, replies or edits can be made here. To join in, head over to the Blitz3D+ forums.

My site is basically going to be linked to a database table - a list of games; titles, prices, descriptions (hence my last question about string lengths etc). SQL queries will be done via PHP.

I plan to add a search facility and filters (card games, puzzle etc) so users can find what they want more easily.

I don't want users to have to login, which is why I need them to have anonymous access while keeping my database secure. Users will be able to access on a 'read-only' basis. Nobody except me will be able to modify the database table.

An SQL query might look like:

$search = "peggle"; #user input goes here
$query = "SELECT * WHERE Title = " . $search;


i.e. all the user gets to choose is the search string, and has no control over the actual query.