[nivram2880@yahoo.com]

I just want to know if theres something error with my code.. i need to view individual record from my database MySql... when i look in to ineternet there has no error shown in homepage but it shown nothing mean while my home page is empty...click here and below is my code:

nivram2880@yahoo.com

Thank You


<?
$DB_USER="a2156109_123";
$DB_PASS="12345678";
$DB_NAME="a2156109_ddb";
$DB_SERVER="mysql1.000webhost.com";

mysql_connect($DB_SERVER,$DB_USER,$DB_PASS);
@mysql_select_db($DB_NAME) or die( "Unable to select database");
$query="SELECT * FROM users WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$first=mysql_result($result,$i,"title");
$last=mysql_result($result,$i,"autor");
$phone=mysql_result($result,$i,"artist");

?>

[Red-X]

you have to give $id a value. I guess the id is traveling in the url so just add $id = $_GET["id"];

[nivram2880@yahoo.com]

Actually that was my previous code in my old site and it works so well.. is there something code that requied to put or what ever to configure in phpmyadmin?

[nivram2880@yahoo.com]

here is the url named iframe.php the text that show there are from database it will shown and there has a link to get there record.

[Red-X]

Actually that was my previous code in my old site and it works so well

So where is the new code? Can you post it?

[nivram2880@yahoo.com]

Here is the new code same as aboveand same as of my old code i've only changes the info of this:

$DB_USER="a2156109_123";
$DB_PASS="12345678";
$DB_NAME="a2156109_ddb";
$DB_SERVER="mysql1.000webhost.com";


<?
$DB_USER="a2156109_123";
$DB_PASS="12345678";
$DB_NAME="a2156109_ddb";
$DB_SERVER="mysql1.000webhost.com";

mysql_connect($DB_SERVER,$DB_USER,$DB_PASS);
@mysql_select_db($DB_NAME) or die( "Unable to select database");
$query="SELECT * FROM users WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$first=mysql_result($result,$i,"title");
$last=mysql_result($result,$i,"autor");
$phone=mysql_result($result,$i,"artist");

?>

[Bad Karma[CORE]]

i might have eyes as sharp as a gopher, but where is $id defined, respectively where does it get its value from ?

[Red-X]

Originally Posted by Bad Karma[CORE]

i might have eyes as sharp as a gopher, but where is $id defined, respectively where does it get its value from ?

Right, I have the same question here.

[Bad Karma[CORE]]

well, it could work if the URL that triggers the query would pass on the members id, like
http://blahhhhh.com/bleh/member.php?id=3 or something

This part of the code breaks the query:

PHP Code:

WHERE id='$id'"; 


[Red-X]

Right he needs to add $_GET["id"]; in top of this $query="SELECT * FROM users WHERE id='$id'";