Re: [PHP-DB] Importing CSV files to MySql Db issue.

MySql admin. Still stuggling, Thanks, Chris chris smith-9 wrote: > > Chris Carter wrote: >> Is there something that has changed in the new MySql DB ? > > What new mysql? Has your host upgraded your database version or something? > > Mysql won't change the interfa

[PHP-DB] Importing CSV files to MySql Db issue.

Is there something that has changed in the new MySql DB ? I am trying to upload a data like this from my CSV file to a table through CSV upload and not CSV Load Data: field1,field2,field3,field4,field5,field,6,field7,field8 field1,field2,field3,field4,field5,field,6,field7,field8 Parameters I a

[PHP-DB] Trying to paginate a code but having trouble.

Hi, I am trying to paginate this to display just 4 results and use options for pagination. Please help. '.$a.' '.$b.' Name: '.$c.' Price: '.$d.' '; $i++; } ?> Thanks in advance, Chris --

[PHP-DB] How to Parse XML Feed on my PHP page

Hi, I have never done parsing of an XML feed or URL on my PHP page. Basically there is a website that shows products, in order to list those products on your page you need to parse the XML URL that they provide. I have no experience to this, have been searching on this but have not got a clue. S

[PHP-DB] Is displaying image in php tough?

I am trying to fetch the image from the database image field. Fetching it from $image=mysql_result($result,$i,"image"); And displaying it with: ../stores-images/ I know it requires some if else or array to display. This is new for me. Please help! Chris -- View this message in context:

[PHP-DB] Error:Undefined index, for a simple line.

Hi, Should I try with _REQUEST. the form is using POST method. My code: http://www.nabble.com/Error%3AUndefined-index%2C-for-a-simple-line.-tf4547517.html#a12976882 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscri

[PHP-DB] Data not fetching in the textfield.

I am trying to fetch data through this code: My code: for($i=0;$i' ; echo '' ; echo ' ' ; echo ' Store name:' ; echo ' ' ; echo '

[PHP-DB] What could be the right approach to get this data

Hi, I have users loging in and posting jobs. Now once the data is posted to the database, the next time the user logs-in he will be presented with two pages. 1) Post more jobs 2) Visit this page and delete jobs that you posted. If he choses to go to the page 2 and delete the jobs. The table tha

[PHP-DB] Maximum execution time setting - How to

Hi, How to fix this in cPanel Fatal error: Maximum execution time of 30 seconds exceeded in "whatever the URL" Or may be its not the right forum for this query. Thanks Chris -- View this message in context: http://www.nabble.com/Maximum-execution-time-setting---How-to-tf4505324.html#a128489

Re: [PHP-DB] How to capture from session and match database

y: $query="SELECT * FROM table WHERE email = '".mysql_real_escape_string($_SESSION['email'])."'"; Many thanks. Chris Chris Carter wrote: > > Hi, > > I have this session code on each page and this is working fine for > authentication: >

[PHP-DB] Database warning may be session is the problem

This might look only like a warning message but it has been bugging me since quite sometime now. Seek expert advice from the members of this forum please. Session at the top of the page; Error on the database: Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL r

[PHP-DB] How to capture from session and match database

Hi, I have this session code on each page and this is working fine for authentication: Now I wish to 1)capture the value (userName) from session on one of my pages and 2)match it with the database and 3)display the value in the textfields This is the code I am using to do this please: in

[PHP-DB] How to capture from session and match database

Hi, I have this session code on each page and this is working fine for authentication: Now I wish to 1)capture the value (userName) from session on one of my pages and 2)match it with the database and 3)display the value in the textfields This is the code I am using to do this please: in

[PHP-DB] How to call image from mySql to php file

