Retrieving information from mysql table

[garethkilgo]

Hi, I am a complete newbie to PHP coding:

I cannot retrieve information from the created table and keep getting No database selected:
<?php
echo "Hello World!";
?>

<?php $con = mysql_connect("localhost","ryandb","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM customer") or die(mysql_error());

echo "<table border='1'>
<tr>
<th>firstname</th>
<th>surname</th>
<th>dob</th>
</tr>";


while($row = mysql_fetch_array($result))

{
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['surname'] . "</td>";
echo "<td>" . $row['dob'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>

Any help would be greatly appreciated !
Cheers

[dblock]

i am new to html php and mysql

i have been trying to build a registration form too

you are trying to display the stuff in the mysql row ... which is a number of feild arranged in a straight line...


you are querying a database table ... remote or on localhost

then you try to

echo row ['feildname']

[phpwreker]

learning this is really not that easy .. you have to think through many abstractions and blocks of the default programing code

[gether]

you arrange the default programing codes like

echo row ['fieldname']

all part of php language

and hope it works

[garethkilgo]

Hi,
I don't really get this - sorry!!!!
i still keep getting an error message-Parse error: syntax error, unexpected '[', expecting ',' or ';' in C:\wamp\www\mytest2.php on line 35
Do you mean:
$result = mysql_query("SELECT * FROM customer");

echo "<table border='1'>
<tr>
<th>firstname</th>
<th>surname</th>
<th>dob</th>
</tr>";


echo "<tr>";
echo row['firstname'] . "</td>";
echo row['surname'] . "</td>";
echo row['dob'] . "</td>";
echo "</tr>";

echo "</table>";

Thanks in advance

[ashaman]

try

Code: Select all

mysql_connect('localhost', 'ryandb', '') or die("no");
    mysql_select_db('my_db') or die("not");
$result = mysql_query("SELECT * FROM customer");
while($row = mysql_fetch_assoc($rs)){
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['surname'] . "</td>";
echo "<td>" . $row['dob'] . "</td>";
echo "</tr>";

}