Declare a variable from a query...

cmccomas

I have a query:

$query  = "SELECT newsID, news_headline, news_date FROM news ORDER BY news_date";

I want to declare the news_headline field as a variable. Right now I have:

$headline1 = $news_headline;

That isn't working, how do I need to do this?

saraadmin

You need to execute the query, fetch the result and extract the field you want into a variable. Do you mean that you want the whole "news_headline" column for the result set?

Using MySQL:

$headlines = array();

$query  = "SELECT newsID, news_headline, news_date FROM news ORDER BY news_date";

mysql_query($query);

while ($row = mysql_fetch_assoc($query)
  $headlines[] = $row["news_headline"];

If you just want the one result:

$query  = "SELECT newsID, news_headline, news_date FROM news ORDER BY news_date";

mysql_query($query);

$row = mysql_fetch_assoc($query);
$headline1 = $row["news_headline"];

cmccomas

What I want to do is duplicate the news_headline column for all results. One of the news_headline fields I want to be normal, like "This is a sample news headline". The second I'm trying to do a str_replace() and replace the spaces in the news headline field with a dash, so they look like "This-is-a-sample-news-headline".

I want to display both of them in the results.

saraadmin

Ah, then you could do it with the database.

If MySQL:

$query  = "SELECT newsID, news_headline, REPLACE(news_headline, ' ', '-') AS news_headline_dashed, news_date FROM news ORDER BY news_date";

You will then be able to select both

$row["news_headline"];
$row["news_headline_dashed"];

for each row.