formatting the returned dataset

Anon

where could i begin learning how to change/format the html of the returned dataset? i just want to put all the results in a table and then change the font of the text. i don't know where to put the html tags within the print function?

thanks for your time.

<body>

<?php

mysql_connect (localhost, remeed, typethis);

mysql_select_db (remediation);

if ($apn == "")
{$apn = '%';}

if ($streetnum == "")
{$streetnum = '%';}

if ($street == "")
{$street = '%';}

if ($lastname == "")
{$lastname = '%';}

$result = mysql_query ("SELECT * FROM rembilling
WHERE apn LIKE '$apn%'
OR streetnum LIKE '$streetnum%'
OR street LIKE '$street%'
OR lastname LIKE '$lastname%'

");

if ($row = mysql_fetch_array($result)) {

do {
print $row["apn"];
print (" ");
print $row["streetnum"];
print (" ");
print $row["street"];
print (" ");
print $row["lastname"];
print ("");
} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

</body>

lucianoes

print ''."$row['apn']".'';

else {print 'Sorry, no records were found!;}

Got it?

    Luciano ES
    Santos, SP - Brasil

Anon

actually, i was talking about formatting the text that is returned by using html code within my php. you know- like putting the returned result in tables and then changing the color and style of font?

thanks.

lucianoes

That is exactly what I did. You just have to change to <td></td> or whatever suits your needs.

Anon

okay, sorry i missed that.

i tried, but it did not work.
got this error->
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /web/eww/remediation/dbase_pract/multi_query.php on line 33

the code::::::

<body>

<?php

mysql_connect (localhost, remeed, typethis);

mysql_select_db (remediation);

if ($apn == "")
{$apn = '%';}

if ($streetnum == "")
{$streetnum = '%';}

if ($street == "")
{$street = '%';}

if ($lastname == "")
{$lastname = '%';}

$result = mysql_query ("SELECT * FROM rembilling
WHERE apn LIKE '$apn%'
AND streetnum LIKE '$streetnum%'
AND street LIKE '$street%'
AND lastname LIKE '$lastname%'

");

if ($row = mysql_fetch_array($result)) {

do {
print ''."$row['apn']".'';
print $row["annualized"];
print (" ");
print $row["fee"];
print (" ");
print $row["streetnum"];
print (" ");
print $row["street"];
print (" ");
print $row["lastname"];
print ("");
} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

</body>

thanks for your time.

lucianoes

I don't know where exactly line 33 is, unless I can have the original file. My hunch is that there is something wrong with this line:

print ''."$row['apn']".'';

I have a problem with concatenation sequences, I always type something wrong. Try other variations like:

print ''."$row[apn]".'';

print "$row['apn']";

... or do the right thing, which I still haven't done: read the manual and learn how to concatenate correctly already! :-)

    Luciano ES
    Santos, SP - Brasil