•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 392,080 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,998 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1268 | Replies: 4
 |
•
•
Join Date: Jan 2007
Posts: 12
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
mysql_fetch_array random problem? 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:
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
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:
$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: 354
Reputation:
Rep Power: 4
Solved Threads: 12
Posting Whiz
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)...
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)...
•
•
Join Date: Jan 2007
Posts: 12
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
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
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: 715
Reputation:
Rep Power: 6
Solved Threads: 28
Master Poster
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.
ah bugger, this was over 4 days ago.
Last edited by Phaelax : Apr 16th, 2007 at 5:29 pm.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
Linear Mode
Similar Threads
- More problems with the comp. hanging in the POST, please help (Motherboards, CPUs and RAM)
- Outlook not receiving new mail (Windows NT / 2000 / XP / 2003)
- Help Page Error,Hijack log inside (Viruses, Spyware and other Nasties)
- Random problem... cant access passworded sites (Windows NT / 2000 / XP / 2003)
- PC going blank randonmly HELP (Windows NT / 2000 / XP / 2003)
Other Threads in the PHP Forum
- Previous Thread: PHP Quote form
- Next Thread: tidy
