Skip a Value in SQL?

JamesU2005 · 14 Dec 2006 at 12:54

Is it possible to skip a value in SQL and go onto the next one?

Hope this makes sense.

robmiller · 14 Dec 2006 at 13:09

That doesn't really make sense, no.

You mean when INSERTing? Just specify the values you actually want to add:

Code:

INSERT INTO foo
(bar, baz)
VALUES ("foibles", "lol")

That'll work regardless of whether foo has 2, 4 or 48 columns.

JamesU2005 · 14 Dec 2006 at 13:17

Thought it didn't make much sense.

What I am trying to do is on a webpage in php the following from my Access database.

I can get the values but not in the second column.

It just starts below the first column.

Like below:

robmiller · 14 Dec 2006 at 13:21

Code:

$result = mysql_query("SELECT * FROM foo");

$i = 0;
while ( $row = mysql_fetch_assoc($result) ) {
    echo $row['bar'];
    if ( ++$i % 2 == 0 )
        echo '<br />';
}

Change the markup to suit you obviously but that's the principle :k

toString · 14 Dec 2006 at 13:32

Out of interest how does $i increase? Is it something to do with mysql_fetch_assoc instead of _row or _array?

Berserker · 14 Dec 2006 at 14:05

It doesn't. There's a ++$i; missing from indside the while loop.

toString · 14 Dec 2006 at 14:29

Thought as much!

robmiller · 14 Dec 2006 at 14:43

Yes, I'm stupid