query

pneudralics

I'm trying to call a blogging section.

This is the query:
$blog_query = sql_query("journal","user,id,title","ORDER BY time DESC LIMIT 0,5");

These are the fields in the database:
Title
Text
jmood
gcategory
user

I just need help querying the blog section. Can someone show me how to do it with the above fields? Thanks a lot.

Blulagoon

I think you want something like this .....

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($query);
while ($row=mysql_fetch_array($result))   {
echo $row['Title'];    // etc etc as required
}

I don't see a time field in your db structure, so not sure how you are going to ORDER BY time ?

HTH - Blu

pneudralics

How would you put that inside a <<<HTML HTML; ?
I thought you can just put the variable inside there..like $blog_query?

thorpe

I thought you can just put the variable inside there..like $blog_query?

Please elaberate. What are you trying to do?

pneudralics

thorpe wrote:
Please elaberate. What are you trying to do?

I have a php page that I want to display a recent blogging section. On the php page is heredoc codes <<<HTML HTML;

What I want is for the query to show in <<<HTML HTML;

When I use
$blog_query = sql_query("journal","user,id,title","ORDER BY time DESC LIMIT 0,5");

All it does is displays the id number of the blog.

thorpe

Still a little lost. The function sql_query() is not a native php function, what is it meant to return?

pneudralics

thorpe wrote:
Still a little lost. The function sql_query() is not a native php function, what is it meant to return?

So is it mysql_query? Trying to return the title, user etc.

Blulagoon

Blulagoon wrote:

I think you want something like this .....

<table>  // Here you are in html
<?PHP    // turn on PHP

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($query);
while ($row=mysql_fetch_array($result))   {

?>   // here you can turn off the PHP so you are now back to html

<tr><td><?PHP echo $row['Title']; ?></td> 
// normal html code but echoing out the results from the search
// use html to format the display of the info from the db as required

}

Still don't know where you get the time variable from for ORDER BY

Blu

Houdini

Shouldn't this;

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($query);

be this

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($blog_query);

pneudralics

Houdini wrote:

Shouldn't this;

be this

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($blog_query);

This is what I got with that:
SELECT Title,Text,jmood,gcategory,user FROM mytable
I'm trying to place it inside a <<<HTML HTML;

The time is a field from the database.

Houdini

What are you wanting to put into a heredoc something like

$html=<<<HTML
$somevar
HTML

I mean I am not sure exactly what you are wanting to do but all are you wanting to put in there, apparently it looks like you are trying to pull an HTML page out of the database, not really sure.

pneudralics

This is a php file. It has <<<HTML HTML; that's where the html is put to display.
I want to put in $variable inside <<<HTML so it'll show the following:

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($blog_query);

but with the above code this displays:
SELECT Title,Text,jmood,gcategory,user FROM mytable

instead of the blog.

Blulagoon

Houdini wrote:

Shouldn't this;

be this

$blog_query="SELECT Title,Text,jmood,gcategory,user FROM mytable";
$result=mysql_query($blog_query);

Absolutely right Mr Houdini, put it down to lack of caffeine :o

Blu

Houdini

It is time for me to brew mine, woke up and now can't sleep but I can't think either.