[SOLVED] Very Small PHP / SQL Problem

[grahamb314]

Hi all,

 

I`m looking for a query that Selects all from table where field = 'thistext' AND field2 = 'thistext2 AND field3 = 2thistext3'

 

I hope you get what I mean!

 

 

[Maq]

SELECT * FROM table WHERE field = 'thistext' AND field2 = 'thistext2 AND field3 = 'thistext3'

[grahamb314]

SELECT * FROM table WHERE field = 'thistext' AND field2 = 'thistext2 AND field3 = 'thistext3'

 

As simple as that! - I`ll give it a try

 

thanks

[realjumper]

I'm not exactly sure what you mean but:

 

// Retrieve all the data from the table
$result = mysql_query("SELECT * FROM table WHERE field = 'thistext' && field2 = 'thistext2' && field3 = 'thistext3'") 
or die(mysql_error()); 

// store the record of the table into $row          
$row= mysql_fetch_array( $result ); 

[Maq]

That just grabs and stores all the info.  If you want to display something then you have to go off of what realjumper posted. Let me know if that's what you want to do.

[grahamb314]

Thanks everyone for your input,

I didnt know AND is the same as && in php,

 

Works a treat!

 

Thanks again

 

[Maq]

Glad I could help