[SOLVED] how i inserted table

[saad|_d3vil]

i have another table in my sql database the table name is albums now how i inserted table when some on click on this url http://www.apnimuskaan.com/sadasdas.php?id=1 my php code is this

 

<?php
$con = mysql_connect("localhost","apnimusk","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("apnimusk_naat", $con);

// check to see if id is set
if(isset($_GET['id']) && is_numeric($_GET['id']))
{
    echo 'Your have requested ID #'.$GET['id'].'<br />';
    echo '<a href="sadasdas.php">Back</a>';
}
// no id requested, display results
else
{

$result = mysql_query("SELECT * FROM album
WHERE name='Timmy Mellowman'");

while($row = mysql_fetch_array($result))
  {
  echo $row['name'] . " " . "<a href='?id=".$row['id']."'>".$row['age']."</a>";
  echo "<br />";
  }
}
mysql_close($con);
?>

 

[revraz]

You need to clarify your question.

[saad|_d3vil]

see this site http://www.apnimuskaan.com/sadasdas.php there is a sql database table

[joquius]

This is a repost man.

 

Stop using [/url].

 

if (isset ($_GET['id']) && is_numeric ($_GET['id']))

{

  $id = mysql_real_escape_string ($_GET['id']); // paranoia

 

  $sql = "SELECT * FROM album

            WHERE id=".mysql_real_escape_string ($id);

}

 

Dunno if this is what you need.

[DarkWater]

I wish that I had any idea what you're asking. D:

 

@joquius: The forum is buggy.  It automatically changes </a> to [/url] when doing links. >_>

[revraz]

You need to use CODE tags if you use HTML in your post.

[saad|_d3vil]

php_b34t can you help me here here is my php code

[revraz]

I don't think anyone knows what you are asking.

[saad|_d3vil]

why is i am telling wroung ? php_b34t was trying to tell me but my last topic was locked

[php_b34st]

I agree with revraz, as far as i can gather from the last post you are already using the get function like i suggested now all u need to do is use that variable to grab the data from the second table

[saad|_d3vil]

what is variable

[php_b34st]

I think you need something like this:

<?php
$con = mysql_connect("localhost","apnimusk","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("apnimusk_naat", $con);

// check to see if id is set
if(isset($_GET['id']) && is_numeric($_GET['id']))
{
$id = $GET['id'];
echo 'Your have requested ID #'.$id.'';
echo '<a href="sadasdas.php">Back[/url]';
$result = mysql_query("SELECT * FROM table2
    		       WHERE id=$id");
while($row = mysql_fetch_array($result))
{
	echo $row['row1'];
	echo $row['row2'];
}

}
// no id requested, display results
else
{

$result = mysql_query("SELECT * FROM album
WHERE name='Timmy Mellowman'");

while($row = mysql_fetch_array($result))
  {
  echo $row['name'] . " " . "<a href='?id=".$row['id']."'>".$row['age']."[/url]";
  echo "
";
  }
}
mysql_close($con);
?>

 

but without knowing the structure of your second table I cannot help any further

[saad|_d3vil]

thank you very much thank you all