The KGB Oracle Forums The KGB Great Hall of History (ARCHIVE) Darkfall Members Forum Question about MySql, need help

Ok guys I have been working on my first database project. Just have a question. I have successfully created the tables and uploaded the contents from my forms into the tables and can view the contents in those tables successfully on the serverside.

I am having trouble finding what I need to do in order to display the contents of said tables in a webpage.

macro more!

What programming language can you use ?
Python, PhP, JAVA, Ruby, C#, any other thing ?

What data from the tables specifically are you trying to pull? You need to specify your query. For instance, trying to display username column from the users table,

This.

MMMmmmm...

Visual Studios and C# & VB.net with a sql backend.

I can taste your tears.

I watched many a geek get destroyed by the year long project that built upon every weeks modules.

Ahhhh memories of CIS 321, 322, 323

Using C# / VB.NET backend isn't too terribly bad really. I mean, once the data connections are setup and you pull using cans it isn't horrible.

Hey guys its all been in PHP. As whole my db is solid and my upload is solid and running very smooth and the tables are all filling properly and recognizing primary keys etc.

Its basically a registration process for my college events. Now the problem I am having is that when I try to "dynamically" create a new webpage with the contents of the database is it only returning the first result in the database.

When I try to apply a loop I am not getting any of my debugging echos, not for my db connection or upload confirmation.

Feel free to take a look at the page, I dont host it, my annoying professor does.

http://ccis004.uncc.edu/~chaconia/final2.htm
http://ccis004.uncc.edu/~chaconia/home.php

I removed my attempt to recreate all the contents to the tables.
both uncc id and phone numbers are primary keys. Doesnt post anything now.

Post your source code ... specifically the query & function which gets the data & then attempts to loop through the rows.

That is a pretty straight forward exercise, whether it is in php, c#, vb or whatever.

You are either looping properly & only return a single row ... meaning your query is incorrect, or your loop is not moving through the records properly.

As Longshanks said above, you need to query the Db. This would be something along these lines:

SELECT ProductId, ProductName, ProductDescription
FROM Products

Use PHP to execute the query and you get a recordset, that is actually very much like the DB table, but only with the columns (ProductId, ProductName, ProductDescription) you specified in the SELECT clause.

When you have the records set, you loop through it. Sortof like this (i don't know PHP too well, so it will be pseudo code):

string query = "SELECT ProductId... " // see the query above
Recordset products = database.Execute(query)

write ("<table>")
foreach (product in products)
{

write ("<tr>")
write ("<td>" + product.ProductId + "</td>")
write ("<td>" + product.ProductName + "</td>")
write ("<td>" + product.ProductDescription + "</td>")
write ("</tr>")
}
write ("</table>")

This will display a html table with all the products in it. Change thje query (dynamically through PHP) to change what is displayed.

You probably know most of this, but I just wanted to give a comprihensive example (i hope).

Show me the you code, and I will be more specific ;-)

Hope this helps.