HTML Table from Database Table

aspekt9

I need an html table that outputs all the events in my database table and shows their id number, title, and timestamp. What would be the easiest way to do this? I was thinking something like:

	$query = mysql_query("SELECT id,tile,content FROM calevents");
	echo mysql_fetch_array($query);
	while ($fetch = mysql_fetch_array($query))
	{
		echo $fetch[0];
		echo $fetch[1];
	{

But I'm not quite sure how I could get it to output into an html table.

leatherback

Try reading the forum! I answered exactly the same question 2 hours ago!

There is NO excuse for being lazy..

http://codewalkers.com/seecode/435.html

aspekt9

Terribly sorry, I only really pay attention to the newbie forum as I don't think I'm qualified yet to post in the 'coding' forum so I rarely look at it. Will keep in mind for next time, thank you for the help this is exactly what I need. I did search however, but that particular topic did not come up in the search results hence why I posted my question on it.

NogDog

leatherback wrote:
There is NO excuse for being lazy..

I've got an excuse: I was up until 4:00am this morning trying to figure out how to get my new Vista-OS notebook to see my WinXP desktop on my local network, still with no success. :p

aspekt9

Alright it's working great now. If I'm going to use that function and I have a row for 'content' which displays the story meaning it could be extremely large, how can I shorten it to perhaps only display the first couple of words? Would I use trim() and if so how would I implement it into that script?

NogDog wrote:
I've got an excuse: I was up until 4:00am this morning trying to figure out how to get my new Vista-OS notebook to see my WinXP desktop on my local network, still with no success. :p

That's an easy one. I did it with no problem but now that I look back I can't remember how I did it lol. Make sure they're in the same workgroup. It really didn't take me too long to finish.

leatherback

NogDog wrote:
I've got an excuse: I was up until 4:00am this morning trying to figure out how to get my new Vista-OS notebook to see my WinXP desktop on my local network, still with no success. :p

Sure. So you got to stay up late and play with gadgets, and I get to solve your problems? Sorry. You are not paying me enough.

:evilgrin:

leatherback

aspekt9 wrote:
Alright it's working great now. If I'm going to use that function and I have a row for 'content' which displays the story meaning it could be extremely large, how can I shorten it to perhaps only display the first couple of words? Would I use trim() and if so how would I implement it into that script?

As I am lazy when it comes to these things (I do not care whether I cut a word in half), I use this:


  if(strlen($newsdetails[title]) >= 45)
    {
    $string = substr($newsdetails[title], 0, 45)." ...";
    }
  else
    {
    $string = $newsdetails[title];
    }

aspekt9

I'm assuming I would insert this in here somewhere:

    // Make rows for records
    while($rec = mysql_fetch_array($result))
    {
        echo "<tr>";
        for($i=0;$i<count($rec);$i++)
        {
            if($rec[$i]) 
                echo "<td>$rec[$i]</td>";
        }
        echo "</tr>";
    }

Would I implement it as a foreach statement? I'm not really getting how they would interface since that while statement just prints out everything in the array I would somehow have to search the array first right?

leatherback

replace:

echo "<td>$rec[$i]</td>";

with:

if(strlen($rec[$i]) >= 45)
    {
    $string = substr($rec[$i], 0, 45)." ...";
    }
  else
    {
    $string = $rec[$i];
    } 

echo "<td>$string</td>";

aspekt9

Awesome, works like a charm. Is there any way I can link each one so if I click on it it'll bring up a page I can edit just that particular event? I'm able to add an edit / delete link to the end of each row in the table but how will it know what event id it should be linked to?

leatherback

In the url, add?id=$id:
<a href=\"page.php?id=$id\">link</a>

aspekt9

Ok, I did that but it only adds the first id in the list and then repeats that id for all the other ones. Here's where I inserted it:

while($rec = mysql_fetch_array($result))
    {
        echo "<tr>";
        for($i=0;$i<count($rec);$i++)
        {
            if($rec[$i]) 
			{
                if(strlen($rec[$i]) >= 40) 
				{
					$string = substr($rec[$i], 0, 40)."...";
				} else {
					$string = $rec[$i];
				}
				echo "<td>$string</td>"; 
			}
		}
		echo "<td><a href=\"editevent.php?id=$row[id]\">edit</a></td>";
        echo "</tr>";
    }

Edit: Figured it out doh! It's not $row it's $rec