echo text from sql query

[cashton2k]

i'm having trouble echoing text from the following sql query

<?php
require("auth_admin.inc.php");
require("../conn.inc.php");

$requesteduser = $_POST["username"];

$queryq1 = "Select * from user_info WHERE username = $requesteduser";

$resultq1 = mysql_query($queryq1);

?>

i've tried lots of ways todo it, which way works lol

[Jick]

Try this:

<?php
require("auth_admin.inc.php");
require("../conn.inc.php");

$requesteduser = $_POST["username"];

$queryq1 = "Select * from user_info WHERE username = $requesteduser";
$resultq1 = mysql_query($queryq1);

while($r = mysql_fetch_array($resultq1)) {
    echo($r["field-name-here"]);
}
?>

Where it says "field-name-here" you would put the name of the field in the MySQL database you want to echo.

[cashton2k]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\admin\user_trackingresults.php on line 10

[NogDog]

That error means your query failed to execute. Try adding some debugging:

$resultq1 = mysql_query($queryq1) or die("Query Failed: $queryq1 - " mysql_error()); 

[cashton2k]

Parse error: syntax error, unexpected T_STRING in C:\Program Files\Apache Group\Apache2\htdocs\admin\user_trackingresults.php on line 9

line 9 is that line ^^

$resultq1 = mysql_query($queryq1) or die("Query Failed: $queryq1 - " mysql_error());

[NogDog]

Oops!

$resultq1 = mysql_query($queryq1) or die("Query Failed: $queryq1 - " . mysql_error()); 

[cashton2k]

now i get

Query Failed: Select * from user_info WHERE chris = username - Unknown column 'chris' in 'where clause'

ive tried $requesteduser = username either way round and i get the same the error
the column should be username

[NogDog]

Try this:

$queryq1 = "Select * from user_info WHERE username = '$requesteduser'"; 

[cashton2k]

is there a way to use lots of echcos without having to do the whole sql query again? The first one works fine but then it ignores the rest