I choose something from selectbox and click on the button and i get list of the data from database but, whatever i choose from selectbox doesn't remain what i have chosen. It sets itself to first...

Hi,
This code works fine but, when i choose "Female" from selectbox, it sets "Male" in the selectbox again. What is the problem?
Thanks



<?php
if (!isset($_POST["sex"])) {
print "Please...

Hi,
I want to call a stored procedure for the below php code. How can i create a stored procedure and call it for below program instead. Mysql please.
Thanks.

...

sorry

CREATE TRIGGER update_detail
BEFORE UPDATE ON product
FOR EACH ROW

IF OLD.amount<NEW.amount THEN
SET NEW.girdi = NEW.amount - OLD.amount ;
ELSEIF OLD.amount>NEW.amount THEN...

CREATE TRIGGER update_detail BEFORE UPDATE ON product
FOR EACH ROW

SET @id = select id from product;
SET @remain = select amount from product;

insert into detail (id,remain) values (@id...

Hi,

When i add new product into "Products" table, a trigger will add a record into "stocks" table. Example; stock=10,productId=99

How can i do that? Thanks

CREATE TABLE products(
productId...

thanks, it works with "orders".

Hi,

I can create all tables but order table. What is wrong, is it foreign key?

CREATE TABLE customer(
customerId INT(10) NOT NULL AUTO_INCREMENT,
customerName VARCHAR(10),
customerSurname...

done, i have forgotten to put "i" after "mysql"
$res = mysqli_query($mysqli, $sql);

Hi,

I want to create a table in Mysql but i receive an error.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www\CreateTable\create.php on line 11
Table...

1. if you use IIS stop it.
2. use Wamp server(http://www.wampserver.com/en/download.php) (just install the wamp, restart your computer and start wamp, make sure it says "online" on system tray icon...

I have stopped ISS and started wamp mysql and wamp php. now it is cool.

i have ISS runing on this computer as well. Do you think there is something suspicious? because it uses port 80.

Hi,
I use wampserver (or vertrogo serv) and installed in c:\wamp. I have a file called test.php in c:\wamp\www\test.php. When type http://localhost into browser, it asks me password and username. I...

Query = "select * from table2 where number='" + Text5.Text + "'"
Rs.Open (Query), Conn, adOpenStatic, adLockReadOnly

Hi,
If "number" is defined as Auto number in Access database, second line...

Hi,
I use VB6 with Access. I have 4 records in my DBF file. When i do Recordcount, it says that i had -1 record. Why not 4? Help please
Thanks

Dim Conn As New ADODB.Connection
Dim Rs As New...

solution is DataGrid1_RowColChange

Hi,

I am using VB6. I use Datagrid to list my data from a Dbf file. When i click on a row of Datagrid, it doesn't trabsfer actual data into Textboxes. It transfers previous clicked data into...

hi,

i receive an error on this line -- if (salesPersonsName <! "end") --

error : operator ! cannot be applied to java.lang.String

what can i do?

thanks

Hi,

When i press "end" button on keyboard, i want to see "pressed on end button" message on screen. How can i do this. I am new in Java.

Thanks

Hi,

i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it?

Thanks

this doesn't work but something like this;

insert...

Thanks for both of you. i just let u know that i have done it with function and trigger only. trigger is shown below. I am not professional thou. i am learning. i am very happy with you supports....

thank you very much. i have written a function for that before, but i didnt know how to call it in the insert into statements. now, i know. therefore i dont need a trigger for that. thanks to u

HI,

I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have...

answer is
WHERE name LIKE ('*' & in & '*')

check this up.
http://www.connectionstrings.com/

Hi,

SELECT *
FROM veriler
WHERE (name LIKE '%in%')

This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access?

Thanks

yes it works but, i want to use order by points desc is well. i can do it. bigest point will be first row, lowest last.

thank you

table : kisiler
name surname points
----- -------- ----
ali elli 1
ali elli 5
ali elli 5
veli kollu 3
veli kollu 4
adem ...

Hi,
I think i ll do it with using database. That is better.
Thanks

Hi,

I have a website. I want to put a searchbox and search what i want to find in content of my website not in database file. How can i do this?

Thanks

Thank you very very very much,

You realy give very important eamples. they will help me future.

Thank again.

hi,

table : kisiler

name surname points
----- -------- ----
ali elli 1
ali elli 5
ali elli 5
veli kollu 3

Hi,

how can i display images in a form in Ms Access 2003. I have fields in a table and path of images.

Thanks

hi,
thank you very much for your help

Hi ManicCW,

Thank you very much for your help. they work very well.

Kind regards

hi,

1-how can i do multiselect in calendar.
2-how many days between 2 dates? how can u calculate it?
example :
10/10/2006 - 12/10/2006 there is 1 day between those 2 dates.

thanks

hi,

1-how can i do multiselect in calendar.
2-how many days between 2 dates? how can u calculate it?
example :
10/10/2006 - 12/10/2006 there is 1 day between those 2 dates.

thanks

selim,

if you change autopostback property of dropdownlistbox to TRUE, that will help you. and you can use Dim x As String= dropdownlistbox1.text it like this. let us know what happend.
...