Scott Phelps wrote:
Thanks in advance for reading this:
I am trying to take a query based on user input and selectively output
fields to a table.
Heres the query code:
snip - snip
$query_result = mysql_query($query);
while ($field = mysql_fetch_array($query_result))
{
This is an great aproach to solve your problem but i suggest some things to
obtain an better performance on your apps.
See my comments bellow
On Wednesday 25 February 2004 14:24, Justin Patrin wrote:
Scott Phelps wrote:
Thanks in advance for reading this:
I am trying to take a query
On Wed, 25 Feb 2004 14:56:53 -0400
Luis M Morales C [EMAIL PROTECTED] wrote:
Thank you so much Justin and Luis. You guys are awesome.
You both helped me tremendously!
BTW, I figured out a way to make the tables show the $value results in alternating
colors.
I just use a bitwise AND to test
Sorry, I didn't cut that right:
Here it is:
table class=results_inner
?php
foreach ($returned_rows as $key = $value)
{
if ($key 1)
{
echo trtd class='results_blue'.$value['lastname'].,
.$value[firstname]./td/trbr;
;-)
table class=results_inner
?php
foreach ($returned_rows as $key = $value)
{
echo trtd class='.
($key 1 ? 'results_blue' : 'results_white').'.
$value['lastname'].,
.$value[firstname]./td/trbr;
}
X-Mailer: Sylpheed version 0.9.8claws (GTK+ 1.2.10; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
On Wed, 25 Feb 2004 15:39:17 -0800
Justin Patrin [EMAIL PROTECTED] wrote:
;-)
table class=results_inner
?php