/SQL/$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))

$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))

session_start();
require_once "connect_to_mysql.php"; // where i store username and password to access    my db.

$sqlCommand = "SELECT * property FROM portal"; // dbname: portal - table: propery
$query = mysqli_query($myConnection, $sqlCommand);

$Displayproperty = '';
while ($row = mysqli_fetch_array($query))
$id = $row["pid"];
$title = $row["ptitle"];
$area = $row["parea"];
$city = $row["pcity"];
$Displayproperty .= '<table width="500" border="0" cellspacing="0" cellpadding="1">
<tr>
<td>' . $id . '</td>
<td>' . $title . '</td>
<td>' . $area . '</td>
<td>' . $city . '</td>
<td><a href="forms.php?pid=' . $id . '">Upload images</a><br /></td>
</tr>
</table>';

Source: stackoverflow.com

Similar codes

10 votes216 views2 answers
What is database
SQL
0 vote212 views1 answer
Create table database in psql
SQL
10 votes219 views2 answers
Oracle alter sequence nextval
SQL
0 vote209 views1 answer
How change the field place in mysql
SQL
0 vote236 views1 answer
Add super privilege mysql
SQL
0 vote209 views1 answer
How many rows affected in sqllite
SQL
1 vote202 views1 answer
Size of all tables in a schema oracle
SQL
2 votes216 views1 answer
Where clause for child record apex
SQL
0 vote202 views1 answer
Drop all data from tables
SQL
1 vote241 views1 answer
Mysql view curren querys
SQL