Re: Request 2 never give me results back ?
| From: | Rolf Brusletto | Date: | Mon, 21 Apr 2003 23:19:55 +0000 |
| Subject: | Re: Request 2 never give me results back ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144731@lists.php.net to get a copy of this message | ||
*This message was transferred with a trial version of CommuniGate(tm) Pro*
David,
Where the script has
$resultat2 = mysql_query($sql2);
change it to
$resultat2 = mysql_query($sql2) or die('error @ $reulstat2: '.mysql_error().' $sql2: '.$sql2);
See what the response is from that. IF there is no response then the query is correct and your just mining for the data wrong, if not, it will tell you approximately where the error is.
HTH,
Rolf Brusletto
rbrusletto@phpexamples.net
www.phpexamples.net
David D wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I m using apache 1.3.24, php 420 mysql 410 under windows, and when doing the 2nd query i cant get results ? The scripts blocks mysql_connect('localhost','root',''); $wfid='demo'; //4 test $sql="SELECT wfid FROM wfn.T_Groups where gid=(select gid FROM wfn.T_Groups where wfid='$wfid')"; // give wfid that belongs to same group $resultat = mysql_query($sql); $dbprefix='Job_'; $sql2 = "select Value from $dbprefix$wfid.T_Config where Name='SiteName'"; // try to get some specif data :( $resultat2 = mysql_query($sql2); Thanks.