Trying to show the table but isn't working, what am I doing wrong?
<?php
$query = "SELECT id menu_id menu_title FROM tbl_menu";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0){
while ($row = mysql_fetch_array($result)){
echo $row['menu_title'];echo 'test';
}
}
?>
$query = "SELECT id, menu_id, menu_title FROM tbl_menu";
$result = mysql_query($query) or trigger_error(mysql_error());
It doesn't look like you are connecting to anything. You also need to separate column names by commas:
SELECT id, menu_id, menu_title FROM tbl_menu
Here's a mysqli_ example from the documentation:
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "SELECT id, menu_id, menu_title FROM tbl_menu";
if ($result = mysqli_query($link, $query)) {
/* fetch associative array */
while ($row = mysqli_fetch_assoc($result)) {
echo $row[menu_id];
}
/* free result set */
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>
$query = "SELECT id menu_id menu_title FROM tbl_menu";
Must Be
$query = "SELECT id, menu_id, menu_title FROM tbl_menu";
Your SQL have a typo
$query = "SELECT id, menu_id, menu_title FROM tbl_menu";
$result = mysql_query($query);
if($result && mysql_num_rows($result) > 0){
while ($row = mysql_fetch_assoc($result)){
echo $row['menu_title'];
}
}
To note:
mysql_fetch_array() returns a number-indexed array
mysql_fetch_assoc() returns a string-indexed array (indices are names of your fields)
And please, stop using mysql, it is deprecated. Use mysqli instead.
mysql_*functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which.