hey thx.... i'll try the code, and get bak 2 u!!

Hi.

I am working on a php-mysql project.

My table contains a field called "ID", which i have declared as teh PRIMARY key.

but what i want is, that when the user tries ot insert record B into...

an ONCLICK-event based field-generation is exactly what i want.

thx 4 ur reply.

i shall try it in my app and get bak 2 u.

thx again.

thx a lot..

i want to compare the values for username and password with the values stored in a database.

i want this comparison to occur on the login page itself, so that in case either usrnam/passwd is...

hi.

thx 4 d reply.

i guess u dint get my equirement totally.

on any page, i want the user to ba able to view the page contents only if

1. he has entered his username AND password
2. both...

hi guys.

i hav this drop down menu, which i need to populate with data from one column of a particular table of MySQL dbase.

i hav read a lot on this, but have not been able to come up wid any...

hey guys.

i hav this page (a.php), where i ask te user for his username and password. I match these with static values, and upon succesful matching, i redirect the user to b.php.

my prob-
...

hi guys.

i require some assistance of yours again.

what i want is this:

there is a form (say on page xyz.php) in which i have , say, 5 text-fields.
but i also hav a button. upon clicking...

hi guys.

i require some assistance of yours again.

what i want is this:

there is a form (say on page xyz.php) in which i have , say, 5 text-fields.
but i also hav a button. upon clicking...

hey nav33n.

you probably did not understand my requirement(or maybe i am not understanding your solution)....

What is need is this:

there is a form, say P1, where the user specifies whether...

1. Yes. the person first encounters a form (say P1) wherein he has to specify whether he is student/teacher.

2. data form this form is collected in the "action" page (say P2) of P1.

3. What i...

P.S. There was no error due he the ('),(`) or the (") .....

Thx a lot buddy.... u just got it right... i checked up, and as u suggested, the "$_POST['Tests']" variable was blank.... the reason being (OK, now pls dont beat me up)....

i the previous page(the...

i tried this in the GUI (navicat), and it worked just perfect, but when i run it from my script, it doesnt work.

In the GUI, i tried--

update table2 set col2 = ( Select col1 from table1 where...

Well badbart, as nav33n said, you hit the nail on the head. I just changed the name of the field and the system worked...thx a ton for the suggestion coz such things are exttreemely difficult to...

PS. I tried running the SELECT query from the SQL GUI (naviCAT), and i gave me the perfect result....

Hey nav33n.

You were right. IO tried that command an it showed 0, indicating that no rows were returned by SQL.

Now pls suggest what i shud do...

i shall be highly grateful fr ur...

Well, i tried running the query using the MySQL GUI (NaviCAT) wioth static data. Again, the same problem arises. The query runs perfectly well for 'dod' and 'yod', but when i run it for 'mod', it...

i entered the date as 10/4/2008...

it shows:-

update client set dod='10', mod='4',yod='2008' where id='120'....

and then the table (with the 'date' and 'year' column updated, but the...

The CODE

// retreiving data from table 1

$r1 = mysql_query("Select * from table1 where Column1 = '$test' ") or die(mysql_error());


// updating the other table

while($row =...

it prints the query (since i have given: "echo $query").

but the update does not occur....

this is really confusing... wats the problem???

i tried using a common update command, but when i use it with mysql_error(), it reports the following error:

You have an error in your SQL syntax, check the manual that corresponds to your MySQL...

i tried your solution... it does not produce an error, but no UPDATE occurs...

I have referredd to the links ou indicated, and this is the code i have come up with. But this doesnt seem to work either. I guess the error is based on the usage of ("") , ('') and (``) at different...

hey guys...

i figured out my mistake...

the code i was using was :

Select * from tablename where col1= value1 AND col2 ==value2

I guess the habit of using C caused the error. Anyways,...

well yes. i think your code is more efficient than mine, specially in cases where there are a number of options, as, with my code, you will end up with a large number of if-else statements, which can...

i have checked the table structure. All three columns i am trying to update are NOT STRINGS BUT INTEGERS (they are storing date, month and year respectively)...

The three columns are identical in...

well i guess the problem is that when i use the command

$res = select * from table where column = 'value';

then AN ENTIRE RECORD is returned into $res.

Then, when i try to assign the value...

hi guys...

i wanna select a single cell (not full row) from one MySQL table and insert the value into another table. The datatype of the (value being extracted) and the (column of insertion) are...

yes... but the only thing that changes in the form is the drop down menu.... other fieds remain same for all user inputs...

well, thats exactly what i have done....

what i was looking for was a way to make my code more efficient. It does not matter much in this case as there are only 2 options, but in case there are...

hey buddylee17

thx for replying...

i want to stick to HTML/PHP and not se javascript.

Is a solution possible then?

hey guys... i've encountered something which I think may tax ur brains...

what im trying is this:

There is this coaching institute. A person may come here either as a student to enroll for a...

hi frnds.

this is something which may seem foolish to ask, but i have been beating my head against the wall at the frustration of not being able to get over this...

anyways, what i want to do...

hey guys.

this may be very trivial, but i cant figure out a way...

i want to retrieve the data entered by the user through a drop-down-menu using POST method.

I am unable to do so...
...

i know this is not the most efficient method... but nothing else seems to strike me... could you suggest me an alternative??

one possible solution to this is:



If on P1, the user selects O1, i direct him to page Pa.php, which contains the drop down menu D2.



Instead, If on P1, the user selects O2, i direct him...

hi...

I am developing an application using PHP/MySQL.

here, i have one page(say P1), which contains a form(just one drop down menu, say D1, with only 2 options , say O1 and O2)...

the target...

hi silviuks

i tried the method u suggested, but with that, only the first of the 3 columns gets updated.

I tries using 3 diff commands, and this , somehow, causes col 1 and 3 to update, leaving...

hey guys...

i know this is a very common problem and has been posted earlier also... but nobody seems to have figured out a solution...

i am making a program using PHP/MySQL.

I need to...