I have a very simple backend to a news section of a website. It is written in PHP in Dreamweaver using a MySQL database. It allows the user to add, amend and remove news items. The current fun...
There are several php scripts around to import csv into mysql, but each one I found requires that a table must be already created.
I'm looking for a script (or post me some code to complete...
Hi There,
I have issues with an email newsletter that is due to be sent.
I have to put in a £ sign in the text version and HTML version of my newsletter.
I have a database table with ...
Still very new to this. I have a query that displays how many members are signed up for a class. Can I use the results of the query to evaluate the total signed up per class against the maximu...
I receive the following error when I execute the code below:
PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting '&' or T_VARIABLE in /srv/www/htdocs/gmail_curl...
Hi experts,
I'm using a php form to insert some fields in my database, on the form there are 7 fields, two of those are list/menu items, the problem is that these two items doesn't put the i...
I started a question about two weeks ago and have finally gotten a chance to work it. I was unable to get the solution, so, I am starting another one and whoever gets my solution fixed, gets ...
HI. Need a quick solution please.
I have a variable with this "photosort[]=1&photosort[]=0". I need to create an array of these values so I can loop through them. I do not need or care abou...
Hello,
The problem with my code is that some databases do not contain fields for "extra1Width" and "extra2Width".
This causes a database error.
How can I automatically ADD these fiel...
I need to update/delete foxpro dbf files which reside in a linux server by using PHP. dbase functions in PHP dont help. I heard of ODBTP but i not sure how to connect dbf since there are no dr...
I have 2 radio buttons on a form and when one is checked and submited i would like it to go into my database which is created with phpmyadmin. When i click submit, all my text feilds go into t...
Hi,
I'm trying to connect to a MSSQL 2000 server using PDO ODBC. On Windows, things work fine. I'm now trying to get thing working on Linux (Ubuntu), but having problems. I'm not sure if...
i have a mysql database with 2 tables (table1 and table2). Table1 has lots more columns than table2. I need a php script that copies ALL records in table2 into table1.
Now all of the colu...
I have searched and found various options, yet most entail conversion to CSV yet the output is less than acceptable. Is there a way to generate an .xls that would include basic formating?
I am trying to write a script that will look in a table called import and find all records that have a column named mid as NULL. There will always be only one record or no records where the m...
The following snippet of code is supposed to change ownership and permissions, then move a quarantined file to the specified user's Maildir.
<?php
$path_quarantine = "/var/virusmai...
I'm having some issues. I keep getting these two errors upon attempting to fill out the form:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cho...
I am having trouble viewing the blob that i have saved in mysql database. I can save it but when I view it, its just a little box with an "x" in it. Could someone have a look at my code and se...
Hi everyone,
Looking at the URL I have submitted, you can see that I have managed to retrieve the poem titles beginning with the letter selected from the array.
The query is: $query="SE...
Hi,
I have a text file that has multiple lines. What I want to be able to do is split each line down into an array of variables and echo out to a page. e.g.
Text file:
120908 file 1
3...
Hello All,
I get this error when I try to update a column in the table:
"UPDATE statement conflicted with COLUMN FOREIGN KEY constraint 'FK__Homepage_Pr__uid_34C3T432'. The conflict occur...
I want to take an Excel file could be .csv and insert it into a table into mySQL using PHP programming.
How can I do this?
Thanks,
Jeff
Hi. I have a database with the following fields: ID, Model, Products Name, Manufacturer. I use dreamweaver to setup my website. I figured out how to setup master and detail pages. My question ...
I have a working web application with multiple tables. I need to write a small PHP script that when it runs, deletes records from a table if the value of its first column is NOT found in a se...
I need to truncate a variable that is pulling data from MySQL database. I need it to cut off the text at 50 characters. I do not want it to look for spaces " " or any other character - just cu...
