hi forum

I'm now switching from vb to php.. and i'm having problem getting this code to work.. it's suppose to query result from an input but instead, i get a " parse error"..

Pls. see:

<?php
$connection = mysql_connect("localhost", "User", "Password") or die("Error connecting to db");
mysql_select_db("mydb", $connection);
$sql = "select Username, Date from MyTable where Username = '" & $_POST["username"];
$result = mysql_query($sql, $connection) or die("error querying database");

"some code to display result.................."
?>


Pls. help.

Does it by any chance spew out
line numbers along with the error?


Cheers,
Tink

hi

yes it does.. line number 15 = to the line:

$sql = "select Username, Date from MyTable where Username = '" & $_POST["username"];


tnx for your time

Haven't got that much PHP-experience, but ...

I think that the & bit you in the arse :}

Bloody VB ;) ... all decent languages use
"+" for string concatenation.
/me runs for cover ...

And I'm not sure about that singlequote, either...
And you may need a closing quote behind
_POST["username"] too...

Cheers,
Tink

hi

editing the line to this one:
$sql = "select Username, Date from MyTable where Username = $_POST["username"]";

it produced ang error:

Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/myphp.php on line ..

tnx

php uses a "." (period) for concatenation.

so try this...

hi all

the code works great.. thank you all