List all items in a SQL table?

[Gunderak]

I have been working on a support system where users can enter in a question for staff to answer about the server, my question is, how can I list all the rows in a table?
Would it be possible using a scroll as a container and a text list?
something maybe even to get all rows SELECT * FROM Support then a for loop with like

PHP Code:

with(Text_List){
  for(temp.indx = 0; temp.indx < this.data.size(); temp.indx ++){
    addrow(indx, data[indx]);
  }
} 


Maybe a better question is how would I add it all to an array?

[cbk1994]

It sounds like you don't have a good understanding of SQL concepts. You should try reading some tutorials for SQLite or even MySQL online. Unlike what you've been doing thus far, SQL is very easy to do terribly and horribly wrong if you're just copying and pasting from examples you've found/are given.

PHP Code:

temp.req = requestSQL("SELECT * FROM table", true);
temp.rows = temp.req.rows;

for (temp.row : temp.rows) {
  // you can access data via temp.row[0], temp.row[1], etc...
  // or with the column name like temp.row.submitter, temp.row.title, ...
  // 
  // the latter is preferred
  echo("Row: " @ temp.row);
} 


Obviously you can only do this serverside so you will have to send it to the client just like you'd send any other data.

[Gunderak]

I have read some things and understand how to use SQLite, it's rather easy.
W3 schools had a good example which I learnt most of it from.
But I was just unsure on how to get all the rows.
And I take it with you're example you'd send it to the client then do a for loop and then just get like temp.rows.size and add rows into a text list?
Thanks!

And the only really thing I think I'm doing wrong is where it has like var char null by default and crap like that.

[cbk1994]

Originally Posted by Gunderak

I have read some things and understand how to use SQLite, it's rather easy.
W3 schools had a good example which I learnt most of it from.
But I was just unsure on how to get all the rows.
And I take it with you're example you'd send it to the client then do a for loop and then just get like temp.rows.size and add rows into a text list?
Thanks!

It's just an array of rows, you would probably want to display each row with GuiTextListCtrl.addRow by looping through them.

And the only really thing I think I'm doing wrong is where it has like var char null by default and crap like that.

SQLite doesn't use VARCHAR, you should just use TEXT.

[ffcmike]

Originally Posted by Gunderak

PHP Code:

with(Text_List){
  for(temp.indx = 0; temp.indx < this.data.size(); temp.indx ++){
    addrow(indx, data[indx]);
  }
} 


It's a bad practise looping through an array which can not change its value mid loop while using .size(), especially if it's a large array such as can be expected from an SQLite table, this can create a lot of overhead.

[Gunderak]

On a related note, I have made a system now, but I want to replace a value.
insert into etc isn't replacing it at all and I don't know how delete works or drop.
Can anyone possible help?

[Tolnaftate2004]

Originally Posted by Gunderak

On a related note, I have made a system now, but I want to replace a value.
insert into etc isn't replacing it at all and I don't know how delete works or drop.
Can anyone possible help?

You're gonna want to use UPDATE.

[Gunderak]

Thanks, Looking into it now.

[scriptless]

You might also want to escape any user entered text. So as to not allow for SQL Injections.