Jump to content

why won't this work? Seems simple enough


Guest

Recommended Posts

$sql = 'SELECT * FROM account_info WHERE username ="'.$name.'"';
$result = mysql_query($sql) . mysql_error();
$row = mysql_fetch_row($result);

 

I get

 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

 

I'm trying to output the row "wins" for a certain user.

Link to comment
https://forums.phpfreaks.com/topic/217957-why-wont-this-work-seems-simple-enough/
Share on other sites

$result = mysql_query($sql) . mysql_error();

 

^^^ By concatenating msyql_error() with the result of the mysql_query() in the above line of code, you are likely corrupting the value being put into $result.

 

That line of code should be as follows to get it to display the mysql_error() value if the query fails -

 

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

Archived

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

×
×
  • Create New...

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.