SQL not returning value even though it's there...

[Anthony Papillion II]

Hello Everyone,

I have been having fits with a simple PHP script and I'm hoping it's
something that someone here can help me with. Basically, when I execute the
SQL statement directly on the MySQL CLI, it returns. But when I run the same
statement through the following PHP script, I *think* it returns an empty
set.

I say I think because the if(mysql_num_rows($recset) > 0){} block is
executed. But when I try to retreive values stored in my array, I get
blanks. Can someone offer me some help? Thanks in advance -- Anthony

=== SCRIPT ===
<?php
include("db.php");

$incoming_user = stripslashes($_POST['username']);

$sql = "SELECT * FROM tblSisters WHERE username != '$incoming_user' AND
isTaken != 'yes' ORDER BY RAND() LIMIT 1";

$recset = mysql_query($sql, $conn);

if(mysql_num_rows($recset) > 0){
$row = mysql_fetch_row($recset);
echo "<table border=\"1\" align=\"center\" cellspacing=\"7\">\n";
echo "<tr>\n";
echo "<th>USERNAME</th>\n";
echo "<th>WANTS MAIL</th>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>$row[username]</td><td>$row[wsm]</td>\n";
echo "</tr>\n";
echo "</table>\n";

// Update the database to reflect the new selection

$sql2 = "UPDATE tblSisters SET isTaken='yes', takeBy='$incoming_user' WHERE
username='row[username]'";
mysql_query($sql2, $conn);
}
else{
echo "<h2><u><b>RECORD RETREIVAL FAILURE</b></u></h2><br>\n";
echo "The secret sister database could not be queried. Please try again ";
echo "later or contact the system administrator.\n";
}
?>
=== END SCRIPT ===

[Brion Vibber]

Anthony Papillion II wrote:

I say I think because the if(mysql_num_rows($recset) > 0){} block is
executed. But when I try to retreive values stored in my array, I get
blanks. Can someone offer me some help? Thanks in advance -- Anthony [snip] if(mysql_num_rows($recset) > 0){
$row = mysql_fetch_row($recset); [snip] echo "<td>$row[username]</td><td>$row[wsm]</td>\n";

If you were running with error_reporting set to E_ALL, you would see an
"undefined array index" notice here which would have helped you diagnose
the problem: mysql_fetch_row returns an enumerated array, not an
associative array.

If you want to access columns by name, use mysql_fetch_array (or
mysql_fetch_object to use object syntax).

See the online manual for additional information:
http://www.php.net/error_reporting
http://www.php.net/mysql_fetch_row

-- brion vibber (brion @ pobox.com)

[Michael Fesser]

.oO(Anthony Papillion II)

I have been having fits with a simple PHP script and I'm hoping it's
something that someone here can help me with. Basically, when I execute the
SQL statement directly on the MySQL CLI, it returns. But when I run the same
statement through the following PHP script, I *think* it returns an empty
set.

I say I think because the if(mysql_num_rows($recset) > 0){} block is
executed. But when I try to retreive values stored in my array, I get
blanks. Can someone offer me some help? Thanks in advance -- Anthony

Use mysql_fetch_assoc() instead of mysql_fetch_row(). The first returns
an associative array, the latter a numeric one.

Micha

[Peter]

Hi

mysql_fetch_row() creates an integer indexed array. You are using
associated indexes to output the row data. The index does not exist.
To use associative indexes simply change mysql_fetch_row() to
mysql_fetch_array() or mysql_fetch_assoc()

e.g => $row = mysql_fetch_array($recset);

Regards
Peter

Anthony Papillion II wrote:

Hello Everyone,

I have been having fits with a simple PHP script and I'm hoping it's
something that someone here can help me with. Basically, when I execute the
SQL statement directly on the MySQL CLI, it returns. But when I run the same
statement through the following PHP script, I *think* it returns an empty
set.

I say I think because the if(mysql_num_rows($recset) > 0){} block is
executed. But when I try to retreive values stored in my array, I get
blanks. Can someone offer me some help? Thanks in advance -- Anthony

=== SCRIPT ===
<?php
include("db.php");

$incoming_user = stripslashes($_POST['username']);

$sql = "SELECT * FROM tblSisters WHERE username != '$incoming_user' AND
isTaken != 'yes' ORDER BY RAND() LIMIT 1";

$recset = mysql_query($sql, $conn);

if(mysql_num_rows($recset) > 0){
$row = mysql_fetch_row($recset);
echo "<table border=\"1\" align=\"center\" cellspacing=\"7\">\n";
echo "<tr>\n";
echo "<th>USERNAME</th>\n";
echo "<th>WANTS MAIL</th>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>$row[username]</td><td>$row[wsm]</td>\n";
echo "</tr>\n";
echo "</table>\n";

// Update the database to reflect the new selection

$sql2 = "UPDATE tblSisters SET isTaken='yes', takeBy='$incoming_user' WHERE
username='row[username]'";
mysql_query($sql2, $conn);
}
else{
echo "<h2><u><b>RECORD RETREIVAL FAILURE</b></u></h2><br>\n";
echo "The secret sister database could not be queried. Please try again ";
echo "later or contact the system administrator.\n";
}
?>
=== END SCRIPT ===

[R. Rajesh Jeba Anbiah]

Brion Vibber <br***@pobox.com> wrote in message news:<31*************@uni-berlin.de>...
<snip>

If you were running with error_reporting set to E_ALL

or even better E_ALL | E_STRICT under PHP 5 in developement servers.

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com

[Anthony Papillion II]

> If you want to access columns by name, use mysql_fetch_array (or

mysql_fetch_object to use object syntax).

LOL I can't believe it was something THAT simple and THAT obvious. I *knew*
that mysql_fetch_array() was the function to use (I've been using it
forever) but I totally spaced it out on this one. I didn't even know that
there was a mysql_fetch_row() function. Geez, now I feel stupid. Thanks for
your input.

Anthony