Jump to content

Archived

This topic is now archived and is closed to further replies.

mysterio

error accessing mysql_fetch_row results

Recommended Posts

The following php code is failing when a valid connection to a mysql database exists. I know $row is not empty because I have verified that.

 

$result = mysql_query($sql);

$row = mysql_fetch_row($result);

$status = $row['status'];

$logincount = $row['logincount'];

 

 

$status and $logincount have no value, i.e. = '', done this way. However, the calls

 

$status = $row[3];

$logincount = $row[4];

 

work and assign the correct value to $status and $logincount. Any idea why? It's so much easier to read if you can access the values by strings and not numbers, especially if you reorder your database.

 

Share this post


Link to post
Share on other sites
What is the mysql_query?

295852[/snapback]

 

 

The query is

 

$sql = "SELECT * FROM users WHERE email = '$email' and password = '$pwd_hash' LIMIT 1";

 

The query does return a value because mysql_num_rows($sql) != 0 when I execute the query.

Share this post


Link to post
Share on other sites

change:

 $result = mysql_query($sql);

 

to

 $result = mysql_query($sql) or die(mysql_error());

 

and post back the error message u get.

Share this post


Link to post
Share on other sites

If you want to use an associative array, you need to tell mysql to give it to you.

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]

[span style=\"color:#0000BB\"]<?php

$result [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$sql[/span][span style=\"color:#007700\"]);

[/span][span style=\"color:#0000BB\"]$row [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$result[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#FF8000\"]// changed mysql_fetch_row to mysql_fetch_assoc

[/span][span style=\"color:#0000BB\"]$status [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'status\'[/span][span style=\"color:#007700\"]];  [/span][span style=\"color:#FF8000\"]// now these two lines will work

[/span][span style=\"color:#0000BB\"]$logincount [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'logincount\'[/span][span style=\"color:#007700\"]];

[/span][span style=\"color:#0000BB\"]?>

[/span]

[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

 

Ken

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.