Skip to content
PHP Logo

How can you retrieve the highest number from a table in PostgreSQL using PHP?

To retrieve the highest number from a table in PostgreSQL using PHP, you can write a SQL query to select the maximum value from the desired column in the table. You can then execute this query using PHP's PostgreSQL functions to fetch and display the result.

php 
<?php
// Connect to the PostgreSQL database
$conn = pg_connect("host=localhost dbname=mydatabase user=myuser password=mypassword");

// Query to retrieve the highest number from a table
$query = "SELECT MAX(column_name) FROM table_name";

// Execute the query
$result = pg_query($conn, $query);

// Fetch the result
$row = pg_fetch_row($result);

// Display the highest number
echo "The highest number is: " . $row[0];

// Close the database connection
pg_close($conn);
?>

Related questions