[PHP-DB] FWD: Hey there!!

hey.I wanted to prove I could amount to something I knew I had to take advantage of this now a weight is lifted off my shoulders you could be living the dreamhttp://www.aqa.ru/forum/redirect.php?http://home72solutions.net/esubmit/bizopp_main.php/%3Fcimed&95ler=facebook.com&95baco=google.com";>htt

[PHP-DB] Look what i found...

whats up!it was important for me to prove I could amount to something I was so lucky to have found this it proved that miracles can happen you are definitely cut out for thishttp://powen.home.pl/DanielEvans13.html";>http://powen.home.pl/DanielEvans13.htmlsee you.

[PHP-DB] Bulk Insert from text file

Hi All, I have bulk data store in text file, which is attached with this email. Could any 1 please help on how to insert using phpMyAdmin?? I tried using below code but getting "Error in SQL Syntax": BULK INSERT venue FROM 'c:\venues.txt' WITH ( FIELDTERMINATOR = '","')

[PHP-DB] Import Excel sheet into SQL

Hi,   How can I import Excel sheet into MS-SQL. The data I have saved in excel sheet is in cells, snapshot is attached in this email.   I am using sqlmyAdmin. and tried using import but getting error "Invalid Count on line1"       Help required!!!     Nasreen -- PHP Database Mailing Lis

[PHP-DB] Run SQL query when click on OK button of warning message

Hi All,   I am printing a _javascript_ warning message. On pressing OK button, I want to run an sql query. Below is the way I have tried but sql query is running either press OK or Cancel button on warning message or even refresh the page (F5). Also redirection, when press OK, also not working.  

[PHP-DB] Create Search engine with multiple form fields

Hi,   I have an HTML form which has more then one fields. User can precise its search using one or more input fields E.g GigName,Date, Genre,Venue. The data is coming from 3 tables.  Below Query brings one tables record with each and every row of other two tables. Could any one please help me so

[PHP-DB] Help in concatenation

Hi,   I need to change PHP embeded in HTML to HTML embeded in PHP as trying to use modularity approach. I'm stuck on below these lines where concatenation is the big issue. I have researched, read but couldnt sort this out after try really hard. Could any one please help me to change this code to

[PHP-DB] Navigation Help

Hi, Could any one please help me with Page Navigation. I have done Next and Previous page Navigation but confused on printing page numbers (1,2,3,4) and hyperlink them. Below is the code which i'm halfway on but it only prints "1" with no hyperlink where as I have 11 pages, if i print $noPages.

Re: [PHP-DB] How to do a Newsletter

I have to email it. Basically I have run a query according to user criteria of newsletter and send it via email - Original Message From: Jason Pruim <[EMAIL PROTECTED]> To: Nasreen Laghari <[EMAIL PROTECTED]> Cc: php-db@lists.php.net Sent: Thursday, May 1, 2008 5:03:43 PM

[PHP-DB] How to do a Newsletter

Hi, Does any one know a better way of doing "Newsletter". I have to run a query and send that data to clients. Regards Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. h

[PHP-DB] Why $row is EMPTY

Hi, Why my program is not going in while loop? When I run the same query in SQL cmd, it brings result but here when I print $result gives Resouce ID number means $result has data then why $row is empty. $query = 'SELECT * FROM `gig` LEFT JOIN genre ON gig.genreId=genre.genreId LEFT JOIN venue ON

[PHP-DB] Query Criteria

Hi All, I need help in below coding as it is not working. What I'm trying to do here, if $type contains "today" value then bring all record which has today's date, If $type contains "tomorrow" bring all tomorrow's record. Do you think below coding is correct? becuase when I run this query I get

[PHP-DB] A very basic PHP question

Hi, I have some confusion with Variables scope. I searched but couldn't figure it out :( The question is: one variable which changes according to if... else statment, how do you change the value of that variable? Actually $query is changing on $type variable so I tried doing u

[PHP-DB] Select query with Forein key Relation

Hi, I have a table which contains 2 foreign key relation columns. I'm trying to get all columns from main table as well as all column from those 2 foreign key relation tables. The query i'm using is : select * from gig where gig.gigid = $gigDetail LEFT JOIN genre ON gig.genreId=genre.genr

[PHP-DB] Dynamic Navigation with Limit

Hi, I'm trying to put limit of data fetch as well as dynamic navigation. Below is the try which I did but something is going wrong as $screen value is not increasing so when I click on NEXt button it refreshes the same page and Previous button does even show. Could you kindly have look on the

[PHP-DB] SELECT query with multiple "WHERE" Clause

Hi All, Thank you for increasing my knowledge about PHP/MYSQL. I am creating a SEARCH, by only using one table. The search form is same as Inserting item (search has form of all fields in table ), difference is SEARCH page doesnt have validation . Therefore user can enter information in any of

[PHP-DB] Password Reset

Hi, I have encrypted password in database and I encrypted using MD5(). As it is a one-way Hash so I cant get password back to original text !!! What encrypting technique I used to encrypt password so if user forget, I can decrypt password and email it. Regards Nasreen _

[PHP-DB] INSERT query with Primary and foreign key

Hi, I need help to insert date into two tables when tables have primary and foreign key relationship using php. I tried simple INSERT query but foreign key colum is storing NULL. Regards Nasreen Be a

[PHP-DB] Uploading Image using PHP and mySQL

Hi All, First of all A very big thank you to all of you for solving my Password() encryption problem. Now I'm stuck on new problem which is image not uploading. I'm using the following code. Regards Nasreen 0){ echo "Image has been inserted succesfully"; } else { echo "Image can no

[PHP-DB] Automatted Newsletter

Hi All, Is there any way of sending an automatic email which gets data from database? Regards Nasreen Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs

[PHP-DB] Uploading Image using PHP and mySQL

Hi All, First of all A very big thank you to all of you for solving my Password() encryption problem. Now I'm stuck on new problem which is image not uploading. I'm using the following code. Regards Nasreen 0){ echo "Image has been inserted succesfully"; } else { echo "Image can not be i

[PHP-DB] Password decryption

Hi, I'm junior in PHP and stuck on Encryption. I have encrypted password using SQL : $query = "insert into user (userid,password,) values ('$username',Password('$pass'));"; Which is working perfect. Now I'm working on Login page where I have to compare passwords.. As password in database