Search found 10 matches

by mis2o
Fri Feb 27, 2004 8:24 am
Forum: Databases
Topic: comparing integers in mySQL query doesn't work
Replies: 3
Views: 449

type and region are of type TINYINT(as the site is supposed to work in multiply languages and each integer stands for a different type, region). this doesn't cause the trouble, i think "<", ">" comparison doesn't work for some reason.
by mis2o
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...
by mis2o
Mon Feb 16, 2004 2:00 am
Forum: Databases
Topic: creating temp table from results of 2 static tables
Replies: 2
Views: 432

i checked it and privilegies are the same. meanwhile i have changed the code to show mysql_error() and it says i've got error in syntax. it seems it doesn't like those two queries separated by a semicolon(it says "You have an error in your SQL syntax near ';SELECT * FROM rent' at line 1" -...
by mis2o
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'])...
by mis2o
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...
by mis2o
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_...
by mis2o
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...
by mis2o
Sun Dec 14, 2003 12:52 pm
Forum: PHP - Code
Topic: adding INPUT form fields by users
Replies: 4
Views: 943

thanx a lot, i haven't tried it yet, but it looks good.
by mis2o
Sun Dec 14, 2003 7:46 am
Forum: PHP - Code
Topic: adding INPUT form fields by users
Replies: 4
Views: 943

thank you, but do you know any PHP only solution(without using javascript?)
by mis2o
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...