[SOLVED] Dispalying database results

[OriginalBoy]

Hey,

 

I am trying to display my results in a page. Here is what I got so far what needs adding?

 

<?php

include("../config.inc.php");

$querycol = "select * columns from `credit_customers`";

$queryresult = mysql_query($querycol) or die("Query failed due to: " . mysql_error());

?>

[grlayouts]

try this

 

$querycol = mysql_fetch_array(mysql_query("SELECT * FROM credit_customers;"));

$queryresult = mysql_query($querycol) or die("Query failed due to: " . mysql_error());

[OriginalBoy]

Don't I need to print something?

[grlayouts]

i dont know.. what do you want to print.

print"$querycol[printsomething]";

[OriginalBoy]

I want to show the results from the database

[grlayouts]

it will.. change the printsomething to what you want to show. to what field you want to show.

[webbiedave]

This page contains examples on querying a mysql database and then displaying the results:

 

http://us.php.net/manual/en/function.mysql-query.php

 

[OriginalBoy]

Thanks all