Search found 7 matches

by NEO1976
Wed Dec 13, 2006 5:20 pm
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

That's it! Sorry it is now midnight here I am a bit sleepy. I couldn't get it first what you meant. Ok the problem is solved. I just want to write my php codes down again to show the others the solutions. trial.php: <?php /* * Created on 12.11.2006 * * To change the template for this generated file ...
by NEO1976
Wed Dec 13, 2006 4:21 pm
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

I thought I should have used the table name as SELECT value. So how should I correct this error? I cannot define the $value variable outside the while loop and I want to send this $value variable via POST in order to use it in my SQL query in trial1.php. Sorry I know I am asking too many questions. ...
by NEO1976
Wed Dec 13, 2006 4:08 pm
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

Ok I closed it but it doesn't still pass the variable via POST. trial.php: <?php /* * Created on 12.11.2006 * * To change the template for this generated file go to * Window - Preferences - PHPeclipse - PHP - Code Templates */ $link = mysql_connect('localhost','root','admin'); $db = mysql_select_db(...
by NEO1976
Wed Dec 13, 2006 3:39 pm
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

Thanks feyd. At least I don't meet any error messages now but althought it takes the $value variable in trial.php it doesn`t send it to trial1.php via post. This is my code chunk from trial.php $sqlquery = "select * from t_kurse ORDER BY KURSE_NAME"; $res = mysql_query($sqlquery); echo &qu...
by NEO1976
Wed Dec 13, 2006 7:56 am
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

Thanks feyd. As an ASP and JSP programmer I am a bit new to PHP. You have written SELECT t_institute.INS_NAME FROM t_institute INNER JOIN t_ins_kurse ON t_institute.INS_CODE = t_ins_kurse.INS_CODE INNER JOIN t_kurse ON t_ins_kurse.KURSE_CODE = t_kurse.KURSE_CODE AND t_kurse.KURSE_CODE = 'foo' is thi...
by NEO1976
Wed Dec 13, 2006 6:28 am
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

Thanks feyd. The fact is the user doesn't need to log in. What I also wanted to if my first php file is right. My aim is to get the $value variable from tiral.php voe HTTP POST and to use it in the trial1.php to get the results.
by NEO1976
Tue Dec 12, 2006 3:11 pm
Forum: Databases
Topic: Search a database table with a combobox value (solved)
Replies: 12
Views: 1352

Search a database table with a combobox value (solved)

Hallo guys, I am a bit new (not a novice but also not a big expert) in PHP5 and MySQL. First of all if there is a similar thread or topic I am sorry for that topic. Unfortunately, I don't have much time to explore through the foren. What I did is first of all I have created a DB named fernschule It ...