Viewing Thread:
"Mysql - Php Tutorials"

Does anybody know of any good Mysql - Php tutorials?

The majority I've found are useless.

Freeola wrote:
> This will, of course, simply pull the information in a long list
> rather than in a table etc.
>
> You could therefore set up a table and in each of the columns echo a
> certain field in MySQL for example echo
> $record['fieldtoecho'];

Aha. Wrong table. I read MySQL table -> HTML, not table -> HTML table.

This will, of course, simply pull the information in a long list rather than in a table etc.

You could therefore set up a table and in each of the columns echo a certain field in MySQL for example echo $record['fieldtoecho'];

Nimco wrote:
> >
> $result = mysql_query("SELECT `email` FROM `tbl_name` WHERE
> `username`='Damarus'");
>
> while ($row = mysql_fetch_assoc($result))
> { echo $row['email']; }
>
> ?>

He'll have to connect to the database first?




$db="";
$link = mysql_connect("localhost");
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());
$result = mysql_query( "SELECT `email` FROM `tbl_name` WHERE
`username`='Damarus'" )
or die("SELECT Error: ".mysql_error());
$row = mysql_fetch_row($result)){
echo "Email = ".$row['email];
}
mysql_close($link);
?>

Thanks Nimco.

$result = mysql_query("SELECT `email` FROM `tbl_name` WHERE `username`='Damarus'");

while ($row = mysql_fetch_assoc($result))
{ echo $row['email']; }

?>

I've got the basics going. Theres just one thing that's troubling me.

Say I've got a table with username, name, email etc.

And I want to display the username Damarus's email, how would I do this?

http://www.php.net
http://www.kirupa.com

It's totally not difficult - just remember the principals: store, retrieve, manipulate, edit.

Does anybody know of any good Mysql - Php tutorials?

The majority I've found are useless.