mysql if statement to php

From: Date: Mon, 14 Apr 2003 01:29:04 +0000
Subject: mysql if statement to php
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-27065@lists.php.net to get a copy of this message
Hi, I am using a php page to grab information using the if statement. Now the mysql query works fine but I can't get the output to output into php. I have tried many things and have failed to get it to display. This is the code: <?php mysql_connect ("localhost", "$usr", "$pass") or die ('I cannot connect to the database.'); mysql_select_db ("$db"); $qr = mysql_query("SELECT IF( emailerror = ('y' ), 'error yes', 'do nothing' ) FROM tipping WHERE sid = '$sid'"); ?> If I do the above query in mysql it returns correctly. If Y is in the table it dispalys error yes. But how do I get it to output to a php page with the above function? Thanks! http://mobile.yahoo.com.au - Yahoo! Mobile - Check & compose your email via SMS on your Telstra or Vodafone mobile.

« previous php.db (#27065) next »