MySQL in php question.

[Windchill]

:confused:

I am now moving from confuzing mangled masses of text files to MySQL and creating a Blog engine.

I have the user ID number in $who (MySQL, blog_ID), and I want to get the blog_1st_name (MySQL table name) into the variable $name. I am connected to the MySQL database.

[Jona]

$query = "SELECT `blog_1st_name` FROM `table_name` WHERE `blog_ID` = '". $who ."'";
$result = mysql_query($query);
if(!$result){
echo("MySQL database error: ".mysql_error()); exit;}

$row=mysql_fetch_assoc($result);
$name = $row["blog_1st_name"];


[J]ona

[Windchill]

Thanks :)

[Jona]

Welcome.

[J]ona