stevieontario

It worked! Beautiful! Many thanks, appreciate your time.

Ken2k7, Empty means blank. The zeros I guess are there because their respective columns ("id" and "intensity") are defined as INT and are not null.

Appreciate your time, revraz. All rows have the default zeros. Half the rows also contain useful data (in one particular column, called "name") in addition to the default zeros. I want to delete the rows in which "name" is empty.

thanks revraz, I guess you're right, if the rows exist they can't be empty. Two of the fields are "int" type, so those contain zeros, which I guess are auto-generated. The column I wanted to populate stayed empty after my failed query, which is part of the reason why I assumed the rows were empty. Another reason is that I was able to select the populated rows for deletion using "check all" and phpMyAdmin indicated a range of rows in that query box above the table (in Browse view). But the query box only indicates a single row when I click "check all" in the rows that only contain the zeros.

thanks for the prompt reply. Definition of empty: good question. This is a table that will only ever have 124 rows. I'll populate some fields by hand, but other fields I'll populate using an INSERT query. So I tested the INSERT query once, successfully, and it populated one field. So the result was a 124-row table, with one column populated. Then I realized I could populate another column using INSERT. This didn't populate the column I wanted, but it did add another 124 rows to the table. These are what I mean by empty.

Hello mysql experts, I feel a bit dumb because I'm sure this is easy. But I want to delete a range of empty rows from a mysql table. I'm in phpMyAdmin, in Browse view. To a greenhorn like me, it seems that clicking on the "Check All" feature at the bottom of the table, then clicking on the big red "x" (delete), would do the trick. But no dice. It only deletes a single row at a time. (It does work with rows that have data, but not the empty ones.) There aren't a lot of rows, only 363, but there's got to be an easier way to do this than one at a time. Can anyone help? Thanks!

thanks jonsjava, well don't I feel like an idiot! I didn't know that xampp puts all test stuff into its own directory (different from my own site directory). So I deleted THAT, and problem solved. Much appreciated!

I am testing code on a test server (Apache, with xampp) using the simplexml_load_file function, but cannot test the same code with a different xml file. I keep getting the error message "Warning: simplexml_load_file() [function.simplexml-load-file]: I/O warning : failed to load external entity". I tried removing the original xml file (file.xml) entirely from the original directory, but it still won't let me test the code with another xml file in the same directory. Meanwhile, the code continues to successfully execute when I put the original filename into the expression (i.e., simplexml_load_file('file.xml') -- even though I have deleted file.xml and it no longer exists on my computer. Anybody have an idea what's going on?