Query setting for OES environment. HELP!!!!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
reana
Forum Newbie
Posts: 7
Joined: Wed Jul 06, 2005 3:33 am

Query setting for OES environment. HELP!!!!

Post 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
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

I bet my money on "register_globals=off" in the php configuration
reana
Forum Newbie
Posts: 7
Joined: Wed Jul 06, 2005 3:33 am

Post by reana »

Hey timvw,

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

Cheers
:lol:
reana
Forum Newbie
Posts: 7
Joined: Wed Jul 06, 2005 3:33 am

Post 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:
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Post Reply