[SOLVED] need help in php code

[saad|_d3vil]

1  1

1 2

1 3

1 7

1 8

this is my id filed ids now what i wrung in my coding

[wildteen88]

Change your code to

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

mysql_select_db("apnimusk_naat", $con);

$result = mysql_query("SELECT * FROM album");

while($row = mysql_fetch_assoc($result))
{
    echo "<pre>".print_r($row, true)."</pre>";
    echo $row['name'] . " " . $row['age'];
    echo "<a href='?id='".$row['id']."'>".$row['age']."</a><br />'";
}

mysql_close($con);
?>

And post the output here.

[saad|_d3vil]

Array

(

    [id] => 1

    [name] => Timmy Mellowman

    [age] => 23

)

 

Timmy Mellowman 2323

'

 

Array

(

    [id] => 2

    [name] => Sandy Smith

    [age] => 21

)

 

Sandy Smith 2121

'

 

Array

(

    [id] => 3

    [name] => Bobby Wallace

    [age] => 15

)

 

Bobby Wallace 1515

'

 

Array

(

    [id] => 7

    [name] =>

    [age] => 0

)

 

00

'

 

Array

(

    [id] => 8

    [name] =>

    [age] => 0

)

 

00

'

[wildteen88]

Change

echo "<a href='?id='".$row['id']."'>".$row['age']."</a><br />'";

to

echo '<a href="?id='.$row['id'].'">'.$row['age'].'</a><br />';

[saad|_d3vil]

now the link is changing but the page is not changing now what i want to do for change page i want to make new table?

[sasa]

can some explain me in detail please what i change in this code for makeing hyper link

echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";

remowe one ' after =

 

after click link in variable $_GET['id'] is value of id

[wildteen88]

You need to add more code to display a new page, eg

<?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");

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

mysql_close($con);
?>

[saad|_d3vil]

can some explain me in detail please what i change in this code for makeing hyper link

echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";

remowe one ' after =

 

after click link in variable $_GET['id'] is value of id

where i put this code

[wildteen88]

can some explain me in detail please what i change in this code for makeing hyper link

echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";

remowe one ' after =

 

after click link in variable $_GET['id'] is value of id

where i put this code

No need to do that, I have already fixed that.

[saad|_d3vil]

Your have requested ID #

Back

it is showing this

how i custom change each id 

[wildteen88]

Sorry made a mistake in my code

 echo 'Your have requested ID #'.$GET['id'].'<br />';

Needs to be

 echo 'Your have requested ID #'.$_GET['id'].'<br />';

[DeanWhitehouse]

I would advise you to read some PHP tutorials , and learn stuff. As we are not here to write all the code for you, and it helps you fix small errors like the one with the $_GET statement.

[saad|_d3vil]

now if i want to make my custom page for id how i can make?

[saad|_d3vil]

sorry i am realy sorry i disturb you again and again plz tell me this only plz now i will not ask on

[DeanWhitehouse]

http://www.tizag.com/phpT/

http://www.w3schools.com/PHP/

[wildteen88]

now if i want to make my custom page for id how i can make?

I have already have shown you! DO you understand any of the code used? If you dont then you should read the PHP manual.

[saad|_d3vil]

only tell me that what it call to change the page so i will learn in http://www.tizag.com/phpT/

[wildteen88]

What do you want to happen when the user clicks the link? You really are pushing your limit.

[saad|_d3vil]

ok bye sorry i disturb you all bye sorry again

[DeanWhitehouse]

If thats all , click solved.