Pass a Var from mySQL to PHP

fire_cracker

Alright, here is a pretty simple one I do believe, just not quite simple enough for me to figure out 🙂

I am using a mySQL table to hold some information about some articles I'm using on my website. (article title, article url, article date, article author, etc...).

I want to use the id from the table to pull the variables I need out of the table so that my template will show them right; however, I don't understand how exactly to do that. I need the article url, and the article title.

Here is the code that I have so far. I'm just trying to echo the information back to the screen, so I can see if it is correct before I plug the script into my template.

<?
include("connect.inc");

$query1 = "SELECT url FROM news WHERE id=$id";
$page = "mysql_query($query1)";
$title = "mysql_query(\"SELECT title FROM news WHERE id=$id\")";

echo $page;
echo $title;
?>

Any ideas what I am doing wrong? Thanks for the help.

AceE

Originally posted by fire_cracker
Alright, here is a pretty simple one I do believe, just not quite simple enough for me to figure out 🙂

I am using a mySQL table to hold some information about some articles I'm using on my website. (article title, article url, article date, article author, etc...).

I want to use the id from the table to pull the variables I need out of the table so that my template will show them right; however, I don't understand how exactly to do that. I need the article url, and the article title.

Here is the code that I have so far. I'm just trying to echo the information back to the screen, so I can see if it is correct before I plug the script into my template.
<?
include("connect.inc");

$query1 = "SELECT url FROM news WHERE id=$id";
$page = "mysql_query($query1)";
$title = "mysql_query(\"SELECT title FROM news WHERE id=$id\")";

echo $page;
echo $title;
?>
Any ideas what I am doing wrong? Thanks for the help. [/B]

don't quote the query...

$query1 = mysql_query("SELECT * FROM news WHERE id=$id");
WHILE($res1 = mysql_fetch_assoc($query1)){
 $page = $res1[url];
 $title = $res1[title];
}

echo $page;
echo $title;

Thora_Fan

In addition, you might want to try putting single quotes around the $id variable in the query.

include("connect.inc"); 

$query1 = "SELECT url FROM news WHERE id='$id'"; 
$page = "mysql_query($query1)"; 
$title = "mysql_query("SELECT title FROM news WHERE id='$id'")"; 

echo $page; 
echo $title;

fire_cracker

Alright, thanks. That is exactly what I was looking for! I'm surprised that I've been able to get as much of this done as I have without asking a thousand questions. Maybe someday I can come in here and provide answers too 🙂