Page 1 of 1

Query setting for OES environment. HELP!!!!

Posted: Wed Jul 06, 2005 4:24 am
by reana
Hullo folks, I'm a newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'&quote;;
  $qdata=mysqI am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'&quote;;
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could ols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

&lt;?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'&quoand I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

&lt;?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'&quote;;
  $qdata=mysql_query($qdata,$db);
?&gt;


O newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it mng a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

&lt;?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'& this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

&lt;?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'&quote;;
  $qdata=mysql_query($qdm Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQhope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQtiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct scree me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.
newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Pd to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQ newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC em here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please ad a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody pusing Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>
newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advisetabase and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to he 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's anyWindows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particula hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQcorrect response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscre here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db)s server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

&lt;?php
  $qdata=&quote;SELECT * FROM Group_Member WHERE idnum='$idnum'&quote;;
  $qdata=mysql_query($qdata,$db);
?&gt;


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Coullem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

&lt;?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $q newbie. OK I have this problem here and I hope somebody can help me.

See, I am developing a system using Apache2/OES as server, MY SQL database and coding in PHP4. Now the problem is,the system failed to give the correct response on ALL of the 'SELECT' condition with '=' symbols. But this only happens when I initiate the query from Windows based PC with OES as server. On normal (Windows PC and Windows based server), the system gives the correct response. Ditto, the system gives correct response for other 'general' queries (i.e. those without the '=' symbols).

An example of my query is

Code: Select all

getdetails.php?idnum=820717115424
In which 820717115424 is an unique ID with a valid record/details in My SQL database. (To prove this, I initiate the same query from Windows based PC to Windows based server, and confirmed that I am able to see the details for that particular ID).

Below is a sample of my coding :-

Code: Select all

<?php
  $qdata="SELECT * FROM Group_Member WHERE idnum='$idnum'";
  $qdata=mysql_query($qdata,$db);
?>


On this query, the system is suuposed to grab relevant data and display onscreen. As it happens, it moves to the correct screen but with empty data. I am unable to see any error.

Could somebody please advise if there's any special definitions esp for Windows Clients to OES platform ? Please, please advise.

TQ

Posted: Wed Jul 06, 2005 4:37 am
by timvw
I bet my money on "register_globals=off" in the php configuration

Posted: Wed Jul 06, 2005 4:49 am
by reana
Hey timvw,

You know what, I'm gonna try it...Thanks for your advise.

Cheers
:lol:

Posted: Wed Jul 06, 2005 5:26 am
by reana
Hi Timvw,

One question though, where do I set the register_globals=off ? Is it in the Apache2/httpd.conf file or other files ? Maybe I am simply too strung out or maybe coz I need a new pair of glasses(or eyes!), but I am unable to find register_globals params. Please advise...

TQ! :oops:

Posted: Wed Jul 06, 2005 5:36 am
by timvw