•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 375,165 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,344 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1229 | Replies: 5
![]() |
•
•
Join Date: Nov 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Hi, Im only used to basic sql queries. wonder if anyone can help with the below - or at least get me pointing in the direction of the correct resource to solve.
I have a table, with fields a,b,c,d,e,f
I need to run a query that shows from the above table all matches to 3 conditions in this order..
display if a = condition1 and b = condition2 and e is less than or equal to the value in e
my problem is whilst Im able to write these queries seperate, Im struggling to write the query as one without getting errors.
Can anyone help - either suggest how the query should look, or point me to some resource.. many thanks.
I have a table, with fields a,b,c,d,e,f
I need to run a query that shows from the above table all matches to 3 conditions in this order..
display if a = condition1 and b = condition2 and e is less than or equal to the value in e
my problem is whilst Im able to write these queries seperate, Im struggling to write the query as one without getting errors.
Can anyone help - either suggest how the query should look, or point me to some resource.. many thanks.
•
•
Join Date: Aug 2005
Location: near St Louis, Missouri, USA
Posts: 10,199
Reputation:
Rep Power: 34
Solved Threads: 824
what have you tried? The logical query would be
but since we don't know what condition1 and condition2 are we can't give much more help. So post your actual code if you want better help.
where a = condition1 and b = condition2 and e <= somethingbut since we don't know what condition1 and condition2 are we can't give much more help. So post your actual code if you want better help.
'Politics' is made up of two words, 'poli,' which is Greek for 'many,' and 'tics,' which are blood-sucking insects.
- Gore Vidal
Being ignorant is not so much a shame as being unwilling to learn. - Benjamin Franklin
- Gore Vidal
Being ignorant is not so much a shame as being unwilling to learn. - Benjamin Franklin
•
•
Join Date: Nov 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
</form>
<?php
$condition1 = @$_GET['cond1'] ;
$condition2 = @$_GET['cond2'] ;
$condition3 = @$_GET[#cond3'] ;
mysql_connect("dbhost","dbuser","dbpass") or die("Unable to connect to server");;
mysql_select_db("dbname") or die("Unable to select database");
$query = SELECT *, from paintings where artist = condition1 and period = condition2 and value <= condition3 ;
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows == 0)
{
echo "<p>Sorry, nothing found that matches your request etc</p>";Hi, thanks for that - I think Ive posted this correct
Ive added what you suggested how I think it should be written.. it seems awfully short yet sensible - can you confirm you think I have written it correctly.. after the huge number of errors my last attempt got, I thought Id check Im understanding you prior to trying it again.
Thanks again. Especially for the quick response..
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 31
php Syntax (Toggle Plain Text)
$condition1 = @$_GET['cond1'] ; $condition2 = @$_GET['cond2'] ; $condition3 = @$_GET['cond3'] ; mysql_connect("dbhost","dbuser","dbpass") or die("Unable to connect to server"); mysql_select_db("dbname") or die("Unable to select database"); $query = sprintf(" select * from paintings where artist = '%s' and period = '%s' and value <= '%s' " , mysql_real_escape_string($condition1) , mysql_real_escape_string($condition2) , mysql_real_escape_string($condition3) ); $result = mysql_query($query);
Should look somehting more like that. Not used php for ages so it may not be work but I think you need a book and learn the basics of SQL and PHP before putting them together
Note to self... pocket cup
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Similar Threads
- Code for Deleting a Record in a database?? (Visual Basic 4 / 5 / 6)
- how to bind two item in datagrid, so that i can get details of 2 in details (ASP.NET)
- Trying to use LIKE statement on JOIN query (MySQL)
- how to access dropdown list entries in python psp site (Python)
- if statement didnt work as expected (C)
- how to select null values in condition (MySQL)
- Waiting Room Access DB (Visual Basic 4 / 5 / 6)
- probelm with autogenerated mysql query (PHP)
- problem with autogenerated mysql query (MySQL)
- Querying within the results of a previous query? (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: Help in Join table
- Next Thread: Problem on IF STATEMENT on TRIGGER with MySql



Linear Mode