What I am trying to do is link my gallery and blogs on here, so I need to some how in the database insert a link to that I can click on the images to go a specific page.


ADDED: ALSO I need to format the dates on here, I am using Date in the database and I can not figure out how to format it to (ex. 10-21-2010)

This is the page
http://lettersfromlegends.com/node/3

this is what I have now

PHP Code:

$result = mysql_query("SELECT * FROM Basketball ORDER BY DateReceived")
or die(mysql_error());  

echo "<table border='0'>";
echo "<tr> <th>Player's Name</th> <th>Date Sent</th> <th>Date Received</th><th>Sent</th> <th>Recieved</th> <th>Letter</th><th>Photo</th> <th>Blog</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['FirstName'] . " " . $row['LastName'];
    echo "</center></td><td><center>"; 
    echo $row['DateSent'];
    echo "</center></td><td><center>";
    echo $row['DateReceived'];
    echo "</center></td><td><center>";
    echo $row['ItemsSent'];
    echo "</center></td><td><center>";
    echo $row['ItemsReceived'];
    echo "</center></td><td><center>";
    echo $row['Letter'];
    echo "</center></td><td><center>";
    echo $row['Photo'];
echo '<img src="http://www.lettersfromlegends.com/misc/ico_photo.gif" width="30" height="26" />';
    echo "</center></td><td><center>";
    echo $row['Blog'];
echo '<img src="http://www.lettersfromlegends.com/misc/blog.jpg" width="28" height="24" />';
    echo "</center></td></tr>"; 
    

} 

echo "</table>";


?> 


I'm sorry I didn't understand what do you want to do. I would help you,I'm waiting for your reply.

Regards.

Goto http://lettersfromlegends.com/node/3

1) I need to format the date so it shows 10-22-2010, the date is coming from a MySQL database using the Date function.

2) For each database entry there will be a separate blog post, photo and letter as you can see on the page their are the 3 images. I need put different links on each of those images and I was wondering if there is a easy way of doing that in MySQL. If not I can always insert <a href="http://www.sgsdgs.com/"> in to each mysql field

Originally Posted by NYChaoS

Goto http://lettersfromlegends.com/node/3

1) I need to format the date so it shows 10-22-2010, the date is coming from a MySQL database using the Date function.

2) For each database entry there will be a separate blog post, photo and letter as you can see on the page their are the 3 images. I need put different links on each of those images and I was wondering if there is a easy way of doing that in MySQL. If not I can always insert <a href="http://www.sgsdgs.com/"> in to each mysql field

1) So for the date format you have to redefine the function in this way:

PHP Code:

date("m/d/Y"); 


nothe the format m/d/Y is the key to show it as "10-22-2010" ...

2) For every player name you have to create also the fields for letter, blog and photo url... in your mysql database.

feel free to ask other explantions

as far as the date goes how do i change it, its not a columntype option in MySQL so what query would i type in there to change it?

Probably you mean something like this?

PHP Code:

$today = date("Y-m-d");
mysql_query("UPDATE Basketball SET DateField = '$today' WHERE ... ");