Re: Request 2 never give me results back ?
| From: | David D | Date: | Mon, 21 Apr 2003 23:16:48 +0000 |
| Subject: | Re: Request 2 never give me results back ? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144739@lists.php.net to get a copy of this message | ||
Hi,
I m trying to do some new queries that mysql 410 support.
But It doesnt finish its job, no die ? The server eat about 40mb of memory
eat no cpu ?
The 2nd query seems to be fatal :
$resultat2 = mysql_query($sql2) or die('error @ $reulstat2:
'.mysql_error().' $sql2: '.$sql2);
nothing die ? So it is a mysql pb ?
Here is my php script :
<?php
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')";
$resultat = mysql_query($sql) or die('error @ $reulstat: '.mysql_error().'
$sql: '.$sql);
while ($enr=mysql_fetch_array($resultat)) print_r($enr);
$dbprefix='Job_';
$sql2 = "select Value from $dbprefix$wfid.T_Config where Name='SiteName'";
$resultat2 = mysql_query($sql2) or die('error @ $reulstat2:
'.mysql_error().' $sql2: '.$sql2);
print_r(mysql_fetch_array($resultat2));
?>
# MySQL-Front Dump 2.5
#
# Host: localhost Database: wfn
# --------------------------------------------------------
# Server version 4.1.0-alpha-max-debug
USE wfn;
DROP TABLE IF EXISTS
t_groups;
CREATE TABLE t_groups (
gid tinyint(3) unsigned NOT NULL default '0',
wfid varchar(50) NOT NULL default '',
type varchar(20) default NULL,
KEY gid (gid)
) TYPE=MyISAM CHARSET=latin1;
INSERT INTO t_groups VALUES("1", "demo", "job");
INSERT INTO t_groups VALUES("1", "aptitudes", "job");
USE job_demo;
DROP TABLE IF EXISTS t_config;
CREATE TABLE t_config (
Rid int(11) NOT NULL auto_increment,
Name varchar(255) character set latin1 default NULL,
Value text character set latin1,
PRIMARY KEY (Rid)
) TYPE=MyISAM;
INSERT INTO t_config VALUES(2,'SiteName','Compte demo');
USE job_aptitudes;
DROP TABLE IF EXISTS t_config;
CREATE TABLE t_config (
Rid int(11) NOT NULL auto_increment,
Name varchar(255) character set latin1 default NULL,
Value text character set latin1,
PRIMARY KEY (Rid)
) TYPE=MyISAM;
INSERT INTO t_config VALUES(2,'SiteName','Compte apt');
Thanks.