DaniWeb Forum Index > Web Development > PHP

mysql_fetch_array random problem?

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jan 2007

Posts: 12

Reputation: mikesowerbutts is an unknown quantity at this point

Solved Threads: 0

mikesowerbutts mikesowerbutts is offline

Offline

Newbie Poster

mysql_fetch_array random problem?

Apr 11th, 2007

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:

 Help with Code Tags 
 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

•

Join Date: Feb 2005

Posts: 355

Reputation: DanceInstructor is an unknown quantity at this point

Solved Threads: 14

DanceInstructor DanceInstructor is offline

Offline

Posting Whiz

Re: mysql_fetch_array random problem?

Apr 12th, 2007

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)...

Clear Mind Hosting and Web Design

If I've helped you please consider adding to my reputation.

•

Join Date: Jan 2007

Posts: 12

Reputation: mikesowerbutts is an unknown quantity at this point

Solved Threads: 0

mikesowerbutts mikesowerbutts is offline

Offline

Newbie Poster

Re: mysql_fetch_array random problem?

Apr 12th, 2007

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

•

Join Date: Mar 2004

Posts: 763

Reputation: Phaelax is on a distinguished road

Solved Threads: 38

Phaelax

Offline

Master Poster

Re: mysql_fetch_array random problem?

Apr 16th, 2007

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.