PHP Script not Fetching Data From Column

Question

I have a database with the field Unique ID, which has two rows in it, both integers. The first row has value 3 and the second row 4. The aim of this script is to find the one with the highest value, but it only echo's "Unique ID".

Here is the code:

<?php
$connection = mysql_connect("localhost","root");

if(!$connection) {
die("Connection Failed" . mysql_error());
}
mysql_select_db("rewiredstate",$connection);
$max="SELECT MAX('Unique ID') as id FROM topics";
$maxquery= mysql_query($max) or die (mysql_error());
while($row = mysql_fetch_assoc($maxquery)) {
echo $row['id'];
}
?>

Does anyone have any ideas as to what might be wrong with it? Any help would be greatly appreciated. Thanks

Not an answer, but if this is new code I suggest you look into mysqli or PDO, because the mysql_ functions will be deprecated soon. — PeeHaa
– PeeHaa, Commented Aug 6, 2012 at 19:38

podiluska · Accepted Answer · 2012-08-06 19:38:22Z

4

I think you need different quotes - ` rather than '

answered Aug 6, 2012 at 19:38

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ivin · Accepted Answer · 2012-08-06 19:58:37Z

0

Remove the quotes around Unique ID like this:

$max="SELECT MAX(Unique ID) as id FROM topics";

The mistake in your query is that, you have used wrong quote around the field name in MAX function. As per your query, the MAX function is given a string as parameter, which it compares with no real field values in the table. Thats why it returns Unique ID in the result.

You need to use MAX(field) OR you can choose not to use quote at all, like MAX(field). But certainly not MAX('field').

edited Aug 6, 2012 at 19:58

answered Aug 6, 2012 at 19:51

Ivin

4,9358 gold badges52 silver badges66 bronze badges

Collectives™ on Stack Overflow

PHP Script not Fetching Data From Column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related