cmccully

I'm looking for a good resource on database design. I know the basics of normalization and indexing. What I'm looking for is something that is more of an intermediate level that goes into detail on normalization, indexing, security, etc... I can build a database and interact with it but I …

Hi I have a PHP/MYSQL driven site. When a user creates a new account or updates their existing username or email address I do a quick check to make sure the requested entries are not already in use. I am concerned that in the few milliseconds between the SELECT and …

Hi all, I have a page that modifies (using AJAX) a list of animal characteristics stored in a database. The page uses a PHP file to control the actual access to the database. Everything works except when a duplicate entry is entered. The PHP file prevents the duplicate entry from …

Hi all, I have an AJAX function that sends the contents of a text field to a PHP file. The file checks for duplicate entries and if unique stores the new record in MYSQL. This all works fine. However, I would like the PHP file to send back an alert …

Hi all, I have an AJAX script that pulls a radio group list from PHP. I would like to then read which of those options the user subsequently selects. My AJAX script: [CODE]function showCharacteristics() { xmlhttp1=new XMLHttpRequest(); xmlhttp1.onreadystatechange=function() { if (xmlhttp1.readyState==4 && xmlhttp1.status==200) { document.getElementById("charList").innerHTML=xmlhttp1.responseText; } } xmlhttp1.open("GET","ctrPanelProc.php?selection=getCharacteristics",true); xmlhttp1.send(); }[/CODE] …