₦airaland Forum

Hello NL, can anyone help me with this PHP code.

Pls help me to finetune this PHP code to mine from my Db with particular reference to a form item.
e.g.
select *from DB where StudentID = "$text_StudentID"

What I want here is ("$text_StudentID" is a form item that will use the studentID in the form as a basis of searching the dD among other items.
Pls correct the SQL for me as i know its wrong, not fecthing from the db.

Thanks.

--------------------------------------------------------------------------------
Hello NL, can anyone help me with this PHP code.

Pls help me to finetune this PHP code to mine from my Db with particular reference to a form item.
e.g.
select *from DB where StudentID = "$text_StudentID"

What I want here is ("$text_StudentID" is a form item that will use the studentID in the form as a basis of searching the dD among other items.
Pls correct the SQL for me as i know its wrong, not fecthing from the db.

i think the problem with your code is in its semantics; you should select from the table in the DB and not straight from the DB itself. hope this helps

since its within php, it shd be:

"select * from table_name where StudentID = ".$text_StudentID

put it as:

//construct the sql statement
$query = "select * from table_name where StudentID = ".$text_StudentID;

//execute it and return the sql error if it fails
$result = mysql_query($query) or die(mysql_error());