Thread: Adding Sub Array
View Single Post
  #5  
Old 01-13-2013, 02:51 AM
fowlplay4 fowlplay4 is offline
team canada
fowlplay4's Avatar
Join Date: Jul 2004
Location: Canada
Posts: 5,200
fowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond repute
Use the rows from the SQL result.

PHP Code:
temp.data = req("your sql query");
for (temp.row: temp.data.rows) {
  temp.ids.add(temp.row.rowid);
}
echo(temp.ids); 
Also escape/validate your params in the SQL query. I.e: escapestring2(params[1]) or for numbers int(params[1]) or float(params[1]).
__________________
Quote:
Reply With Quote