[RESOLVED] Need help fast

wescooldude3

Ok i created a php script for my boss that he wanted, it has five questions and a spot for a name. Well the results go into a mysql table, BUT he wanted to be able to view a list of all the people that answered his questions and i made a php script which you can view here but he wants all the data in a table and the table's headers will be the qestions and he wants the answers under it like this but in a php script so he could view it and print it out.

If somebody can i need the code and i need it kind of soon either give me a link or post it on here if you would.

todays date ="5/02/2008"😕 🙁 🙁

NogDog

The "this" link is broken.

While I realize you're in a hurry, you'll probably get more help if you take a little time to tell us things like waht DBMS you are using, what you've tried so far, maybe show us the applicable source code in [noparse]

...

[/noparse] bbcode tags, etc. (see http://catb.org/~esr/faqs/smart-questions.html#intro for more info on how to ask questions).

wescooldude3

ok here is my code that shows the data of the mysql table HERE
and i wont it like this i need it like that but i dont know any of the php that will tak e the results of the mysql table and put it in a html table like the one above that gets bigger to every result i add, also if you want to try the script that enters data into the mysql table go here

wescooldude3

please help i need this by wednesday:eek: :eek: :eek:

NogDog

The basic process is:

<?php
// do DB connection stuff...
// run query (assume result is in $result)...
// then...
echo "<table>\n";
echo "<tr><th>heading 1</th><th>heading 2</th><th>Etc....</th></tr>\n";
while($row = mysql_fetch_assoc($result))
{
   echo "<tr>";
   echo "<td>".$row['col1']."</td>";
   echo "<td>".$row['col2']."</td>";
   echo "<td>".$row['etc.']."</td>";
   echo "</tr>\n";
}
echo "</table>\n";

wescooldude3

NogDog wrote:

The basic process is:

<?php
// do DB connection stuff...
// run query (assume result is in $result)...
// then...
echo "<table>\n";
echo "<tr><th>heading 1</th><th>heading 2</th><th>Etc....</th></tr>\n";
while($row = mysql_fetch_assoc($result))
{
   echo "<tr>";
   echo "<td>".$row['col1']."</td>";
   echo "<td>".$row['col2']."</td>";
   echo "<td>".$row['etc.']."</td>";
   echo "</tr>\n";
}
echo "</table>\n";

ok im a total noob to the mysql part of php and i need all the php code im sorry but i need it all fast here is my html code

 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head><title>Php mysql table script</title>

</head><body>
<table border="1">
<tbody>
<tr>
<th>Name:</th>
<th>Question1:</th>
<th>Question2:</th>
<th>Question3:</th>
<th>Question4:</th>
<th>Question5:</th>
</tr>
<tr>
<td>BOB</td>
<td>yes</td>
<td>no</td>
<td>maybe</td>
<td>no</td>
<td>yes</td>
</tr>
</tbody>
</table>
</body></html>

wescooldude3

ok i got it figured out but ill be asking anouther question soon:glare:

messels

i'm just trying to understand how you got to be doing this project and it has this last minute deadline but you don't have much of an idea on how to do PHP.

what's up w/ that?

does your boss know you don't know what you're doing or you playing him/her? (just curious)

leatherback

Or is it just a school project and you failed to do your coursework!? 😃

wescooldude3

I know php good its just im just a nubie to the mysql department🆒

wescooldude3

messels wrote:
i'm just trying to understand how you got to be doing this project and it has this last minute deadline but you don't have much of an idea on how to do PHP.

what's up w/ that?

does your boss know you don't know what you're doing or you playing him/her? (just curious)

No i knew php and i told him that i knew php and i knew the php code to connect to mysql i just did not know the code to display the results in a script:bemused:

Horizon88

... so you didn't know the while() loop and how to use arrays?

Interesting. Don't forget to mark this resolved, please.

wescooldude3

Horizon88 wrote:
... so you didn't know the while() loop and how to use arrays?

Interesting. Don't forget to mark this resolved, please.

No like i said i just dont know the mysql part of php but i know most of it know.:glare: