Help calling from a MYSLQ db.

madd

I am trying to do the following,

Have a form on my website, where people can click an ENTER button, and it will add there name to a textbox where I can then hold drawings and stuff.

So, first off I'm trying to learn basic MYSQL... Here is what I got so far...

$sql = "SELECT user FROM nuke_contest"; 
$result = $db->sql_query($sql); 
$result2 = $db->sql_fetchrow($result); 



$content = " 
Enter To Win!! 
<br><textarea disabled name=\"textarea\" cols=\"20\" rows=\"10\">$result2[0]</textarea><br> 
<input type=\"submit\" name=\"Submit\" value=\"Enter!\">";

That will put the first entry in the text box, BUT, if I change it to
$result2[1] I get nothing....

What am I doing wrong?

bastien

You are only selecting 1 field from the db. MySQL returns a 0-based array with all the elements requested starting from 0 as the firsts item in the row.

Since your row only has one item, it has an ordinal number of 0.

hth

madd

I have 4 items in the "user" row.

users

Test
Test1
Test2

Using the $results2[0] it displays Test

When I change the [0] to a [1] for example, I do not get any results.

Here is the big goal, I want it to display ALL the user names....

How would I code that?

    while($row=mysql_fetch_assoc($result))
{
print_r($row);
}

Will only list the last 2, not the first one... And it does not add breaks between the names.....

Thank you for helping me...

bastien

your resultset looks like this

col[0] There is no col[1]

user

Test
Test1
Test2

while($row=mysql_fetch_array($result))
{
print ($row)."<br>";
}

madd

Ahhh...

Using that, the output is

Array
Array

???

bastien

sorry my fault

while($row=mysql_fetch_array($result))
{
echo $row[0]."<br>";
}

dnast

And if you're still only getting the last 2 results it's because you're fetching a row before the while loop starts.

Also, "user" is the column or field. In this case the rows are each user, if this makes things any clearer.

madd

http://www.tj.henington.net/test.php

So looks good.... :oD

Now, how would I go about having the

ENTER

button, do an INSERT, adding a value to the table??

<?php 
$connect = @mysql_connect("localhost", "USER", "PASS") or die("could not connect to server"); 
$db_select = @mysql_select_db("DB") or die("could not select the database"); 
$SQL = "SELECT user FROM nuke_contest"; 
$result = @mysql_query($SQL) or die("Could not run query"); 



echo("Enter To Win!!
<br><textarea disabled name=\"textarea\" cols=\"20\" rows=\"10\">");
while($row=mysql_fetch_assoc($result))
{
print_r($row[user]. chr(13));
}
echo("</textarea><br>
<input type=\"submit\" name=\"Submit\" value=\"Enter!\">");
?>

Thank You!