Page 1 of 1
very simple mysql question!!!
Posted: Sun Nov 22, 2009 2:41 pm
by shou0630
I know
Code: Select all
SELECT * FROM Persons
WHERE LastName='peter'
works.But how do i make a var work like???
Code: Select all
SELECT * FROM Persons
WHERE LastName='$_POST[name]'
Re: very simple mysql question!!!
Posted: Sun Nov 22, 2009 3:01 pm
by morris520
put your query as a string then pass to php func mysql_query
Code: Select all
$query = 'SELECT * FROM table WHERE id = ' . $_post['id'];
Hope this helps
Morris
Re: very simple mysql question!!!
Posted: Sun Nov 22, 2009 3:08 pm
by shou0630
oh ye i got it
Code: Select all
$result = mysql_query("SELECT * FROM games
WHERE name IN ('$_GET[search]')");
GET works POST doesn't,thanks anyway
Re: very simple mysql question!!!
Posted: Tue Nov 24, 2009 5:42 am
by morris520
depends how you send parameters through the page.