Need Suggestions for Organizing Series of Records

[tripwire8]

I have a question pertaining to the best way to organize a number of records in a series. Basically I have different records that are categorized under a series title. Under the series title there may be around 10 records with different sub-titles.

Now at the moment I have it programmed so that the series titles are shown once on my main page and when clicked they are sent within a query string to the viewSeries.php page where it is compared to all other series titles in my table like so:

$sql= "SELECT * FROM notes WHERE series = '$seriesID' ORDER BY resource_date DESC ";

This way all records that contain the same series name are brought up.

However I would like to know if there is a better way to go about doing this other then using the query string. I sometimes get errors when my series title contains quotations.

[pete_bisby]

Have you tried using the addslashes() function - this will insert a "\" before single and double quote marks. This will stop the error messages appearing when running your queries.

To stop the slashes printing when displaying the series titles, use the stripslashes() function.

[tripwire8]

I was using addslashes() but for some reason it wasn't getting saved to my database with the "\". But I solved the problem by using addslashes() again on the string before it gets sent to the next page.