mysql_result() is used when you know the row number of the item you
want to retrive from your table.
mysql_query() is used to get all results from a query, so you can loop
thru an array of them or something.
Russ
On Wed, 23 May 2001 18:47:22 +0200 Johannes Janson
[EMAIL PROTECTED] wrote:
Hi,
$sql2 = SELECT ServiceDes FROM ServiceTypes WHERE ServiceID =
$serviceid;
put single quotes around $serviceid.
$service_type = mysql_result($sql2, 1);
I might be perpetuating the spreading of rumors but I've heard and read
somewhere
that mysql_query() is supposed to be better in the performance. Perhaps
someone
else could clear this point for me thus stopping the rumors.
Cheers
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]