Search found 10 matches
- Fri Feb 27, 2004 8:24 am
- Forum: Databases
- Topic: comparing integers in mySQL query doesn't work
- Replies: 3
- Views: 449
- Fri Feb 27, 2004 4:42 am
- Forum: Databases
- Topic: comparing integers in mySQL query doesn't work
- Replies: 3
- Views: 449
comparing integers in mySQL query doesn't work
hi, i have a problem comparing some integer values in query. i get no error but php "mysql_num_rows" always returns zero despite it shouldn't. i need to do a search in table, filtering things like region, type, price etc. Filtrering things which have "=" in query works, but using...
- Mon Feb 16, 2004 2:00 am
- Forum: Databases
- Topic: creating temp table from results of 2 static tables
- Replies: 2
- Views: 432
- Sun Feb 15, 2004 12:33 pm
- Forum: Databases
- Topic: creating temp table from results of 2 static tables
- Replies: 2
- Views: 432
creating temp table from results of 2 static tables
hi, i need to create a temporary (mysql) table which contains results from 2 static tables. i use this code, where $_SESSION['query_one'] and $_SESSION['query_two'] contain select query strings for table1 and table2: <?php $joined_query = ($_SESSION['query_one'].";".$_SESSION['query_two'])...
- Sat Feb 14, 2004 2:36 pm
- Forum: PHP - Code
- Topic: temporary table containing results from 2 static tables
- Replies: 2
- Views: 324
i read in mysql manual that UNION is implemented in MySQL 4 only. i use mysql 3.23.39 to develop becouse it runs on the server i write the application for. however, i think that the query1;query2 syntax should work but maybe it doesn't work with CREATE TABLE. don't you know of other way of working i...
- Sat Feb 14, 2004 12:58 pm
- Forum: PHP - Code
- Topic: temporary table containing results from 2 static tables
- Replies: 2
- Views: 324
temporary table containing results from 2 static tables
hi, i need to create a temporary table which contains results from 2 static tables. i use this code, where $_SESSION['query_one'] and $_SESSION['query_two'] contain select query strings for table1 and table2: <?php $joined_query = ($_SESSION['query_one'].";".$_SESSION['query_two']); $temp_...
- Sat Feb 14, 2004 7:28 am
- Forum: PHP - Code
- Topic: 5 results per page with 2 mysql tables
- Replies: 1
- Views: 301
5 results per page with 2 mysql tables
hi, i don't know how to solve this: i need to create a code that will show 5 results from mysql database per page. i know how to make it when with single mysql table - i used mysql LIMIT in query. but how i've got 2 tables. i think i have to call 2 queries, one for table1, second for table2. then jo...
- Sun Dec 14, 2003 12:52 pm
- Forum: PHP - Code
- Topic: adding INPUT form fields by users
- Replies: 4
- Views: 943
- Sun Dec 14, 2003 7:46 am
- Forum: PHP - Code
- Topic: adding INPUT form fields by users
- Replies: 4
- Views: 943
- Sat Dec 13, 2003 2:04 pm
- Forum: PHP - Code
- Topic: adding INPUT form fields by users
- Replies: 4
- Views: 943
adding INPUT form fields by users
hi, i need to achieve that the user could ADD blank input form fields into a form in a way that the fields that he has already edited remain remembered and display themselves on the screen together with a new blank input field. i was thinking about one way to solve it, but can't implement it. my ide...