Beginner PHP Tutorial - 115 - SELECT Part 1

All msql tags used in thesw tutorials are outdated.

$con = mysql_connect("localhost" ,"root" , "");
if(!$con){die(" could not conect".mysql_error());}
mysql_select_db("boston" ,$con );

Ok.. And what if I want to log in as different user with different privileges. I tried to create new user in phpmyadmin but when I change name and password in php file it always end up with error

i got an query failed didnt notice i did not use this `

use backticks ` inside query these are not single-quotes or an apostrophe!

Awesome tutorials, it's great! :))))

i type on an international keyboard. I have like a bunch of characters ,' ńǹ , sorry i forgot that.

hes talking about when using PHP code. You will have to use something like this to use an apostrophe; echo ('don'/t')

ALEX YOU FUCKIN ROCK!

hrd to tell from that but it looks likse you're using single inverted commas rather than backticks. it's a bit naughty but easier to leave them off - SELECT food, calories FROM food you don't need order by id, it's the default sort field.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''food' ORDER BY 'id'' at line 1 $query = "SELECT 'food', 'calories' FROM 'food' ORDER BY 'id' ";

he does that to let you know that the file is being included into another file.

Just for tutorial Purposes.

Connect 'OK' , 'Query failed'

remember that single quotes are not apostrophes. There is a difference and I made the mistake. Look out for that.

@LetsSpotIt it stands for "include". like an "include" file that index.php needs. either "include" or "require".. same thing.

what does 'inc' stand for in the file name?

Should of set healthy_unhealthy to U by default just like real life :p

its not working for me... it only sends me to the index of php?

@Dalwanaage Cause he doesn't proper sense at all.

great tut

Why using bad language please.