[RESOLVED] trying to return

melomonk

hello
i'm trying to return a query with four fields,
one row per line until all data is returned
i need to concatenate a URL to the first field only in each row/each line

end result being:
URL+Field1, Field2, Field3, Field4
URL+Field1, Field2, Field3, Field4
URL+Field1, Field2, Field3, Field4
URL+Field1, Field2, Field3, Field4

What I'm getting is one single row - nothing else

How do I repeat the row?

Code Used::

$rs = mysql_query("SELECT blah FROM blah") or die ("invalid query");

while ($row = mysql_fetch_assoc($rs)) {

printf ("field1: %s field2: %s field3: %s field4: %s", "http://URL?id="; . $row["field1"], $row["field2"], $row["field3"], $row["field4"] . "\n");
}

mysql_free_result($rs);

thanks

melomonk

so many views - no response

do i have bad breath?

Rodders

Can you run your query directly in the DB and check the results, maybe using phpMyAdmin or similar?

The code looks fine at first glance, so I can only assume that your query is only returning a single row?

melomonk

Rodders;10920991 wrote:
Can you run your query directly in the DB and check the results, maybe using phpMyAdmin or similar?

Thanks for looking

Yes the query runs fine - when i copy and paste the query into myadmin - the results are as expected - row after row until all data is returned

Rodders

All I can see just now is a syntax error. You need to change the printf line so that it doesn't have a semi-colon.

melomonk

$rs = mysql_query("SELECT blah FROM blah") or die ("invalid query");

while ($row = mysql_fetch_assoc($rs)) {

printf ("field1: %s field2: %s field3: %s field4: %s", "http://URL?id="[B][SIZE="7"]; [/SIZE][/B]. $row["field1"], $row["field2"], $row["field3"], $row["field4"] . "\n");
}

mysql_free_result($rs);

i see it - i dont know how that got there - sorry that's my pasting mistake
but it's not in code i'm running

Here is the URL with the results returned

Rodders

Aha, then I've spotted where your problem is.

What happens is that your While loop simply loops through the results and does what you tell it to inside. In this case, simply print a bit of text onto the page. However, your text doesn't include a carriage return so each line is simply appended to the end of the next.

Try this:

printf ("</br>field1: &#37;s field2: %s field3: %s field4: %s", "http://URL?id="[b][size="7"]; [/size][/b]. $row["field1"], $row["field2"], $row["field3"], $row["field4"] . "\n");

I've included a </br> at the start of each result row.

melomonk

Thank you so much for your time and attention

it worked

i got the desired results