[SOLVED] MySql & PHP Problem

[Barand]

Identical to your last post ???

[pocobueno1388]

Are you talking to me Barand? I added the while loop in there...nothing to drastic, but it was a change.

[jadedknight]

Wow! Thank you guys so much, you have been so helpful haha. Man it works ok this is my code now..

$query="SELECT * FROM posts";

$result=mysql_query($query);

 

while ($row = mysql_fetch_assoc($result)){

 

echo $row['id'].'<br>';

echo $row['title'].'<br>';

echo $row['author'].'<br>';

echo $row['date'].'<br>';

echo $row['content'].'<br>';

 

}

 

I just want to make sure thats correct code to use.

[pocobueno1388]

You could clean it up a bit...

 

<?php

$query="SELECT * FROM posts";
$result=mysql_query($query);

while ($row = mysql_fetch_assoc($result)){

echo $row['id'];
echo $row['title'];
echo $row['author'];
echo $row['date'];
echo $row['content'];

}

?>

 

EDIT:

Oh, I just relized that you may have just wanted to space them out with the ''.

 

<?php

$query="SELECT * FROM posts";
$result=mysql_query($query);

while ($row = mysql_fetch_assoc($result)){

echo $row['id'].' ';
echo $row['title'].' ';
echo $row['author'].' ';
echo $row['date'].' ';
echo $row['content'].' ';
echo '<p>';

}

?>

[jadedknight]

Yeah for some reason the <br> tags didnt copy and paste..etc, one last thing When I use that, all the post information is all mushed together, where to I insert a break to separate each post.

[Barand]

You could clean it up even more - see my reply #21 above

[pocobueno1388]

The second code of my last post should fix that for you =)

[pocobueno1388]

Oh, I see what you are saying Barand. I just wanted to give her something a little more simple than that just because she is newer and it would help her understand better.

 

I am glad you posted that code though, it works beautifully and I hope you don't mind if I use it when I am coding

[jadedknight]

YES! Wow thank you so much! *tears* lol. Man you guys rock. This is my first day here and already so much positiveness lmao. I will be back hopefully to help

[pocobueno1388]

Everyone here is happy to help you XD

 

Make sure to set this topic as "solved".

[Barand]

 

I am glad you posted that code though, it works beautifully and I hope you don't mind if I use it when I am coding

 

Feel free to use it.

 

For greater functionality there's also the baaGrid link in my sig.

[pocobueno1388]

Great =D Thanks