[Resolved] id sent in url but not working,how do i query only one row at a time?

phpjaco

ok so here is my problem, I have a database displaying all rows of users, when you click the id its suppose to load the next page (see code) with only that one user. the link looks ok (in the browser) but doesnt work for some reason.

page displaying all results with link:

session_register("id");
while($row = mysql_fetch_array($rs2)) {

// link in first td --> $list .= "<tr class=\"verysmallcopyblack\"><td><a href=\"edit_staff.php?id=$row[user_id]\">".$row["user_id"]."</a>"."</td><td>".$row["staff_name"]."</td><td>".$row["staff_surname"]."</td><td>".$row["staff_password"]."</td><td>".$row["email"]."</td><td>".$row["staff_group"]."</td><tr>";
}
$list .= "</table>";
......

resulted page with only one user information:

// displays the current user
$rs2 = mysql_select_db("media_tenor_staff",$conn);
$sql = "select * from media_tenor_staff where user_id = $id";
$rs2 = mysql_query($sql,$conn);
$list .= "<table border=\"1\" cellpadding=\"2\" width=\"100%\">";
while ($row = mysql_fetch_array($rs2)) {
$list .= "<tr><td>Name :</td><td>".$row["staff_name"]."</td></tr>";
.......

still pretty new to php, so im pretty sure there is an error with my code (syntax or other)

any help would be appreciated.

TheDefender

// displays the current user 
$rs2 = mysql_select_db("media_tenor_staff",$conn); 
$sql = "select * from media_tenor_staff where user_id = '$_GET['id']'"; 
$rs2 = mysql_query($sql,$conn); 
$list .= "<table border=\"1\" cellpadding=\"2\" width=\"100%\">"; 
while ($row = mysql_fetch_array($rs2)) { 
$list .= "<tr><td>Name :</td><td>".$row["staff_name"]."</td></tr>"; 
.......

Register Globals is probably off, so you have to call the $id variable out of the global $_GET array instead of calling it directly.

phpjaco

i have entered the code ("select * from media_tenor_staff where user_id = '$_GET['id']'"😉 but this results in a error :

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in c:\program files\apache group\apache\htdocs\01. media_tenor\edit_staff.php on line 15

seen this error before but unsure what this means.

uncertain about this : i have defined "id" as a session variable, on my link i have : <a href=\"edit_staff.php?id=$row[user_id]\">"

id here is id and not $id is this not the problem, also all my other session variables seem in order what's the problem with this one.

please help

thanx

TheDefender

Let's work one prob at a time... Let's get the parse error out of the way, and working first, and we'll move onto the next issue.

Change to:

$sql = "select * from media_tenor_staff where user_id = '".$_GET['id']."'";

phpjaco

i did this, now there are no problems. error messages. still not displaying the user, but it appears the id is in there but somehow not functioning. i have this :

$rs2 = mysql_query($sql,$conn);
if ($rs2) {
$msg2 = "success";
........
} else $msg2 = "No results found";

i see "success" tho so i know its working but its not.

btw, what is the ' for i have never used it, only have used : " dsfdsf " and \"$name "\

also the rest of the script is ok, because if i type in a number e.g 45 i see the user information. so what can this be?

TheDefender

OK, so let's move on to the WHILE loop then...

while($row = mysql_fetch_array($rs2)) { 

$list .= "<tr class=\"verysmallcopyblack\"><td><a href=\"edit_staff.php?id=$row['user_id']\">".$row['user_id']."</a>"."</td><td>".$row['staff_name']."</td><td>".$row['staff_surname']."</td><td>".$row['staff_password']."</td><td>".$row['email']."</td><td>".$row['staff_group']."</td><tr>"; 
}

Change all of the field names in the array name to use single quotes...

$row['fieldname']

phpjaco

still nothing.... :

$list .= "<tr class=\"verysmallcopyblack\"><td><a href=\"edit_staff.php?id=$row[user_id]\">".$row['user_id']."</a>"."</td><td>".$row['staff_name']."</td><td>".$row['staff_surname']."</td><td>".$row['staff_password']."</td><td>".$row['email']."</td><td>".$row['staff_group']."</td><tr>";

if i add the single quote marks in the e.g id=$row['user_id'] => this results in a parse error.

on my first page i have a sesion variable called user_id, could this maybe interfere with whats going on?

thanx

phpjaco

thanx for all the help..

here is what i did ... just called id => id2

then said

"select * from media_tenor_staff where user_id = $id2";

so id must have been used somewhere else or something. .. dunno but it worx now. .....