In message <[EMAIL PROTECTED]>, Gordon Stewart
<[EMAIL PROTECTED]> writes
>
>$query="SELECT * FROM People WHERE Email = '$from1'";
>echo "3QUERY - '$query'\n";
>echo "3FROM = '$from1'\n";
>$result=mysql_query($query) or die( "Unable to view data\n" . mysql_error());
>echo "result - '$result'\n";
>
>the above is correct, & the query is correct (compared with another
>query ive got...)
>
>The result DOES NOT EXIST (I know there are no matches)...
>
>However :- The '$result' - Comes up with this :-
>
>result - 'Resource id #9'
>
>Now - Im assuming that "Resource id #9" means there are no records
>that match the query ?
>
>(if so - I can work with this...) -
>
>Or does it mean something else ?
It means that you haven't finished coding (:->
if (mysql_num_rows($result)) { then I found something }
To view all the records that you found...
while (list( $ID, $name, $password [amended to suit your table] ) =
mysql_fetch_array($result)) {
echo "<P>$ID - $name - $password</P>";
}
--
Pete Clark
http://www.hotcosta.com
http://www.spanishholidaybookings.com
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
