php within a query

CoryMathews · 12-07-2007, 04:32 AM

I couldnt seem to figure this out on my own and google was not being my friend on this one.

Im trying to do a normal MySQL query but with a php if inside it. sounds simple enough ive done it in coldfusion multiple times just cant get the syntax for it in php. Example

PHP Code:


			
$result = mysql_query(" 

select * 

from $dbName 

//Next Line 

Where if(isset($cat) { $cat = '1' } 

order by updated DESC, time DESC 

LIMIT $from, $max_results");

That Where clause is my problem. but i think i got the point across of what im needing.

Jay · 12-07-2007, 07:49 AM

You cannot have PHP code inside of a MySQL query, as far as I know. You will have to patch the query together (you can use whatever methods you like [EG: printf])

PHP Code:


			
/**
 * Hard-coded method
 */
$dbname = 'categories';
$cat = 1; // Remember this _HAS_ to be an integer
$from = 0;
$max_results = 15;

/**
 * Accept input from url
 */
$dbname = 'categories'; // this shouldn't be in the url
$cat = isset( $_REQUEST['cat'] ) ? (int)$_REQUEST['cat'] : 1;
$from = isset( $_REQUEST['from'] ) ? (int)$_REQUEST['from'] : 0;
$max_results = isset( $_REQUEST['max_results'] ) ? (int)$_REQUEST['max_results'] : 15;

$result = mysql_query('SELECT * FROM '. $dbname .' WHERE cat = '. $cat .' ORDER BY updated DESC LIMIT '. $from .','. $max_results);

I hope that helps, this is primitive

CoryMathews · 12-07-2007, 01:27 PM

thanks jay but thats not really my problem. I dont have to worry about the url variables cause its just an include and the variables are getting passed in from the page itself. But as for the code the category is a word (ex Other) and it might not always be defined. So your code would word anytime it is defined but not when the $cat is undefined. you see what i mean?

Karl · 12-07-2007, 01:36 PM

Can't you just test for the existence of $cat outside the query and then insert data if you have any...

PHP Code:


			
$szCatQuery = isset($cat) ? "WHERE $cat = 1" : '';

$result = mysql_query(" 
select * 
from $dbName 
//Next Line 
$szCatQuery
order by updated DESC, time DESC 
LIMIT $from, $max_results");

CoryMathews · 12-07-2007, 02:20 PM

thats what i was lookin for karl thanks. Never thought it would of been done like that.