Search the Community
Showing results for tags 'mysql php select query number'.
Found 1 result
-
Hi ,, i have this code <?php include "config.php"; mysql_select_db("mov_db", $con); $select = mysql_query("SELECT "); echo "<table border=1 >"; echo "<tr>"; echo "<th>NO</th>"; echo "<th>Name</th>"; echo "<th>Price</th>"; echo "</tr>"; while($row=mysql_fetch_array($select)) { echo "<tr>"; echo "<td>" .$row['no'] ."</td>"; echo "<td>" .$row['name'] ."</td>"; echo "<td>" .$row['price'] ."</td>"; echo"</tr>"; } echo "</table>"; ?> and i want to display a list of all movies with price over 20 and sorted by price .. how i can select ? ,,,, in another table i want to display information of all drama movie in "type" field because their is different type, i want just display drama !!
