Querying errors - Codewalkers

Codewalkers Forums Sponsor:

October 27th, 2002, 10:24 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Querying errors

Im going away from post nuke and need the content of the user database. I will put in a new database.
I have made several attempts to retrive the data, the following code is best yet.
Im sure its a simple problem to solve, but I just dont get it.

php Code:

Original - php Code
$result = mysql_query("SELECT `pn_name`,`pn_uname`,`pn_email`,`pn_url`,`pn_user_ regdate`,`pn_user_icq`,`pn_user_from`,`pn_user_int rest`,`pn_user_aim`,`pn_user_yim`,`pn_user_msnm`,` pn_pass`,`pn_timezone_offset` FROM nuke_users WHERE pn_uname='$uname'",$db); $myrow = mysql_fetch_array($result); echo "First Name: ".$myrow["pn_uname"];

 
 
$result = mysql_query("SELECT `pn_name`,`pn_uname`,`pn_email`,`pn_url`,`pn_user_  regdate`,`pn_user_icq`,`pn_user_from`,`pn_user_int  rest`,`pn_user_aim`,`pn_user_yim`,`pn_user_msnm`,`  pn_pass`,`pn_timezone_offset` FROM nuke_users WHERE pn_uname='$uname'",$db);
 
$myrow = mysql_fetch_array($result);
 
echo "First Name: ".$myrow["pn_uname"];

How come I get

Warning: Supplied argument is not a valid MySQL result resource in /home/zenantho/public_html/transfer.php on line 22

Line 22 is

php Code:

Original - php Code
$myrow = mysql_fetch_array($result);

$myrow = mysql_fetch_array($result);

I have also tried

php Code:

Original - php Code
$result = mysql_query("SELECT * FROM nuke_users WHERE pn_uname='$uname'",$db);

$result = mysql_query("SELECT * FROM nuke_users WHERE pn_uname='$uname'",$db);

October 28th, 2002, 12:02 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Querying errors

Try running those queries directly against the database. Use phpMyAdmin or something similar....

October 28th, 2002, 04:48 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Querying errors

The query works fine in phpmyadmin. However, for some reason selecting a database helps a lot

Viewing: Codewalkers Forums > Other Technologies > Database Help > Querying errors

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump