Table Column w/same database field?

IDontKnow

Is it possible to create a table that has multiple columns with the same field from a database?

I tried:

but it just lists the same information in both columns. Any help or a point to a tutorial would be extremely appreciated!

Thanks in advance....

Mada

cgraz

Are you trying to make two columns that each output the same database field while still getting a different value within each column?

If so, I used a tutorial from spoono That alternates row colors, and use the same principle. So basically every other row the code alternates. On even rows it starts a tr tag and doesn't end it, on odd rows it doesn't start with a tr but ends with a tr. I don't know how well this will work, it hasn't been tested and was just a stab in the dark, but hopefully it will atleast get you going.

<table width="400">

<?

// Connect to MySQL 
mysql_connect ('localhost', 'username', 'password') ;
mysql_select_db ('dbname'); 

$result = mysql_query (SELECT * FROM table); 

if ($row = mysql_fetch_array($result)) { 
    for ($i = 0; i < count($row); $i++) { 
         if ($i % 2) { 
             echo "<tr><td width='200' style='border:double 1px solid #000000'><a href='" . $row[Font_URL] . $row[Name] . "'>" . $row[Font_Name] . "</a></td>\n"; 
         } else { 
             echo "<td width='200' style='border:double 1px solid #000000'><a href='" . $row[Font_URL] . $row[Name] . "'>" . $row[Font_Name] . "</a></td></tr>\n";
         } 
    }

 }  

?>

</table>

Let me know how that works.

Cgraz

IDontKnow

I can see the concept here and why it should work, but it just repeats the first entry for the number of entries in the database.

By the way, it timed out. Is there a way to limit the numbers and then have automatic links at the bottom?

Thanks for your time!

Mada

cgraz

I thought you just wanted all the results from one field in your database repeated in a two column format. Show me an example of what you want your output to look like.

As for limiting the results, use LIMIT()

I posted commented code on how to do this here: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10219415

Cgraz

IDontKnow

Thanks for your patience. Here's what the code you sent did...

font1 font1
font1 font1

I want

font1 font2
font3 font4

IDontKnow

I'm thinking that I need to query twice. Once to get the count, the second time to get the info. Here's what I came up with, but it doesn't work either.

//Get the Count
$query_count = "SELECT count(*) FROM one";
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count); 

//Get the info
$query = "SELECT * FROM one";
$result = mysql_query($query) or die("Error: " . mysql_error()); 

// Bring the 2 together
if_($row_=_mysql_fetch_array($totalrows.result))_{_
	for_($i_=_0;_i_<_count($row);_$i++)_{_
		if_($i_%_2)_{_
echo_"<tr><td width='200' style='border:double 1px solid #000000'><a href='"_._$row[Font_URL]_._$row[Name]_._"'>"_._$row[Font_Name]_._"</a></td>\n";_
	}_else_{_
	echo_"<td width='200' style='border:double 1px solid #000000'><a href='"_._$row[Font_URL]_._$row[Name]_._"'>"_._$row[Font_Name]_._"</a></td></tr>\n";
	}_
     }

cgraz

Found this and thought of you 😉

http://codewalkers.com/tutorials.php?show=15

Keep hitting next, I think it's the last page that has what you're looking for.

Cgraz

IDontKnow

Thank you so much! I am bouncing in my seat.

Thanks again.

Mada