[Resolved] SELECT * (but not a few specific columns)

vaaaska

I need to query a table to get all of a rows information but I want to exclude a few rows from the query.

It's not really possible to call up the columns specifically because over time they will change - so instead of calling specific ones I need to just exclude some of them.

I can't find anything in the manual about this...it must be possible. I hope...

leatherback

Hi,

If there are no criteria to in or exclude.. It becomes dificult. WOuld this mean you would change the PhP file every time?

Anyway... What you could do is..

Select all records

Have an array with the record ID's which should not be shown

While retrieving the records from the results, you verify the record ID against the non-permitted array of numbers

vaaaska

Originally posted by leatherback
If there are no criteria to in or exclude.. It becomes dificult. WOuld this mean you would change the PhP file every time?

While retrieving the records from the results, you verify the record ID against the non-permitted array of numbers

I'm not sure if I'm following you...first of all, the point of this is so that the query never needs to be updated. It would simply ignore the few columns that deal with ID type things...

Secondly, I should have specified it only grabs one row...so comparing ID's would be unnecessary. By going backwards I'm locking out all the extraneous info...

I believe I've seen people play with *wildcard selectors and perhaps that might be the way to go...but it's sort of a pain at this point to go back and rewrite some things...

SELECT thing_* FROM table...etc...

Edit: except I'm not sure that this works...hmmm...

void_function

Originally posted by vaaaska
I need to query a table to get all of a rows information but I want to exclude a few rows from the query.

What's wrong with the WHERE clause?

Originally posted by vaaaska
It's not really possible to call up the columns specifically because over time they will change - so instead of calling specific ones I need to just exclude some of them.

I don't see a point in this. If you, at any moment in your code, know which columns are in your table, simply call those columns in your query. Otherwise call everything and deal with specific columns via names or fetch_array and reference them by numbers (remember that column order in mysql tables counts!)

Hope this helps. 🙂

vaaaska

Originally posted by void_function
I don't see a point in this. If you, at any moment in your code, know which columns are in your table, simply call those columns in your query. Otherwise call everything and deal with specific columns via names or fetch_array and reference them by numbers (remember that column order in mysql tables counts!)

Nope...there is a point.

Over time more columns will be added. The point is to not go back in and hand code anything. For a very specific part of things, a critical part, I need to query this table for all of its contents (in one row). I can't reference things via numbers...because there will be more...

However, I can unset parts of the array once I have it. Not elegant, but it solves the problem.

leatherback

hope this sheds some light...

   $yesarray = array(1);     

    $noarray = array(-1,0);     

    $showabstractarray = array("A_id","A_participantnr","A_name","A_oldname","A_authors","A_titel","A_size","A_type","A_date","A_text");
    $results = mysql_query($query) or die('Geen gegevens beschikbaar');

  while($row=mysql_fetch_array($results))
    {
    $row2 = $row;
    $header = "";
     while (list ($key, $val) = each ($row2)) 
      {
        if(!in_array($key, $showabstractarray))
        { }
        else
        {
        $printval = $val;
        $header .= $key."|";
        $data .= "$printval|";
        }
      }
     $data .="\r\n";    
    }