• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 730
  • Last Modified:

mysql_fetch_row wrong parameter count

My code works when using it in windows but not in linux

I checked the mysql version the one in windows = MySQL client version: 5.1.41
The one in linux = MySQL client version: 5.0.67

In windows it fills all the values as it should
In linux the fields remain empty

If i remove the second parameter then the warning is gone but then it does not work in windows anymore either

This is the actual error:
Wrong parameter count for mysql_fetch_row() in /public_html/_test/profile.php on line 22

See the attached code that results in the error

Anyone know why this happens?

// Zet het resultaat in een variabele

Open in new window

  • 2
  • 2
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:

--so, you either want:

-- or you want:

Open in new window

Guy Hengel [angelIII / a3]Billing EngineerCommented:
the second argument you tried is used in mysql_fetch_array:
Just a point: do you really need the number of rows prior to get the results ? If you want just the number of rows, have you considered to make a "SELECT count(*)" statement ?
PeterdeBAuthor Commented:
I did study the [ link to the ] function, but could not make it work, yours works at once angelll

@One question though, why did the false declaration work in windows? Was that because of the difference in version?

@Qplana i just needed the result of one row, i had been busy with the select * count code for all of this morning but could not get it to work, so im glad this one works now, though it might not be the best solution
PeterdeBAuthor Commented:
Thanks for your fast and to-the-point answer, forgive me for my newbie answers, im new to this
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now