I have a field in database called "logos" which has one value "images/logos/some_logo.jpg" In my php I am trying to call it in my php file as image. With this code. $sno = $_REQUEST['sno']; $query="SELECT logos FROM table WHERE sno = '$sno'"; $result=mysql_query($query); $num=mysql_numrows($r

Re: [PHP-DB] Search witin text.

Thanks much ... this has been achieved now. However, there is another issue. Say for example, the user wants to search 'Chriscarter' but puts into the search field 'Chris Carter' how is it that I can take only the 'Chris' out of the search string and present

[PHP-DB] Search witin text.

Hi, I have to send results to the users based on their search. Have got a combined serach option in which data is searched from two different fields and based on the match the result is sent or an error message (quite simple). Now I need to change this, the one column of data is from a VARCHAR fi

[PHP-DB] Trying to add primary key to existing database.

Hi, I have a database, which was till now, not having any primary key defined. I thought I would not need it but now I think I do (based on the suggestions from my prior postings). I am now trying to insert the primary key in an already existing database. There was not even an index defined earli

[PHP-DB] Ways to display remaining data columns.

Hi, What I am trying to achieve is this, >From the results table, when the user clicks on the last column of the row which has a label "Details" of a particular item. A pop up window opens and has some description and contact number which comes from the database. I have a database with 8 column

[PHP-DB] Error for registration mail.

Hi, I am trying to send an email to the user after he registers himself on the website. The code is a DB code that 1) Inserts the data to DB table 2) Sends an email to the user with his details. 3) Passes on a Thank you page. The code works fine without the email code. But I get this error when

[PHP-DB] search result error message

Hi, The below mentioned code works fine. Connects to the database, fetches the result, and displays neatly in a table. If there is no data then it jumps to the if condition and displays the error message. BUT if the 'if' condition is running and no data is present the Table headings and the bottm

[PHP-DB] Paginatating PHP

Why is this code that I have written to paginate the result from database jumping to else condition where the NEXT or PREVIOUS is not hyperlinked as in the if condition. There is enough data to display this result and to paginate but its simply showing the else condition which does not have NEXT o

[PHP-DB] SQL query error

What wrong with this syntax, its not giving any error on runtime but I am facing a blank page while paging. $query=" SELECT * FROM gurgaonmalls WHERE mallname = '$mallname' limit $eu, $limit "; -- View this message in context: http://www.nabble.com/SQL-query-error-tf2831052.html#a7903857 Sent f

[PHP-DB] Limited number of database results

Hi, I have more than 200 rows of data to show to the user. How can I limit it to say 25 rows per page and give an option at the bottom to the user to keep clicking for more till s/he reaches the end of data. my db code is: $showThis "; $i++; } if

[PHP-DB] Invoking database php file with hyperlink

I need to fetch data from database with the help of a php file, not with the click on a button but click on the hyperlink. I know this is simple but i have not done it. Please advice or give me some link. http://www.nabble.com/Invoking-database-php-file-with-hyperlink-tf2806556.html#a7830342 Sent

[PHP-DB] CSV import to mySql

Hi, I have this data given below as sample. Trying to import to mySQL is failing everytime. There are more than 100 rows of data but when I follow the procedure of phpMyadmin > databasename > tablename > click import tab from top >choose the file (csv file) > Click on the CSV radio button on "For

[PHP-DB] Wrong SQL Syntax

My MySQL version is 5.0. I am trying to run this small query but getting this SQL error "Error! Could not insert valuesYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''userdata' ('fName', 'lName', 'email', 'con

[PHP-DB] Where am I doing wrong - DB

Just a small database code. Want to make entries in the mySQL table using PHP. Not being able to. When I run this code it takes me to the next blank brower window as if the entry has been made but after checking the database I do not find anything. There is not even an error message, I have tried

[PHP-DB] Just two PHP questions

As mentioned before, I am new to php. Till now I was trying to execute the file online. However, I have got Apache tomcat on my system which runs JSP files perfectly, including the database interactions. I am now trying to run PHP using apache on localhost. Can you please advice: 1) What exactl

Re: [PHP-DB] simple issue

our web > site and once she does, she has free access to your database. > > And in future, when sharing code on PHP-DB, which is a must if you want > the expert help people here can provide, always leave out or change the > MySQL log in info. > > Good luck, >

Re: [PHP-DB] simple issue

I have apache-tomcat-5.5.17 which works perfectly with jsp files but I do not understand what does it take to run a php using apache. chris smith-9 wrote: > > Chris Carter wrote: >> Hi, >> >> I am new to PHP, just trying a peace of code to access mySQL database to >> fetch

[PHP-DB] simple issue

Hi, I am new to PHP, just trying a peace of code to access mySQL database to fetch and show result on web page. But getting errors. Can you help me with this code please. Or if you have a very basic code where in I can do some insertion in the database. -- View this message in context: http:/