July 23rd, 2002, 05:11 AM
|
|
Contributing User
|
|
Join Date: Apr 2007
Location: Winnipeg, MB, Canada
Posts: 81
Time spent in forums: 30 sec
Reputation Power: 2
|
|
|
RE: dynamically generate mysql queries
Quote: |
foreach($articlename && $articlenum && $date && $partnum && $model as $key => $value) |
This won't work I think. You appear to be bitwise ANDing the values together.
I think what you want is:
php Code:
 Original
- php Code |
|
|
|
<?php //this is the way I usually see the dynamic array in a foreach foreach(array($articlename, $articlenum, $date, $partnum, $model) as $value){ } //this is closer to what you want, though I am not sure if it will work foreach(array('articlename'=> $articlename, 'articlenum'=> $articlenum, 'date'=> $date, 'partnum'=> $partnum, 'model'=> $model) as $key=> $value){ //your code here } ?>
Cheers,
Keith.
Quote:
Hi all, I have a form which submits 5 variables to the script below. I would like to build some sort of array or way to catch all the variables sent as null or blank (the user left a field blank) and not include those variables in the mysql query. I have been messing with the idea of building an array of the input variables and using foreach to eliminate the null values, however it doesnt seem to be working.
ANY HELP AT ALL GREATLY APPRICATED, im stumped and going crazy =)
$query = '';
foreach($articlename && $articlenum && $date && $partnum && $model as $key => $value)
{
if(!empty($input[$key]))
{
$query .= "AND $key = $value";
}
}
mysql_connect (host,user,pass);
$result = mysql_db_query ("db","SELECT * FROM articles WHERE $query"); |
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
