-----------------------------------

DanShadow

Thu Jun 09, 2011 12:25 pm


select statement wont produce result..

-----------------------------------

Hello there!

I am currently doing some work for a client, but have run into a bit of an issue.
I am trying to retrieve a specific row from a table, by using a SELECT statement with a WHERE clause, but am not receiving a result at all!

Does anybody have any idea why this is producing no result (no error either)?



$query = "select * from registration where username='$username' and password='$password' and account_status='1'";

$result = mysql_query($query);
$total = mysql_num_rows($result);
$ress = mysql_fetch_object($result);

//Retrieve user ID
while($row = mysql_fetch_array($result))
{ 
  $user_id = $row

Thanks!!!!


-----------------------------------

Tony

Thu Jun 09, 2011 12:39 pm


RE:select statement wont produce result..

-----------------------------------

Have you tried that with:
[code]
$username = "foo' or 1=1; --"
[/code]
:lol:

The other question being: is there anything actual in the database to be selected? Database questions make more sense with samples of queries and outputs from the mysql console on a test database, not php code.


-----------------------------------

DanShadow

Thu Jun 09, 2011 12:58 pm


Re: select statement wont produce result..

-----------------------------------

Here is a little more information, heh.


username VARCHAR
password VARCHAR
id INT NOT NULL
account_status INT



$query = "select * from registration where username='testaccount' and password='asdf' and account_status='1'"; 

$result = mysql_query($query); 
$total = mysql_num_rows($result); 
$ress = mysql_fetch_object($result); 

//Retrieve user ID 
while($row = mysql_fetch_array($result)) 
{ 
$user_id = $row

Attempts to select a unique record (where the username 'testaccount' makes it unique) in the database, and take the row "id" (which will always be NOT NULL) and store it in the variable "$user_id".

The only result I get is.. nothing. ""

I've verified the record in the database, that the username, password, and account_status are all correct, and that the id is not null, and there.

Still, whenever I try to query for the id I get a blank result.

Me = puzzled, lol


-----------------------------------

DemonWasp

Thu Jun 09, 2011 1:39 pm


RE:select statement wont produce result..

-----------------------------------

Just a guess (not an SQL pro) but given as account_status is an INT, shouldn't you NOT quote the value 1 in your query?


-----------------------------------

DanShadow

Thu Jun 09, 2011 3:15 pm


RE:select statement wont produce result..

-----------------------------------

Heh, good call. I removed the quotes, but the problem still remains the same =/.

Is there perhaps another way I should be using for fetching the row data from the query result?


-----------------------------------

Tony

Thu Jun 09, 2011 3:16 pm


RE:select statement wont produce result..

-----------------------------------

So just to be clear, that query returns results when ran directly against the database, but fails to produce results when wrapped in PHP?


-----------------------------------

DanShadow

Thu Jun 09, 2011 3:53 pm


Re: select statement wont produce result..

-----------------------------------

Sorry I think I mis-worded my request >.<

The SELECT query succeeds, and the result is currect.

But when trying to retrieve the 'id' by using mysql_fetch, the $row["id"] produces a blank result, even though the actual query result has the correct rows.

My assumption is the way I am trying to retrieve the data from the row "id", and store it in a PHP variable is causing me to get a blank result.

Sorry about the confusion!


-----------------------------------

DanShadow

Thu Jun 09, 2011 11:01 pm


RE:select statement wont produce result..

-----------------------------------

I figured out the problem, of course something so simple as a syntax error -_-.

It was $row['id'] not $row["id"].

Thanks for the help/quick responses guys!!


-----------------------------------

Tony

Thu Jun 09, 2011 11:08 pm


RE:select statement wont produce result..

-----------------------------------

wait, 'id' and "id" are not the same thing? PHP continues to blow my mind.


-----------------------------------

DemonWasp

Fri Jun 10, 2011 12:29 am


RE:select statement wont produce result..

-----------------------------------

Well...in several languages, single-quotes mean a single character, double quotes mean a string. But then in JSON and YAML, they both mean string. Why they would be so subtly different (both mean strings, except not quite) in PHP is just another PHP-ism.


-----------------------------------

2goto1

Fri Jun 10, 2011 5:03 am


RE:select statement wont produce result..

-----------------------------------

I've always wondered why languages don't support implicit conversion from their character to string types at compilation or runtime, when the types are different.