Help?

Hactar

Can anyone help me with this?

<?

$idvar=$_GET['id'];

$username="[username]";
$password="[password]";
$database="[database]";
$localhost="[host here]";

mysql_connect($localhost,$username,$password);
@mysql_select_db($database);

$query=SELECT * FROM 'viewing_mod' WHERE id='$idvar'";
$result=mysql_query($query);

mysql_close();

echo ($result) ;

?>

<html>
<head>
  <meta http-equiv="content-type"
 content="text/html; charset=ISO-8859-1">
  <title>Viewing Mod</title>
</head>
<body style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 0);"
 link="#ff0000" vlink="#009900" alink="#ff6666">
<table cellpadding="2" cellspacing="2" border="1"
 style="margin-left: auto; margin-right: auto; height: 100%; width: 600px; text-align: center; background-color: rgb(0, 0, 70);">
  <tbody>
    <tr>
      <td style="vertical-align: top; height: 400px;"><img src="<? echo ($image) ?>" ><br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top;">By <? echo ($author) ?><br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top; height: 40%;"><? echo ($description) ?><br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top;"><? echo ($download) ?><br>
      </td>
    </tr>
  </tbody>
</table>
<br>
</body>
</html>

I get the error: "Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in [server pate] on line 13

drawmack

change:

<?php
$query=SELECT * FROM 'viewing_mod' WHERE id='$idvar'";
?>

to:

<?php
$query=SELECT * FROM 'viewing_mod' WHERE id='$idvar';
?>

devinemke

the error is pretty self-explanatory. the are missing an open quote on line 13:

$query=SELECT * FROM 'viewing_mod' WHERE id='$idvar'";

should be:

$query="SELECT * FROM 'viewing_mod' WHERE id='$idvar'";

Hactar

Thanks 🆒 🆒

I'd spent ages wondering what I had wrong, it all looks so obvious now :rolleyes:

Thanks again

Hactar

And while I'm here, how "user-specific" is a variable?
eg if I go to a php page and use a form to set $name to be bill then if a different person goes there then will $name still equal bill?

devinemke

Originally posted by Hactar
And while I'm here, how "user-specific" is a variable?
eg if I go to a php page and use a form to set $name to be bill then if a different person goes there then will $name still equal bill?

not unless both people are named bill 😉