[SOLVED] display certain records..

[ma5ect]

Hi all,

 

I have a recordset to display records from database, but i dont want all the records to be displayed, i would only like the record for which the user has requested for..eg student number..

 

any ideas?

 

code:

 

mysql_select_db($database_mysql_connect, $mysql_connect);
$query_Recordset1 = "SELECT * FROM robs_enterprise";
$Recordset1 = mysql_query($query_Recordset1, $mysql_connect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

[cleary1981]

Should you not use SELECT * FROM rob_enterprise WHERE [condition]

 

condition being what distinguishes the record you are searching for

[prexep]

http://w3schools.com/php/php_mysql_where.asp

[ma5ect]

what i want to achieve is, i want the user to enter their number and then the database to display the records for only that number they entered...am using dreamweaver cs3

 

 

[prexep]

http://w3schools.com/php/php_post.asp

 

http://w3schools.com/php/php_mysql_where.asp

 

Read them. This will help guide you.