connecting to mysql using php

[Anon]

i am connecting to mysql using php.

here is what i am using:
$db = mysql_connect("xxxxx", "xxxxx", "xxxx");
mysql_select_db("xxxxx");
$result = mysql_query("SELECT firstname, lastname FROM listings LIMIT 0, 30 ");
?>

now what i want to do is have $result to display itself in html.

i've tried
<echo $result>

please help, laughter at my expense is the form of payment.. =]

thanks

[Anon]

You need to add the following to view the results of the query:

if (mysql_num_rows($result) > 0) {
while($dbResultArray = mysql_fetch_array($result)) {
print $dbResultArray[firstname] . " ";
print $dbResultArray[lastname] . "<br>";
}
} else {
print "The result was empty";
}

You need to fetch each row from the result that is returned from MySQL. You can't just print off the result. This code checks to make sure there were returned rows and if there were will cycle through all the returned rows populating the $dbResultArray with all the field names from your database. It prints them off then moves on to the next row. Hope this helps.

Trevor DeVore
Blue Mango Multimedia

[Anon]

Niggy, result contains a "result set" that you will have to dissect a bit. There are several different approaches, which explains why there are so many different mysql functions that pretty much do the same thing. The function that makes the most sense to me is

$myresults = mysql_fetch_obj($result)

... which creates an object containing the results for a single line. If you have database columns named moe, larry, and curly, you refer to them as

echo "$myresults->moe is the idiot, $myresults->larry is a bozo, and $myresults->curly is an imbecile";

Whatever function you choose, the important thing is to call it repeatedly until it no longer returns information. Example:

while ($myresult = mysql_fetch_object($result))
{
// do something
}

The "do something" section is where you mingle the data with HTML.

[Anon]

Steve is right, the result is just a big blob of information that needs to be rearranged to something that you can work with.
Another command you can use (Besides mysql_fetch_object($result)) is just mysql_fetch_array($result). You can put this in a while loop:

while ($row = mysql_fetch_array($result) {
$columnone = $row["nameofcolumnone"];
$columntwo = $row["columntwo"];

echo "<tr><td>$columnone</td><td>$columntwo</td></tr>";

Hope this helps.

Aaron