[SOLVED] 5 mysql

[dezkit]

is there a way to only echo the 5 latest mysql rows?

 

<?php
// Make a MySQL Connection
$query = "SELECT * FROM matches"; 

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo $row['home_team']. " vs ". $row['guest_team'];
echo " : " . $row['result'];
?>

 

please don't tell me the function i should use, instead, edit my code, thank you!!

[p2grace]

Here you go

 

<?php
// Make a MySQL Connection
$query = "SELECT * FROM matches ORDER BY `id` DESC LIMIT 0,5"; 

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo $row['home_team']. " vs ". $row['guest_team'];
echo " : " . $row['result'];
?>

[jonsjava]

That's assuming you are using the `id`(INT)NOT NULL AUTO INCREMENT field

[p2grace]

Correct

[dezkit]

ok, i will use it id(int)

now, what's the code again?

[p2grace]

I just gave you the code.

[jonsjava]

in phpmyadmin (or whatever mysql app you are using)

ALTER TABLE `table_name` ADD `id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;

[dezkit]

ah thank you

[p2grace]

Could you mark the topic as solved once you confirm it's working

 

Thank you.

[dezkit]

i did, 2 seconds before you posted that post

[p2grace]

Ah sorry about that