[PHP] Difficulty with SQL LIKE clause

When I use this query in PHP it works, and I get all things with the YEAR of 1977, as I expected. $query= "SELECT * FROM my_table WHERE Year LIKE 1977 "; But, when I use this query it does not work. $query= "SELECT * FROM my_table WHERE Year LIKE 197* "; I thought I should get the result of ALL

[PHP] [NEWBIE] Cant get $_POST to work

I have this simple form file: Name: Age: Which passes (I wish!) data to this script: It does not work unless I turn register_globals ON in the php.ini file. The php documentation leads me to believe this script SHOULD work with register_globals OFF. This a NEW instasllation of the

[PHP] I got it working

I created a new user, and assigned privileges. Then tried to connect to the server and was denied access, because of a conflict between the mysql CLIENT version and the mysql server code due to the password encryption scheme installed in version 4.1 of mysql. Running the following line fixed the pr

[PHP] My FIRST php atempt

I am trying my FIRST php file with an attempt to connect to my mySql server. The problem is it won't connect to the database. The server IS running. The host, username, and password are the exact same thing I use to connect the mySqlAdmin tool to the database. Doesn't seem like this should be th

[PHP] login error to mySQL from PHP

I am attempting to install both phpMyAdmin and phpLens. When attempting to connect to the mySql server I get the following error message: "Unable to connect. Please click on Previous and correct. [Client does not support authentication protocol requested by server; consider upgrading MySQL client