<a href> within php echo

[dan90joe]

Hi there,

I'm working on a gig listings page which i've at the minute got working with the following code...

$result = mysql_query("SELECT * FROM Guests WHERE Date>=CURDATE() ORDER BY Date LIMIT 6");

while($row = mysql_fetch_array($result))
  {

echo"<table width='720' border='0' align='center'><tr>";
echo '<td><span class="first"><strong>'.date('jS F Y', strtotime($row['Date'])).'</strong></td>';
echo"<td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
              </tr>
              <tr>";
echo"<td width='280'><span class='first'>" . $row['Name'] . "</span></td>";
echo"<td width='5'>&nbsp;</td>";
echo"<td width='54'>" . $row['Time'] . "</td>";
echo"<td width='5'>&nbsp;</td>";
echo"<td width='337'>&pound;" . $row['CostAdv'] . " adv / &pound;" . $row['CostDoor'] . " door</td>";
echo"<td width='139'>More Details</td>";
echo"</tr>
              <tr>
              </tr>
              <tr>
</tr>
              <tr>
                <td height='30' colspan='6'><center>_____________________________________________________________________________________</center></td>
              </tr>
            </table>";

  }

Where it says "More Details" i want this to be a URL to another page which shows more information about that specific artist. Each row in the database contains the information about the artist, including an incrementing ID number. I presumed that i could use this ID number to load the information into the other page.

First off, i have no idea how to put a <a href> link into the echo code, most of my attempts have come up with errors talking about " and 's being in the wrong place.

Secondly, anybody know about how i would go about calling the URL to show the added information?

I know i sound a bit vague but hopefully someone will be able to help.

Thanks,
Dan

[dagon]

dan90joe;10933875 wrote:

First off, i have no idea how to put a <a href> link into the echo code, most of my attempts have come up with errors talking about " and 's being in the wrong place.

This page will explain the issues you may be having with single and double quotes:
Strings

[dan90joe]

i remember reading somewhere that you should only stick to one set of quoting... you reckon this is the problem that i'm having?

[big_nerd]

dan90joe,

You can use any mix method of quoting, each has its advantages, some say to stick to single quotes unless you need inline variable processing.

I believe if you look up on how to escape quotes, you will see what dagon was talking about.

echo"<td width='139'>More Details</td>";  // 1
echo"<td width='139'><a href='http://www.google.ca'>More Details</a></td>";  // 2
echo"<td width='139'><a href=\"http://www.google.ca\">More Details</a></td>";  // 3
// below is 4
echo <<<EOL
<td width='139'><a href="http://www.google.ca">More Details</a></td>
<td width='139'><a href='http://www.google.ca'>More Details</a></td>
EOL;

If you read the strings page it will explain why I setup each of the examples.

If you try adding the link info but stil get an error, post what you are TRYING to do and what the exact error is.

[dan90joe]

Thank you to both big.nerd and dagon... Now that i understand what i'm doing with my quotes, I've managed to do exactly what I wanted to do and also sorted out calling the data back into a different page using a url with a ?id=1 sort of thing.

Learning more and more about PHP every day!