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.