Ad:

PHP Discussion Thread
Unsolved
Views: 2611

Apr 11th, 2007

mysql_fetch_array random problem?

Expand Post »

Hello all,

I have been using mysql_fetch_array to read data from a query to a php array so i can then use it on my webpage. Everything was going fine until now...

I cant see the problem with my code, but it keeps calling the or die() error handler when trying to get the array. here is the code:

PHP Syntax (Toggle Plain Text)
 
$sqlProject = "select * from project where ProjectName='.$pName.';";
                          $queryProject = mysql_query($sqlProject) or die("query Project error ");
                          $workType= Array();
 
                          while($proj = mysql_fetch_array($queryProject) or die("error in fetch array")){
$sqlProject = "select * from project where ProjectName='.$pName.';";
                          $queryProject = mysql_query($sqlProject) or die("query Project error ");
                          $workType= Array();
                         
                          while($proj = mysql_fetch_array($queryProject) or die("error in fetch array")){

the $pName variable is being passed to the sql statment fine and the mysql_query($sqlProject) statment isnt throwing any errors, but the mysql_fetch_array() is! it wont throw any mysql_error() messages in the die() handler, just a string to let me know something is wrong.

Does this mean its a php problem and not a mysql problem?

I am totally lost/confused with this... please help me!

thx

Mike

Similar Threads

More problems with the comp. hanging in the POST, please help in Motherboards, CPUs and RAM
Outlook not receiving new mail in Windows NT / 2000 / XP
Help Page Error,Hijack log inside in Viruses, Spyware and other Nasties
Random problem... cant access passworded sites in Windows NT / 2000 / XP
PC going blank randonmly HELP in Windows NT / 2000 / XP

mikesowerbutts

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Jan 2007

Permalink

Apr 12th, 2007

Re: mysql_fetch_array random problem?

Are you sure the query is returning results? Are the results an array?

print_r($sqlProject); so you know the query looks lik you think it should. Try running that query in phpMyAdmin and see what the results are, that may help you figure out what's going on.

You may need to add the resource link to the query: mysql_query($sqlProject, $link); This link is made using mysql_connect() so look for :

$somename = mysql_connect(login stuff...);

and then you wound want to have it:

$queryProject = mysql_query($sqlProject, $somename)...

DanceInstructor

Reputation Points: 17

Solved Threads: 14

Posting Whiz

Offline

355 posts
since Feb 2005

Permalink

Apr 12th, 2007

Re: mysql_fetch_array random problem?

Hi there,

I managed to fix the problem. the $pName variable needed some white space trimming from the end and I used the LIKE %varname% operator instead of =.

cheers for the halp though

mikesowerbutts

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Jan 2007

Permalink

Apr 16th, 2007

Re: mysql_fetch_array random problem?

Beat me to it. Was gonna say the problem is in the value of your pName variable which was likely causing an incorrect query string, hence no result.

ah bugger, this was over 4 days ago.

Last edited by Phaelax; Apr 16th, 2007 at 6:29 pm.

Phaelax

Reputation Points: 92

Solved Threads: 51

Practically a Posting Shark

Offline

856 posts
since Mar 2004

Permalink

Apr 17th, 2007

Re: mysql_fetch_array random problem?

cheers anyway dude!

mikesowerbutts

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Jan 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Quote form

Next Thread in PHP Forum Timeline: tidy

DaniWeb Message

Cancel Changes

User Name
Password