Any Help?

Hactar

<?php

$idvar=$_GET['id'];

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

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 #<? echo ($idvar) ?></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="<?php echo ($image) ?>" ><br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top;">By <?php echo ($author) ?><br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top; height: 40%;"><?php echo ($description) ?><br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top;"><?php echo ($download) ?><br>
      </td>
    </tr>
  </tbody>
</table>
<br>
</body>
</html>

Can anyone help me with how to select the right bits from the Database?

I have it selecting the right row (I think) but how do you get it to get the values of other things on the row where id equals 2 or whatever?

Cheers

Hactar

sumathi

You have eecuted the query. Next you have to store the fetched row in a variable. Then u can proceed as follows...

<?php

$idvar=$_GET['id'];

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

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

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

mysql_close();

echo ($result) ;

<html>
<head>
<meta http-equiv="content-type"
content="text/html; charset=ISO-8859-1">
<title>Viewing Mod #<? echo ($idvar) ?></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="<?php echo $row['image'] ?>" ><br>
</td>
</tr>
<tr>
<td style="vertical-align: top;">By <?php $row['author'] ?><br>
</td>
</tr>
<tr>
<td style="vertical-align: top; height: 40%;"><?php $row['description'] ?><br>
</td>
</tr>
<tr>
<td style="vertical-align: top;"><?php $row['download'] ?><br>
</td>
</tr>
</tbody>
</table>
<br>
</body>
</html>

Any more doubts...always welcome...
Sumathi.

Hactar

Thanks, but now I get this error🙁

"Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [page path] on line 15"

Cheers

Hactar

Oh and just another question, what would you get if you did something like

$namevar=$_GET['name']

But you never put a ?name=42 or something in the URL? would $namevar return 0 or false?

Cheers

Hactar