Passing MySQL field 1

[humbleprogrammer]

Hello,

I am probably missing something obvious but can someone please help me trouble shoot this code. I am trying to pass the office value stored in the table in the querystring but it's not working. Thanks in advance!

<?php
	include(&quot;Connection.php&quot;);
	$strQuery = &quot;SELECT * FROM tblUsers WHERE username = '&quot;.$frmUsername.&quot;' AND password = '&quot;.$frmPassword.&quot;'&quot;;
	$row = mysql_query($strQuery) or die(&quot;Error&quot;.mysql_error());
	$office=$row['office'];
	if(mysql_num_rows($row)) {
	
		print(&quot;<br><br><b>Welcome, $frmUsername!<br><br><a href=dateselection.php?username=$frmUsername&office=$office>CLICK HERE</a> to view the reports for your office&quot;);
		
	} 
	
	else {
	 	print(&quot;<br><br><b>Sorry, this login is invalid!</b><br><br>Please <a href='login.php'>GO BACK</a> and try again.&quot;);
	exit;
	}		
?>

http://www.gosmart4u.com/

 

[sleipnir214]

Output your query and examine it by hand. Does it look right?

If you copy and paste that query into your favorite MySQL arbitrary query tool, does it return the values you expect?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[humbleprogrammer]

Hello - thanks for your response. The query outputs correctly and I ran the sql statement in PhpAdmin and it returned the correct result. I did a print command for $strQuery and also $office to see what it returned. $strQuery displayed the correct sql statement but $office didn't display anything. Any ideas?

Thanks!

http://www.gosmart4u.com/

 

[sleipnir214]

Part of it is that you missed one of the steps for making MySQL data available to PHP -- you never fetched the result set from the database server.

Somewhere between these two lines:

$row = mysql_query($strQuery) or die("Error".mysql_error());
$office=$row['office'];

You need to invoke one of PHP's mysql_fetch_*() functions: mysql_fetch_row(), mysql_fetch_assoc{}, mysql_fetch_array(), or mysql_fetch_object().

Without that, the data will just sit on the MySQL server side, unavailable to PHP.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[humbleprogrammer]

Thanks sleipnir214!

http://www.gosmart4u.com/