$query = mysql_query("select `subject` from `markssub1` where `sname`='$user' AND `sid`='$id'");
$subjects = [];
while($row = mysql_fetch_array($query))
{
$subjects[] = $row['subject'];
}
foreach($subjects as $subject){
echo $subject . '\n';
}
More Related Contents:
- The requested URL was not found on this server.
- Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
- How to write a stored procedure using phpmyadmin and how to use it through php?
- Import file size limit in PHPMyAdmin
- Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
- Mysql event error using php
- Access denied for user ‘root’@’localhost’ with PHPMyAdmin
- Store procedures in phpMyAdmin
- How to solve time out in phpmyadmin?
- WAMP/MySQL errors not in correct language
- phpmyadmin automatic logout time
- #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
- Unknown database error in PHP but it exists in PHPMyAdmin
- Extension mysqli is missing, phpmyadmin doesn’t work
- How to SELECT DEFAULT value of a field
- How to log in to phpMyAdmin with WAMP, what is the username and password?
- Auto Increment skipping numbers?
- How to write a stored procedure in phpMyAdmin?
- Installing PDO driver on MySQL Linux server
- phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
- Fatal error: Call to a member function bind_param() on boolean [duplicate]
- strange character encoding of stored data , old script is showing them fine new one doesn’t
- MySQL/PHP Error:[2002] Only one usage of each socket address (protocol/network address/port) is normally permitted
- How to use multiple databases dynamically for one model in CakePHP
- Error while using PDO prepared statements and LIMIT in query [duplicate]
- PDO prepared statement fetch() returning double results
- SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
- how to download blob based file from MySQL database in PHP?
- Difference between mysql_fetch_array and mysql_fetch_row?
- Aggregated query without GROUP BY