Get info from database

phpnewbiex

I'm trying to get data from my mySQL database but I can't figure out what I'm doing wrong. I've tested the query I'm using in the following script in the mySQL control panel on a terminal and it works fine:

<?php
$link = mysql_connect('localhost', 'root', '');
mysql_select_db('php', $link);
$query = "SELECT name FROM yeah WHERE song = "lmao"";
$result = mysql_query($query, $link);
$final = mysql_fetch_array($result, $link);
echo "$final";
mysql_close($link);
?>

Can anyone help out?

cahva

Use:
echo $final['name'];

mahers

mysql_fetch_array() returns an array, the second parameter is the result type (accociative, numeric or both) and does not need a link identifier, therefore it should be:

$link = mysql_connect('localhost', 'root', '');
mysql_select_db('php', $link);
$query = "SELECT name FROM yeah WHERE song = 'lmao'";
$result = mysql_query($query, $link);
$final = mysql_fetch_array($result);

// Access the array values
echo $final['name'];

mysql_close($link);

phpnewbiex

Still doesn't work.

Maybe I am using the wrong command (mysql_fetch_array). I am only trying to get what is in one field.

I tried doing the same thing using mysql_fetch_object but it still didn't work.

Any ideas?

Note: I changed it to mysql_fetch_object and echo $final; is printing "Object".

cahva

No, the mysql_fetch_array is fine. You probably have error in your query or you are not connecting to db with right user or password values. Add that "echo mysql_error();" to see what error it gives..

$link = mysql_connect('localhost', 'root', '');
mysql_select_db('php', $link);
$query = "SELECT name FROM yeah WHERE song = 'lmao'";
$result = mysql_query($query, $link);
$final = mysql_fetch_array($result);

// Access the array values
echo $final['name'];

// tells the last mysql-error if any
echo mysql_error();

mysql_close($link);

phpnewbiex

That seems to have worked. Thank you very much.

phpnewbiex

I have it working now and I know how to use mysql_fetch_array, mysql_fetch_row, etc. There's one thing I still don't get though.

Say I do the following:

$query = "SELECT album FROM albums WHERE year = '1999'";
$result = mysql_query($query, $link);
$final = mysql_fetch_array($result);
echo $final['album'];

I'd only get the first result. How do I get it so that all results appear on screen?

spin0us

Use a while to scan all the records :

$query = "SELECT album FROM albums WHERE year = '1999'";
$result = mysql_query($query, $link);
while($final = mysql_fetch_array($result)) {
     echo $final['album'];
     echo "<br />";
}