[SOLVED] Problem with mysql_fetch_array

[alexguz79]

i'm having this on a connection to my sql db

 

Warning: extract() [function.extract]: First argument should be an array in /home/tontrosk/public_html/pia/display.php on line 10

 

here is my code

 

<?php 

include("db.php");

mysql_connect ($host, $user, $pass);
mysql_select_db ($database);
$result = mysql_query ("SELECT * FROM 'departamentos' ORDER BY id DESC LIMIT 2");

$row = @mysql_fetch_array($result);
extract($row);
echo "$nombre : $precio";

?>

[POG1]

try changing

$row = @mysql_fetch_array($result);

to

$row = mysql_fetch_array($result,MYSQL_ASSOC);

[alexguz79]

nop... same error....

 

i don't know whats happening.... i'm following this video tutorial and in the video seems to work perfectly at once.... but i get this everytime

[revraz]

Remove the single quotes from around your tablename.

 

Using mysql_error() after your querry would probably tell you the error.

[alexguz79]

that worked.. thanks