"I think I will need to give you VPN access because I cannot recreate this in a simpler page." I need your email address
Also, I checked the Query via the test in Dreamweaver, no different to any other.
Here is the code from one of them:
mysql_select_db($database_med_dataentry, $med_dataentry); $query_rsSpecies = "SELECT species_id, CONCAT(species,':', common) AS label FROM species WHERE taxa='bird' ORDER BY species_id"; $rsSpecies = mysql_query($query_rsSpecies, $med_dataentry) or die(mysql_error()); $row_rsSpecies = mysql_fetch_assoc($rsSpecies); $totalRows_rsSpecies = mysql_num_rows($rsSpecies);
Now the connection details are the same as the ones that provide the data for me to select to edit in the first place. And if I TEST this sql it gives me the desired results.
I have tried making them just simple recordsets, still gives the same error. I cannot repeat it on my simple site.
|
|
|