PHP Help

TMoore

Hi!

I need help, im trying to display a list of links from a MySQL Database using a left join and using an if statement it either displays the name of the link without a hyperlink or the text with a hyperlink.

But i when i try the code i get an error.

Please have a look and any help would be great!

Code:

<?php require_once('file:///C|/Documents%20and%20Settings/Administrator/My%20Documents/PeteWebsite/Connections/pweb.php'); ?>
<?php
$maxRows_rsLinks = 10;
$pageNum_rsLinks = 0;
if (isset($HTTP_GET_VARS['pageNum_rsLinks'])) {
  $pageNum_rsLinks = $HTTP_GET_VARS['pageNum_rsLinks'];
}
$startRow_rsLinks = $pageNum_rsLinks * $maxRows_rsLinks;

mysql_select_db($database_pweb, $pweb);
$query_rsLinks = "SELECT links.link, link_ref.URI FROM links LEFT JOIN link_ref ON links.link_id = link_ref.link_id ORDER BY links.link DESC";
$query_limit_rsLinks = sprintf("%s LIMIT %d, %d", $query_rsLinks, $startRow_rsLinks, $maxRows_rsLinks);
$rsLinks = mysql_query($query_limit_rsLinks, $pweb) or die(mysql_error());
$row_rsLinks = mysql_fetch_assoc($rsLinks);

if (isset($HTTP_GET_VARS['totalRows_rsLinks'])) {
  $totalRows_rsLinks = $HTTP_GET_VARS['totalRows_rsLinks'];
} else {
  $all_rsLinks = mysql_query($query_rsLinks);
  $totalRows_rsLinks = mysql_num_rows($all_rsLinks);
}
$totalPages_rsLinks = ceil($totalRows_rsLinks/$maxRows_rsLinks)-1;
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php do { ?>
<?php if ($row_rsLinks['URI']='') ?>
<?php { echo $row_rsLinks['link']; }?><br>
<?php else {echo '<a href="$row_rsLinks['URI']" $row_rsLinks['link'] </a>'} ?> 
<?php } while ($row_rsLinks = mysql_fetch_assoc($rsLinks)); ?>
<?php mysql_free_result($rsLinks); ?>

Thanks

Tom

godwheel

Could you post the error?

Skull

<?php else {echo '<a href="$row_rsLinks['URI']" $row_rsLinks['link'] </a>'} ?>

that looks like the problem to me

change it to

<?php else {echo '<a href="'.$row_rsLinks['URI'].'" '.$row_rsLinks['link'].' </a>';} ?>

also

<?php require_once('file:///C|/Documents%20and%20Settings/Administrator/My%20Documents/PeteWebsite/Connections/pweb.php'); ?>

don't include files from your computer, as it wont work on other peoples computers. Include files from the webserver instead (unless of course it's only ever being run off of your computer)

TMoore

Thanks ill try that!

The error i received was unexpected T_ELSE.

I did use the right syntax for the if else statement didnt I?

Tom

Skull

what line was it on?