Menu
Community /Pin to ProfileBookmark
@NogDogJul 16.2009 — #If you want the first row from the result, row numbering starts at 0 (as does column numbering):
@NogDogJul 16.2009 — #No, you want the 1st (and only) row returned by the query, don't you? (This is totally distinct from how and where that row is stored in the DB table.) @NogDogJul 16.2009 — #No, what I mean is that your query is going to return one result row with one field (column). In other words it will match on one row in the specified table where the value for column
So the [i][b]query result[/b][/i] would be one row with one column. Therefore the email address you are looking for would be in [b][i]query result[/i][/b] row 0 (the only row) and column 0 (the only column).
For another query, you might request multiple columns and match on several or all rows in the database. It would return something like:
In such a case you'd probably end up using mysql_fetch_assoc() in a while() loop in order to retrieve and process each [b][i]result row[/i][/b] in sequence.
[RESOLVED] Calling an email [NOT RESLOVED]
Sorry for the double post, but I didnt let me undo the resloved. Anyways I have this:
[code=php]$dbquery = “SELECT email FROM `users` WHERE Random_key='” . $confirmid . “‘”;
$result2 = mysql_query($dbquery);
echo “mysql_result($result2,4)”;
with this error:
mysql_result(Resource id #4,4)
Once again sorry for the double post. 😮
Sign in
to post a comment10 Comments(s) ↴
0
@NogDogJul 16.2009 — #If you want the first row from the result, row numbering starts at 0 (as does column numbering):[code=php]
echo mysql_result($result2, 0);
[/code]0
@NogDogJul 16.2009 — #0
@NogDogJul 16.2009 — #No, what I mean is that your query is going to return one result row with one field (column). In other words it will match on one row in the specified table where the value for column Random_key<i>
</i>mysql> SELECT email FROM <span><code>users</code></span> WHERE Random_key='gobbledygook'
email
==================
[email protected]
(1 row returned)
mysql> _
So the [i][b]query result[/b][/i] would be one row with one column. Therefore the email address you are looking for would be in [b][i]query result[/i][/b] row 0 (the only row) and column 0 (the only column).
For another query, you might request multiple columns and match on several or all rows in the database. It would return something like:
<i>
</i>mysql> SELECT name, email FROM <span><code>users</code></span> ORDER BY email ASC
name email
========= ==================
Joe Blow [email protected]
John Doe [email protected]
(2 rows returned)
mysql> _
In such a case you'd probably end up using mysql_fetch_assoc() in a while() loop in order to retrieve and process each [b][i]result row[/i][/b] in sequence.