Allowing users to post info....then view

twizter

I'm trying to make this page that allows members of my site to post the following info(example) and then let the admins be able to view it on another page:

Ships (71306 units total)

Interceptor 8451 Torpedo 6453
Warfrigate 10586 Warcruiser 225
Battleship 1000 Spider 10046
Phantom 2141 Ghost 10000
Dagger 2880 Cargoship 8572
Astropod 10952

now this is what I have written so far, and please understand why I replace all paths to some non-existants, and yes I know they are way wrong :-) :

addfsize.php

$include_path = "/home/blablabla/public_html/blabla";

include ("$include_path/header.inc.php");

<tr>

<h1>Add new Fleet Overview</h1>

<p>

(Paste your Fleet Overview, be sure to include the "Ships (235735 units in total)" part)

<p>

Fleet Overview:<br>
<textarea name="fleetsize" cols=40 rows=10 wrap="VIRTUAL"></textarea>

<p>

</td>

</tr>
</table>
</form>

<? include("$include_path/footer.inc.php");

fsize_added.php

$include_path = "/home/blablabla/public_html/blabla";

include("$include_path/header.inc.php");

mysql_query("INSERT INTO fsize (fleetsize,username)" .
" values('$fleetsize','$username')") ;
echo mysql_error();

<h4>Your current Fleet Size has been added</h4>

include("$include_path/footer.inc.php");

view_fsize.php

$include_path = "/home/blablabla/public_html/blabla";

include("$include_path/header.inc.php");

$result = mysql_query("SELECT fleetsize FROM fsize WHERE id='$fleetsize'");

if ($row = mysql_fetch_array($result)) {

print "Current Fleet Status for: $username";

print "$fleetsize";

}

<p>

<p>

include("$include_path/footer.inc.php");

so..what is wrong here as I can't seem to get the info I saved in the DB

TwiZteR

cameljon

Umm if your viewing view_fsize.php on it's own then how does it get the vars: $username and $fleetsize?

With mysql_fetch_array your setting $row with the values of the database.
You could use $row[0] and $row[1].
Or if you aren't sure where the column is indexed you could use $row["username"] and $row["fleetsize"].

With that said your query is only getting the fleetsize from each row. Unless you set $username and $fleetsize somewhere else it won't work. Are you doing something like "view_fsize.php?fleetsize=value&username=value"?

I usually grab everything and just use what I want. That way it's easier to modify in the future.

Hope that helped.

twizter

well...

I have this memberlist and from there I made a link on each member to "view_fsize.php?id=$username"

and what that should be displayed is exactly what they posted, which would be $fleetsize

first I used echo <? $row["fleetsize"] ?>; but u suggest I should use $row[0] instead ??

twizter

sorry, made a little typo there 😉

should be <? echo $row["fleetsize"] ?>; echo inside php .. heh

cameljon

What is the error your getting?

twizter

I get no error, but the page doesn't display any info 😉

cameljon

Here is your old code:

$result = mysql_query("SELECT fleetsize FROM fsize WHERE id='$fleetsize'");

if ($row = mysql_fetch_array($result)) {

print "Current Fleet Status for: $username";

print "$fleetsize";

}

I'm assuming you saw the typo on your query statement unless fleetsize is the id of the row you want.

Not knowing anything about how your database is setup I would just do this to make it simple:
$query = "SELECT * FROM fsize WHERE user = $username";

Again, I'm assuming you want the fleetsize of the specified user. Adjust as you like.

$result = mysql_query ( $query );

If you know how many columns there are, it shouldn't matter that you get them all. Just use the ones you want.

I like whiles. They are my friend. What if you get more than 1 row for a user?!@#$

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

Now $row[0] and $row[1] etc.. have data. Or you could just use $row["fleetsize"] or any column name.

echo "$row['user'] has entered this for fleetsize: $row['fleetsize']";
}

Throw this in there just for debugging. I didn't test this but if you do this right you'll be able to figure out the rest.

test only

echo "Query: $query"; #should have query

echo "Result: $result"; #should have resource id

echo "Row: $row"; #should say "array"

Just remove ## and see what it echos. If any of those don't do something then your getting an error around there. In that case throw a echo "mysql_error ()"; after each function and see what that says.

Good luck. Let me know if this works for you.