No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I am pretty new to php, and trying to work with dates right now from a mysql table, the idea is that I want a table to update every week to show what is happening this week. The dates are stored in the mysql table in $table labled as date … |
|
I was wondering if there was a contains word to use with a mysql query, my current query is : //$query="SELECT * FROM $table WHERE date = '$selecteddate' AND Style = '$selectedstyle' AND Platform = '$selectedplatform'"; but the $selectedplatform isn't always the only thing in the Platform column, I just … |
|
The code: [CODE = php] $selecteddate = $_POST['Releasedate']; $selectedplatform =$_POST['Platform']; $selectedstyle = $_POST['style']; $query="SELECT * FROM $table WHERE date = '$selecteddate'AND Style = '$selectedstyle'AND Platform = '$selectedplatform'"; [/CODE] Ok, the code works if someone picks something for all 3 of the items, so all of the code works, but if … |
|
This is a rookie question and don't really know how to word it so that google finds me an answer, but can someone give me an example of a query using multiple WHERE restrictions so I can see how to format my query? |
|
Ok so I am a rookie in php and working on populating drop down lists from a mysql database. I have a drop down list working that contains words, but my drop down list for my date refuses to work and I don't know what the difference between them should … |