Re: [PHP-DB] Please help!

[phpnet]

you do not need a counter, just use a 2 column table


| Thats my code!
| 
| What I want to be able to do is have it so instead of one column there are 
| two columns of pictures:
| 
| 
| pic1      |     pic2
| pic3      |     pic4
| 
| etc..
| 
| 
| How can I do this?
| 
| Thanks in advance!
| 
| 
| 
| 
| <?php
| 
| $mysql_access = mysql_connect("********", "******", "*********");
| mysql_select_db("*********", $mysql_access);
| 
| $query = "SELECT * FROM Pictures";
| $result = mysql_query($query, $mysql_access);
| 
| if(mysql_num_rows($result)) {
|   $counter = 0;
|     while($row = mysql_fetch_row($result)) {
| 
| printf("<a href=\"http://www.charmed-guide.com/pictures/$row[2].jpg\"; 
| target=_blank>\n");
| printf("<img src=\"http://www.charmed-guide.com/pictures/$row[2]_th.jpg\"; 
| border=0>\n");
| printf("</a><p>\n");
| 
| $counter++;
| }
| 
| }
| ?>
| 
| _________________________________________________________________
| Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
| 
| 
| -- 
| PHP Database Mailing List (http://www.php.net/)
| To unsubscribe, e-mail: [EMAIL PROTECTED]
| For additional commands, e-mail: [EMAIL PROTECTED]
| To contact the list administrators, e-mail: [EMAIL PROTECTED]
| 
| 

[EMAIL PROTECTED]

SeaPortNetHosting: Reliable Web Hosting
Plans from $17.95 www.yourname.com
http://www.SeaPortNet.com/
1(209)551-7028 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]