Complete Beginner, How do I present an sql query

lcp03o

Hi, Im sorry im a complete beginner, I have the following sql query. I want to present this information on a web page, Does anyone know what code I need to do this?? I can't work it out

$sql = 'SELECT file_name , file_rating '
. 'FROM pafiledb_files '
. 'WHERE 1 '
. 'ORDER BY file_rating DESC LIMIT 0, 10';

Thanks

leatherback

HI,

Very general query looks like::

Select SOMETHING from SOMEWHERE where SOMETHING_IS_VALID order by SOME_ITEM limit by Some_Number_of_records

Now, we translate htis towards SQL:

$query = "";

means: The variable ($) query will be assigned a value (=) in this case a string (""). End of statement (😉

What do you want to select? : file_name, file_rating

from where? : the table pafiledb_files

What should be valid: Nothing specific at the moment

Order by? : file_rating

THis would give you:

$query = "Select file_name, file_rating from pafiledb_files order by filerating desc limit 0, 10";

To execute the query:

$result = mysql_query($query);

To display some results:

While ( $row = msql_fetch_array($result)
{
echo $row[file_name];
echo $row[file_rating;
echo "<br>";
}

Hope this helps you to get started!?

lcp03o

Hi, Thanks for that, it was very useful. Im getting a parse error on the page, it is pointing to the line

While ( $row = msql_fetch_array($result)

I guess there is a ) missing??? Any ideas??

dalecosp

Originally posted by lcp03o
Hi, Thanks for that, it was very useful. Im getting a parse error on the page, it is pointing to the line

While ( $row = msql_fetch_array($result)

I guess there is a ) missing??? Any ideas??

Yes, the expression should be balanced. If you open two, you close two, whether parenthesis, brackets, whatever ...