[RESOLVED] Adding To Array BEFORE While Loop

fotofx

I have a query from mysql. I want to add 1 value to the query so it will be contained within the while loop. However the array does not exist until the while loop... right??

while ($row = mysql_fetch_array($result, MYSQL_NUM)) { }

I would want the extra value in the $row

Any thoughts???

Thanks

bradgrafelman

Can you explain a little more about what 'value' you're trying to add and for what purpose?

fotofx

The query only has $row[0] and $row[1] with about 1000 rows. I need to insert a row with $row[0] being "9999" and $row[1] being "0"

This query is used to create several other queries on different databases. One of the other databases has the "9999" and without the value I will not get the proper result back from the other database.

These other databases are spread across different servers.

bradgrafelman

I guess I still don't understand what your while() loop is doing versus what you need to do additionally. For example, I don't see why you can't just do:

while(loop through DB results)
{
    do_something_with(col0, col1);
}

do_something_with(9999, 0)

fotofx

The loop is a whole bunch of stuff that is done repeatedly for each item in the row. I need to do that process on the 9999 row. If I include it within the while it would repeat. If outside the while I would have to duplicate this long process.

bradgrafelman

It seems like a horrible kludge to me, but without knowing more about the process here I would say there is at least one solution - include the values in the rows returned. You can use a UNION clause (or clauses) to insert 'fake' rows into the result set (before or after it), e.g.

SELECT 9999, 0
UNION
SELECT foo, foo2 FROM myTable

fotofx

I didn't really think about using a UNION... I guess it would work but I would need a dummy table right??

bradgrafelman

fotofx wrote:
I guess it would work but I would need a dummy table right??

Why do you say that? (Hint: The answer is no.)

fotofx

OK, I give up... :o

How do I do it without a dummy table?

bradgrafelman

See my post above...

bradgrafelman;10981839 wrote:
SELECT 9999, 0
UNION
SELECT foo, foo2 FROM myTable

fotofx

Isn't myTable a dummy table??? Where is it coming from??

fotofx

Duhhhh... wait... I just reread it.. I will give it a try..

Thanks

fotofx

It worked kind of... The problem now is it changed the names of each column.

So instead of $row[0] and $row[1] I now have $row[9999] and $row[0]

How do I get around this????

fotofx

I answered it myself from the manual...

"The column names from the first SELECT statement are used as the column names for the results returned. Selected columns listed in corresponding positions of each SELECT statement should have the same data type."

I just put the union after and it worked fine..

Thanks again..