[PHP-DB] MYSQL Query problem...
is there something wrong with my SQL Query? I didnt get any results neither errors..
?php
$link = mysql_connect('localhost', 'username') or die('Cannot connect to the
database.');
mysql_select_db(profiles,$link);
$SQLQuery = INSERT INTO profyles (username, fname, mname, lname, address, country,
gender, sexuality, status, bday, race, yahoo, msn, icq, email, webpage, hair,
bodytype, eye, height, weight, facialhair, hobbies, interests, aboutme, profession,
food, music, tvshows, authors, movies, rolemodel, place, visit, online, picture)
VALUES ('$user', '$firstname', '$middlename', '$lastname ', '$address, '$country',
'$gender', '$sexuality', '$status', '$birthday', '$race', '$yahoo', '$msn', '$icq',
'$email'. '$webpage', 'haircolour', '$bodytype', '$eyecolour', '$height', '$weight',
'$facialhair', '$hobbies', '$interest', '$aboutme', '$profession', '$food', '$music',
'$tvshows', '$authors', '$movies', '$rolemodel', '$place', 0, 'y' , 'y');
mysql_query($SQLQuery,$link);
?
ian
Re: [PHP-DB] MYSQL Query problem...
is there something wrong with my SQL Query? I didnt get any results
neither errors..
?php
$link = mysql_connect('localhost', 'username') or die('Cannot connect to
the database.');
mysql_select_db(profiles,$link);
$SQLQuery = INSERT INTO profyles (username, fname, mname, lname, address,
country, gender, sexuality, status, bday, race, yahoo, msn, icq, email,
webpage, hair, bodytype, eye, height, weight, facialhair, hobbies,
interests, aboutme, profession, food, music, tvshows, authors, movies,
rolemodel, place, visit, online, picture) VALUES ('$user', '$firstname',
'$middlename', '$lastname ', '$address, '$country', '$gender',
'$sexuality', '$status', '$birthday', '$race', '$yahoo', '$msn', '$icq',
'$email'. '$webpage', 'haircolour', '$bodytype', '$eyecolour', '$height',
'$weight', '$facialhair', '$hobbies', '$interest', '$aboutme',
'$profession', '$food', '$music', '$tvshows', '$authors', '$movies',
'$rolemodel', '$place', 0, 'y' , 'y');
mysql_query($SQLQuery,$link);
?
'$email'. '$webpage' -- shouldn't this be:'$email', (comma
;))'$webpage'
laters,
Fedde
~= Everybody lies, but it doesn't matter because nobody listens =~
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MYSQL Query problem...
Ian Bert Tusil wrote: is there something wrong with my SQL Query? I didnt get any results neither errors.. [snip] mysql_query($SQLQuery,$link); That's because you're not checking for errors... mysql_query($SQLQuery,$link) or die(mysql_error()); -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Include a file into a database table !!!!
Hy everybody, I´m a new php user and I looking for a solution to receive the following information from my site: 1) I want to received a form with text fields + a file (up to 100 k) I need to know wich is the easy way to place this service in my site. The question is if I can receive a file into a table column ? It´s a product to place the file into some directory in the site and the text fields into a table, but isn´t free. So the other question if is possible to have the same capability with a sareware product ??? Thanks a lot Ignacio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Pop3?
Hi there everyone, Does anyone have any sample code whereby I can conntect to, and list the emails on my pop3 server for my own username/password? I tried something on the PHP.NET documentation but I get errors :-( Basically, I need to list all emails that I have in my inbox (POP3) so then I can insert selected data into a database backup (Hard to explain). Any help would be really appreciated :-) Regards Chris
[PHP-DB] Category Listing
Hi, i'm working on the site that involves a lot ot categories and subs there of ... The way i have things now is that the structure goes one sub deep ... Ex: PHP - Database PHP - Books in the DB it looks like: id 1 name PHP parent 0 id 2 name Database parent 1 this way its easy to show dinamicaly where the user is (PHP: Database) by prividing index.php?dir=1sub=1. What i want to do, is go 3 or 4 subs deep. I just wanted to get an idea on the best posible way of doing this. Thanks Paul B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Pop3?
On Sunday, September 21, 2003, at 10:53 PM, Chris Payne wrote: Hi there everyone, Does anyone have any sample code whereby I can conntect to, and list the emails on my pop3 server for my own username/password? I tried something on the PHP.NET documentation but I get errors :-( Basically, I need to list all emails that I have in my inbox (POP3) so then I can insert selected data into a database backup (Hard to explain). Any help would be really appreciated :-) Regards Chris See the attachment, I believe it works but I'm not sure if it's a draft or the real thing since I wrote it a while ago. Andu -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Pop3?
Hi there, Thanks for that, very appreciated, just one question? Without meaning to sound dumb (Which I probably will) how do I call your function? I don't usually deal with functions, I know I need to start though . Chris On Sunday, September 21, 2003, at 10:53 PM, Chris Payne wrote: Hi there everyone, Does anyone have any sample code whereby I can conntect to, and list the emails on my pop3 server for my own username/password? I tried something on the PHP.NET documentation but I get errors :-( Basically, I need to list all emails that I have in my inbox (POP3) so then I can insert selected data into a database backup (Hard to explain). Any help would be really appreciated :-) Regards Chris See the attachment, I believe it works but I'm not sure if it's a draft or the real thing since I wrote it a while ago. Andu -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: set password on a page
Use setCookie() function. It places a global variable on the client that
your programs can verify after. See the manual for the use of the function.
Here is an example:
// Example of file chkacces.php.
?php
$pass = $_POST['password'];// It receives the password from a FORM
with POST method.
if( ($pass != xyz ){// where xyz is the right password.
echo You are not autorized to see this page;
return;
}
// Autorized.
setCookie( $USER, autorized );
header( Location: index.php );// redirects to index.php
?
Example for your index.php file:
?php
if( ($USER != autorized ){
echo You are not autorized to see this page;
return;
}
// Here goes the code for autorized users.
?
The variable set with setCookie() is not availabe until the script ends. See
details in the manual.
The manual is available in www.php.org
Sagerat [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
How do I set up password on a page so that only restricted people can open
it?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: best upload method
I use file upload, it's faster than ftp because the ftp conection and login process takes a few seconds. You have to see that the permissions in each method are diferent. Some times you cannot delete a file copied with ftp useing the unlink() function unless you change the chmod. If you used the upload method you can use unlink() but not ftp_delete(). It has solutions but with a little of complexity. That's why I recomend the upload method and the functions copy() and unlink() for moveing and deleting files. You can use also the chmod() function with this method to change permissions. Open-Mind [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] which is the best upload file method ? file uploads or FTP commands from PHP thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: set password on a page
In my last replay I told you to find the manual in the wrong place. The right place is www.php.net Sagerat [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] How do I set up password on a page so that only restricted people can open it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: tutorial
Go to www.php.net, in the section Documentation you'll find manuals in several languages. Novianto Dwiatmojo [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Hi everyone i'm a newbie in php, mysql and linux but i want to learn about it can you guys help me or give me referal to any tutorial links. thank you for your kindness. thanks :P sorry for my english :- [ _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
