parse error, unexpected T_STRING

bigfunkychief

Thanks for your patience. I've scoured the web and can't find my mistake...I'm sure it's something stupid!

Here's the code...thanks in advance...

<?php
$host="localhost";
$user="root";
$password="";

$connection = mysql_connect($host,$user,$password);

mysql_select_db("items",$connection);

mysql_query("INSERT INTO items (foodName) VALUES ("Rice")");

?>
</body>
</html>

lanjoky

where u have
mysql_query("INSERT INTO items (foodName) VALUES ("Rice")");

Change to
mysql_query("INSERT INTO items (foodName) VALUES ('Rice')");

bigfunkychief

Hmm..I wonder if I have a different problem now....if I manually type in the INSERT INTO line into a mysql prompt, it updates the table...but it's not working from the .php ....

bigfunkychief

Right now I have one row of data....under column foodName, the only data is POTATO.

Should this show me that data?

<?php
$host="127.0.0.1";
$user="root";
$password="";

$connection = mysql_connect($host,$user,$password);

mysql_select_db("items",$connection);
$result = mysql_query("select * from items");
echo($result);
?>

bigfunkychief

Wow...I really am a newbie. I figured it out...I'm embarrased to say what it was!

Thanks for the help though...sorry I'm such a rookie.

My database name was wrong.....yes....I am an idiot 🙂

HalfaBee

Originally posted by bigfunkychief

$result = mysql_query("select * from items");
echo($result);
?>

Probably too late for this.
This won't work.

Try

$result = mysql_query("select * from items");
$row = mysql_fetch_array( $result );
print_r($row);

HalfaBee

bigfunkychief

You're right. Thanks very much!