Wraping columns?

Anon

Not sure if I am stating this right, I have a movie db, and it is listed by name, what I want to do is break it up by first letter, and get it to wrap into 2 columns

Here is the link to the db
http://www.4-petes-sake.com/movie_list.php

Here is the old static page (and the way I want it to look)
http://www.4-petes-sake.com/movies.php

Now if anyone knows where I could find a tutorial or somthing that would point me in the right direction that would be a huge help.

Also I want to be able to search the db also, but that is another battle.

Anon

when looping through the records, you need to insert some logic like so:

if the first letter != the first letter of the last entry {
go to new DIV tag or something
} else {
continue listing
}

for the two column effect, you need to use logic like:

$col=1;
print ("<TR>")
loop {
print "<TD>".$item."</TD>";
$col++;
if ($col>2) {
print "</TR><TR>";
$col=1;
}
} // end loop
print ("</TR>");

Anon

Thank you Craig, I am trying to incorporate your loop function in, but I keep getting a parse error on this line

loop {

This is the code that I pull the list data with.

// show movie list

$result = mysql_query("SELECT * FROM main_movie",$db);
if ($myrow = mysql_fetch_array($result))

{
do {
printf("<a href=javascript:openWin(\"%s?id=%s\",400,400) CLASS=link3>%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["prefix"], $myrow["movie"]);

}
while ($myrow = mysql_fetch_array($result));
} else {
echo "Sorry, no records were found!";
}
}

I am not sure what I am doing wrong? I put this part in the place of the .item. section on your code.

Anon

heh heh....

sorry - apparently I assumed you knew more than you do. The "loop" is just a general term and not actual code. You need to replace the loop with the "while" loop you are probably using to loop through your resultset of your database call.

If this isn't clear, keep in touch and we'll get it straightend out! :-)

Anon

Ahh that is what I thought, let me try it again, I hit google looking for loop and found the while 'tag', and your right all I know is some basics I have picked up from a book "php and mysql web development" if you have a decent starter book that you know of let me know!

Thanks again for all your help, sorry I am a newbie.

Anon

No problems being a newbie - we have all been there at one time. Everything I know, I have learned through trial and error and research on the Web. This site and other developer sites like YAPF (http://www.hvt-automation.nl/yapf/index.php) and Devshed(http://www.devshed.com/) are great resources as is Google.

Anon

All right...hmm

I have this...

$result = mysql_query("SELECT * FROM main_movie",$db);
if ($myrow = mysql_fetch_array($result))

{
// display list if there are records to display
do {
$col=1;
print ("<TR>")
while {
print "<TD>".
printf("<a href=javascript:openWin(\"%s?id=%s\",400,400) CLASS=link3>%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["prefix"], $myrow["movie"])."</TD>";
$col++;
if ($col>2) {
print "</TR><TR>";
$col=1;
}
} // end loop
print ("</TR>");
}

while ($myrow = mysql_fetch_array($result));

} else {
// no records to display
echo "Sorry, no records were found!";
}
}

Now do I have to have a value for the while statment? While (somthing) ?
Or should I just stick to the HTML version of this movie DB I already have!

Anon

GRAIG I GOT IT TO WORK! You rock!!
Thank you so much for all your help!

When I get the whole thing done I will have to show you! Thanks again!

No on to the sorting by letter! hehe

Here is the test I got to work!
http://4-petes-sake.com/test.php

Anon

glad to hear it! to sort, look up ORDER BY in the mysql manual (www.mysql.com)

craig

Anon

I got the order by all set, now I am trying to work on this code you gave me

if the first letter != the first letter of the last entry {
go to new DIV tag or something
} else {
continue listing
}

I think I understand the logic of it, just having a hard time implementing it..

Anon

look up substr() in the manual: php.net