Hello,
what should i do if i want to search in a table of a database??
Not a single row but the whole table.
what should i do if i want to search in a table of a database??
Not a single row but the whole table.
Search whole database
I assume you mean multiple columns (fields) as it already searches all rows (records).
I'm afraid that you have to specify them by name. Something along the lines of;
SELECT * FROM Table WHERE Field1 = "Criteria" OR Field2 = "Criteria".
You shouldn't really ever need to search the entire table though unless you have something odd going on with your table design,.
I'm afraid that you have to specify them by name. Something along the lines of;
SELECT * FROM Table WHERE Field1 = "Criteria" OR Field2 = "Criteria".
You shouldn't really ever need to search the entire table though unless you have something odd going on with your table design,.
hi
is it something like a login where you want to find a username and password match. if so it will be something similar to this:
is it something like a login where you want to find a username and password match. if so it will be something similar to this:
| Code: |
|
<?php $login = 'login'; $pass = 'password'; mysql_query = "SELECT * FROM tableName WHERE login = '$login' AND password = '$pass'"; ?> |
If you want to make say a search page to search content on you site you can do,
The % means that anything can be on the side of it. If you wanted more you would use (fieldname like '&Query&') OR (fieldname2 like '%Query%')
| Code: |
| mysql_query = "SELECT * FROM tableName WHERE fieldName like '%Query%'"; |
The % means that anything can be on the side of it. If you wanted more you would use (fieldname like '&Query&') OR (fieldname2 like '%Query%')
Yup,
Thankyou I got my answer.
This thread can be closed now
Thankyou I got my answer.
This thread can be closed now
 |