Thanx Rob,
I have a MySQL database which contains a category column.
What I want to do is show a popup layer (which have have done with DHTML) and run the SQL query to display part of the category records.
At the moment I have got the sql statement to work fine it conects to the database and returns the correct records.
The problem is that I want to change the records when the user clicks on a link. I.e. I want to run a new query. I have setup the sql to except a variable $type so I can use the same code to run query again:
$cursor = mysql_query("select id,shop,url,category from db where db.category = '$type' order by id");
So all I need to do is pass it the new value of $type.
So if I could dynamically get the php to run the sql query again onClick, then this problem would be solved.
I hope this helps.
Matt.