list info >> I want help ...

[3yoon_af]

Hi every body .....

i have a problem with the PHP....
i login as a comany and search about student . the information appears about the students is very few and i must click on (more information ) option to see more information but the code does not work with me.

when i write $sql = "SELECT * FROM student_info WHERE (Student_ID = '$Student_ID') "; the code does not work

but when i write $sql = "SELECT * FROM student_info WHERE (Student_ID = '200580125') "; the code is work because we define a specific id

can any one help me pleaaaase.....

[steamPunk]

try doing echo $sql; just after your SELECT to see if the variable $Student_ID contains something

[malbera]

Have you tried:

$query="SELECT * FROM student_info WHERE (Student_ID = '".$_GET[$Student_ID]."')";

[3yoon_af]

Thanks all for helping ..

I discovered why the code doesn't work with me ..

In this code I have a space which case the problem ..

<a href=edit_selected_stud.php?Student_ID=".$row["Student_ID"]."> ".$row["Student_ID"]."</a>

Thanks all for trying to help ..