Hey guys, so i need to find an application that can do the following:



Keep a searchable database on stock
Keep a database of all customers and their data (PO numbers etc)
be able to...

Hey guys, we have a grad survey thing we are making and the questions are currently in a form. Within the form we have the regular drop down boxes for the users retrieved from a mysql database....
...

nevermind guys fixed it myself...

Thanks tho

Hello guys, quick question for ya...

Here is the code i am looking at

<?php
$conn=mysql_connect("internal-db.s*****.gridserver.com","db*****","*******") or die(mysql_error());...

i got it, thanks man, i just added that same query to the login and ask the user to enter their full name.

Thanks again for wonderful help. Hopefully now the survey can stay up and wont have...

also how am i going to modify my whole login script to use tihs now? I have it verifying the first name and then the last name... Then i use that and create a session variable to use later on so i...

ok it works but now the firstname and lastname come up all bunched into 1 word, hows a space added there.

kk i will do that give me a few minutes.

so then i would just call name? and that would hold both first and last?

i did but i dont have that id thinggy, nor do i know what to do with it.

What your saying is create an auto inrimental field.

can i still create that even though my database is created and...

Here is the other code... il explain whats going on bellow

Login.php

<?php

// Include the configuration file for error management and such.
// require_once...

ok i got that working but now i am having some issues with querying the first and last names from the database...

Heres the code i have....

<?php

// Include the configuration file for error...

hey guys i have this line

$result=mysql_query($query) or die(mysql_error());
$option="";
while($row=mysql_fetch_array($result)) {
$option.="<option value=".$row['firstname;...

never mind im going to do what you said...
Thanks

thats bad for me, i cant go re type them... took way to long.

any way to fix this problem ?

hey you guys have probably seen my other 2 threads but i said they were completed so i decided to create one more for this small problem.

I realized that when i submit my form it sends me only the...

damn that sucks... Ok i guess itl half to be like that.

Thanks so much for all of your help

yea, so its for debugging really.

but any sign of any errors or why it wont do it?

oh so the die wont do anything there ok...

hmm let me post my script maybe i did something wrong and we are just missing it here...

<?php
session_start(); // Start the session
print_r($_POST);...

user_id has a value as i am using the Welcome script and its working perfectlly.

The die command did nothing the script still ran correctly

hmm i am already doing what u said.
The column is vote_status and its all set to 0

But when i test the system using my login it doesn't change to 1 yet it does e-mail me the info perfectly fine...

the only thing i cant get to work is the vote_status any clues?




if(isset($_POST['submit'])) {
$query="UPDATE grads SET vote_status = 1 WHERE USER_ID ='".$_POST['user_id']."'"; ...

ya thanks just learned that from this book.

Thanks again.


P.S Seems i am learning :P

1 more thing i never got working was that welcome script. How do i save their name from the login script and pass it to the vote page? I now realize i need that as i need to know the person who's...

nevermind i got it, ended up being on the echo statement it had to be userid instead of user_id

Thanks a million

Just i dont see the users. Thats sorta really important as i changed the script to use SHA-1 encryption so it posts the un encrypted version and i need that output.


Why wont it show the users?...

<?php
print_r($_POST);
ini_set('display_errors','1');
$conn=mysql_connect("********************","*******","**************") or die(mysql_error());
mysql_select_db("db33717_gradsurvey") or...

well no i dont ok thanks il give it a shot now

oh removing the print will allow me to view bugs? Ok il give it a shot.

Ok here is what i have now...

<?php
print_r($_POST);
$conn=mysql_connect("i**********","*************","***********");
mysql_select_db("db33717_gradsurvey");
$query="select password from...

so i would be using that function in the sql?

I just don't get how i am doing this...

Am i generating say 500 passwords and then running a mysql script to insert them all into the database?

ok fixed it,

Now i have the passwords left...
But i never really understood how i will run the password script you gave me so it inserts the password into each users password field?

So...

so hows that fixed? thats straight from the database? Its not importing correctly possibly


FIXED!

I hope... :P 1 second

well if you mean this

<option value=>Jacob Anderson</option><option value=>Mohammed Abbas</option><option value=>Hiroaki Abe</option>

Yes they are being populated properly. I tried selecting...

ok but how do i check? When i click the drop down menu i see all the names. That all works...

<?php
print_r($_POST);
$conn=mysql_connect("***********.anblickstudios.com","************","*******");
mysql_select_db("gradsurvey");
$query="select user_id from grads";...

ok checked. Absolutely nothing is being assigned. I tried it on a bunch of other ones also. Nothing changes with the post message at the top...

lol sorry man i dont even know how to do that yet....

sorry i didn't get what you said.

I get the e-mail it says this exactly



Thank you for registering with our site!
Your selection was .

Sincerely,