Can't pass variable to the next page!!

russian_god

hi
have 2 scripts(index.php and view.php)
In index.php have a link
$id=1;
<a href=view.php?id=$id>Link</a>
Script view.php gets data from the table and diplays it depending on $id (doing query)
BUT WHAT I GET IS ONLY A BANK PAGE!!!!!
if u change the query(exapmle: id=1) in view.php it works but when query(id='$id')
IT doesnt....
please help me with that!!!

amcgrath

The problem's most likely in your query execution (the error is probalby being suppressed). post the code for the sql...

russian_god

I have a table POST:

post_id int(5) not null auto_increment primary key,

name char(30) not null,

email char(30) not null

I have 2 scripts...index.php and view.php

<<<CODE of index.php>>>

<?
$dbconnect=mysql_connect("localhost, $user, pass");
$dbname=mysql_select_db("dbname", $dbconnect);
$query=("select * from TABLE_NAME");
$result=mysql_query($query);
$num_result=mysql_num_rows($result);
echo "Number of recods: <b>".$num_result."</b>";
echo "<br>";
for ($i=0; $i<$num_result; $i++)
{
$row=mysql_fetch_array($result);
$id=$row[post_id];
echo "<a href=view.php?post_id=$id>";
echo $row[name];
echo "</a>";
echo "<br>";
}

?>

<<<CODE of view.php>>>

<?
$dbconnect=mysql_connect("localhost, $user, pass");
$dbname=mysql_select_db("dbname", $dbconnect);
$query=("select * from TABLE_NAME WHERE post_id='$id'");
$result=mysql_query($query);
$row=mysql_fetch_array($result);
echo $row[email];

?>

When I click on the link(in index.php) it goes to view.php?id=NUMBER but
doesn't display email of that NUMBER (post_id)
Just a blank page.... nothing on it.
I Checked everything...... but didnt find any error..
Please help!!!!!!!!!!!!

Anon

If the URL is posting correctly (i.e. the link displays id=5 or whatever), then forget about index.php for now, it seems to be doing it's job.

With view.php, I'm not sure if it is necessary to include the '' around the $ID. Print $query out in view.php, and then enter that into the mysql command-line thingy to query the database. If it doesn't work, change it in the command-line until it does give you the result you want, and then change the code to mirror those changes.

That's all I can think of, HTH

glj

Anon

: $dbconnect=mysql_connect("localhost, $user, pass") or die("Connection Sucks");

: $result=mysql_query($query) or die("Query Sucks");

if you add the die statements to your connection and query it is MUCH easier to debug.

James

Anon

When I type the number in query (exapmle: id=1) in view.php id works. but when when it comes from the index.php and id='$id'
url looks like this... view.php?id=1
but it doesnt dispaly anything...