Newbie Question..Getting data from MySql

[gegeor]

Hello...

I want to connect to Db , retrive and display data from a specific table...

The table name is "nuke_authors" and the field I wish to see in php page is named"name"

What is the code I should use..?

I have tried the following ..It doesnt work..

<?php
$db = mysql_connect("castle", "username", "paswd");
mysql_select_db("castle",$db);
$query = mysql_query("select * from nuke_authors ");

if ($row = mysq_fetch_row($query)) {
print_r ($row
?>

==================================
thanks in advance
Regards

[Norman_Graham]

Couple of syntax errors for a start, but try this:

<?php

$serv_cnx = mysql_connect("castle", "username", "paswd"); 
$db_cnx = mysql_select_db("castle",$serv_cnx); 
$query = mysql_query("select * from nuke_authors"); 

while ($row = mysql_fetch_array($query)) { 
echo "<p>" . $row["field1"] . "<br />" . $row["field2"] . "</p>";
}

?> 

You need to specify what it is you want to display from the database using the field names (substitute your field names for field1 etc.)

Hope that helps

Norman

[gegeor]

thankss

It worked fine🙂