Hi all, been reading many weeks now finding out how others have been helped, time i asked a few questions.... having a very blonde moment..
I have a selection of data in a MySQL Table which i would like to extract and specify a barcode font to print onto lables. The problem i have is i would like 2 cols of data per row.
0001 0002
id1 id2
0003 0004
id3 id4
how can i go about doing this... currently i have although on each row the ID changes however the colums do not follow suit i.e.
0001 0001
id1 id1
0002 0002
id2 id2
$query = "SELECT * FROM books";
$result = mysql_query($query);
print "<table border='1' cellpadding='10' bordercolor='#000000'><tr><td>Test</td><td>Test1</td></tr>";
while($row = mysql_fetch_array($result))
{
print "<tr><td class='text'><center><font face='code 3 de 9' size='300%'>";
echo "" . $row[0] . "";
print "</font><br>";
echo $row[0];
print "</td>";
print "<td class='text'>ISBN: ";
echo $row[1];
print "<br>Title: ";
echo $row[2];
print "<br>Author:";
echo $row[3];
print "</td></tr>";
}
?>
This im sure is a simple problem??
Thanks
