Appending data to result of a query

yoki32

Hi,

OK, let's say I have this example as a query:

$query = "SELECT username, fullname, type FROM Users
HAVING Users.username LIKE '%".mysql_real_escape_string($find_string)."%' OR Users.fullname LIKE '%".mysql_real_escape_string($find_string)."%'";

$result = @($query);

I would like to modify the $result variable and add more data at the beginning of it. For example, I would need to add two columns [Edit]+[Delete].

I don't want to add these columns in mysql table, I want to be able to add them by hand coding it instead. Can someone help me out please?

Thank you 🙂

dagon

if i understand the question, this should work:

$query="SELECT '' as edit, '' as delete, username,fullname ...

itaym02

yoki32;10926207 wrote:
Hi,

OK, let's say I have this example as a query:

$query = "SELECT username, fullname, type FROM Users
HAVING Users.username LIKE '%".mysql_real_escape_string($find_string)."%' OR Users.fullname LIKE '%".mysql_real_escape_string($find_string)."%'";

$result = @($query);

I would like to modify the $result variable and add more data at the beginning of it. For example, I would need to add two columns [Edit]+[Delete].

I don't want to add these columns in mysql table, I want to be able to add them by hand coding it instead. Can someone help me out please?

Thank you 🙂

You got your answer above, but the real solution would be to add those when you extract/loop on the data from the result set. Event better, in some cases (extreme ones) I even do that with JS, AS I believe all you need from the server is the PK of the record.