netfrugal

I have 2 files. One file is calling the other file with javascript. This is that I have in the header of index.php: <script type="text/javascript"> httpRequest.open("GET", "/status_page.php", true); // grabbing an integer from this page httpRequest.send(null); httpRequest.onreadystatechange = function() { checkState(); }; function checkState() { if (httpRequest.readyState == 4) { if (httpRequest.status == 200) { var statusCheck = httpRequest.responseText; if (statusCheck == "0"){ window.location = "/logout.php"; } } //End status if } //End readyState If } //End CheckState-Function </script> This works fine. However, I wanted to modify this by not writing the redirect url. I am trying to figure out if I can pass the (window.location="/logout.php") to index.php from the status_page.php When I try that, it simply doesn't work. My guess is the javascript must be written to the page after the main page (index.php) has loaded. And therefore, any extra js will be ignored. But again, I don't want to post the url for everyone to see. Does anyone know of a way to pass a js command after the browser has loaded? Or another work-around?

I want to test how much processor power is being used for 2 things. Anything from time to how much effort the server is making to perform each task. Does anyone know how to do a comparison like this?

Is it possible to pass credit card data securely from one website to another (on a totally different server)? Basically, a live data feed of orders from external websites, not hosted on the same server where the info is passed onto the gateway? I can't image passing cc info via the url string and expecting that to be secure. for example: https://somesite.com?fname=jon&lname&ccnumber=4111111111111111&exp=MMYY.......... Am I just being paranoid? Or is this ok to do?

I have a page that shows all the rows from my MySQL database for my contacts table. I would like to replace the Address Column with only a small image. With that image I'd like to only Scroll my mouse over it and have a quick Popup show what the address for that contact is. Is there a way to do this with Ajax? If so, would someone direct me to a tutorials that can teach me this? thanks!

Does anyone know of a good tutorial that allows us to create a rollover image/link that enables a popup box onRollover and disappears onRollout. But the info must be database driven for a list of rows I'm pulling from mysql. So, basically I would like to show a list of rows from mysql for my contacts. And instead of showing the addresses of all contacts, I'd like an image or a link to represent them, and when you scroll your mouse over the image or link, then a popup box shows with the address information. I know that javascript or maybe ajax can be used for this, but I have been unsuccessful with finding one so far. thanks!

I found a tutorial online from this site: [URL=http://www.phpeasystep.com/mysql/10.html]http://www.phpeasystep.com/mysql/10.html[/URL] Now, I have attempted using the code provided, but I consistantly get an error concerning the header() function found on the bottom on the script. What am I not understanding about header information? I always get this error: [B]Warning: Cannot modify header information - headers already sent by (output started at C:\apache\Apache2\htdocs\PHP\update\update.php:9) in C:\apache\Apache2\htdocs\PHP\update\update.php on line 71[/B] Is the tutorial not correct?  Because I've seen similar tutorials that put the header() function in similar places too. Here is the code: <strong>Update multiple rows in mysql</strong><br> <?php $host="localhost"; // Host name $username="root"; // Mysql username $password="password"; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); // Count table rows $count=mysql_num_rows($result); ?> <table width="500" border="0" cellspacing="1" cellpadding="0"> <form name="form1" method="post" action=""> <tr> <td> <table width="500" border="0" cellspacing="1" cellpadding="0"> <tr> <td align="center"><strong>Id</strong></td> <td align="center"><strong>Name</strong></td> <td align="center"><strong>Lastname</strong></td> <td align="center"><strong>Email</strong></td> </tr> <?php while($rows=mysql_fetch_array($result)){ ?> <tr> <td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td> <td align="center"><input name="name[]" type="text" id="name" value="<? echo $rows['name']; ?>"></td> <td align="center"><input name="lastname[]" type="text" id="lastname" value="<? echo $rows['lastname']; ?>"></td> <td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>"></td> </tr> <?php } ?> <tr> <td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td> </tr> </table> </td> </tr> </form> </table> <?php // Check if button name "Submit" is active, do this if($Submit){ for($i=0;$i<$count;$i++){ $sql1="UPDATE $tbl_name SET name='$name[$i]', lastname='$lastname[$i]', email='$email[$i]' WHERE id='$id[$i]'"; $result1=mysql_query($sql1); } } [B][COLOR=DarkRed]if($result1){ header("location:update.php"); }[/COLOR][/B] mysql_close();  ?> This is a script to update multiple rows from one form. It is driving me crazy!

I have a list of emails and I want to email only selected people by clicking on a checkbox next to their record. So I created a nice table that shows all records and a checkbox next to each record with the recordID as the value. But, I am not sure where to go from here.  The next page has the mail() function, but I don't know what to do next. [B]here's the code on page 1:[/B] [COLOR=DarkOrange]<form name="form1" method="post" action="mail-to-some.php">[/COLOR]           [COLOR=DarkGreen] <tr>             <td class="nicetableheader">REQUESTOR</td> <td class="nicetableheader">NAME</td> <td class="nicetableheader">checkbox</td>           </tr>[/COLOR] [COLOR=DarkRed]<? while ($row = mysql_fetch_array($sql)) { $recID = $row['recID']; $name = $row['name']; ?>[/COLOR]               <tr> [COLOR=DarkGreen]<td class="nicetablerow">[/COLOR][COLOR=DarkRed]<?php echo $name; ?>[/COLOR][COLOR=DarkGreen]</td>                 <td class="nicetablerow" align="center">[/COLOR][COLOR=DarkOrange]<input name="sendto" type="checkbox" value="[/COLOR][COLOR=DarkRed]<? echo $recID; ?>[/COLOR]" />[COLOR=DarkGreen]</td>               </tr>[/COLOR] [COLOR=DarkRed]<? } ?> [/COLOR]           [COLOR=DarkGreen]<tr>             <td colspan="16" align="right">[/COLOR][COLOR=DarkOrange]<input class="textbox"  type="submit" name="Submit" value="Submit">[/COLOR] [COLOR=DarkGreen]</td>           </tr> [/COLOR] [COLOR=DarkOrange]</form> [/COLOR] [B]And here's the attempted code on the mail-to-some.php.  I am having alot of problems about how to make the query from the db - depending on what records were chosen from the previous page.[/B] include('includes/configure.php'); [COLOR=DarkRed]$sql = mysql_query("[/COLOR]  [B]?[/B]  [COLOR=DarkRed] "); [/COLOR] [COLOR=DarkRed]while ($row = mysql_fetch_array($sql)) { $email = $row['email'];  [/COLOR] [COLOR=DarkGreen]$to = $email; $mailheaders = "Attention!\n"; $Subject = "My subject"; $msg = "My message\r\n"; mail($to, $Subject, $msg, "From: IT Help Desk", $mailheaders); [/COLOR] [COLOR=DarkRed]} [/COLOR] If I am completely off my rocker on how this is performed correctly, I won't be surprised. but any help will be appreciated!

I would like to submit a form with only 2 radio buttons:  On / Off Is there a way to submit the form when I click one of the radio buttons, and not a submit button?

In my database I have a ton of emails that I want to change: For example: mommy@yahoo.com to  mommy@mydomain.com dad@hotmail.com to  dad@mydomain.com uncle@msn.com to uncle@mydomain.com sister@gmail.com to  sister@mydomain.com I am sure there is a search and replace for mysql that can replace everything between the '@' sign and the '.com' to 'mydomain' but I can't find it. Any help would be appreciated! thanks!

I am lost in this.  Is it possible to match the results from a query in php/mysql to the results from php/openldap? My AD has the needed email addresses, while the MySql has the needed survey results. Both have one common field:  "username" Basically I need to match them up, and of course not everyone will need to be matched, only those people who submitted a survey to the MySql database.  And it would be nice to see the results on one webpage. Any help would be appreciated, as I am stumped on how to match these results. So, below is the code for both sides: MYSQL  & AD --------------------------- MYSQL -------------------------- [color=navy]<? include('includes/configure.php'); $sql = mysql_query("SELECT * FROM results"); // Perform MySQL query on only the current page number's results  ?> <html> <head> <title>survey</title> </head> <body> <table width="100%" border="0" cellpadding="0" cellspacing="0">       <tr>         <td width="100%"  valign="top"><table width="100%" border="0">           <tr>             <td>INCIDENT</td>             <td>REQUESTOR</td>             <td>REQUESTOR email</td>             <td>SUBJECT</td>             <td>DATE SUBMITTED</td> <td class="nicetableheader">DATE CLOSED</td>           </tr> <? while ($row = mysql_fetch_array($sql)) { $username= $row['username']; $subject= $row['subject']; ?>               <tr> <td class="nicetablerow"><?php echo $username; ?></td> <td class="nicetablerow"><?php echo $subject; ?></td>               </tr> <? } ?>         </table> </td></tr></table> </body> </html> [/color] --------------------------------------AD  ----------------- [color=green]<html> <head> <title> User Information Look Up </title> </head> <body> <h1>User Information Look Up </h1> <? $ldapserver=ldap_connect("myserver"); if(!$ldapserver) { print "System Error"; exit(0); } $bind = ldap_bind($ldapserver,"cn=XXX,cn=XXX,dc=XXX,dc=com","XXXXXXXX"); if(!bind) { print "System Error"; exit(0); } $base_dn = "DC=XXX,DC=com"; $filter = "sn=*"; $inforequired = array( "username", "description", "mail", "givenName", "sn", "cn"); $result = ldap_search($ldapserver,$base_dn,$filter,$inforequired); $info = ldap_get_entries($ldapserver,$result); if($info["count"] == 0) { print "<p>No information available"; } else {  ?> <table border=2>   <tr> <td>First name</td> <td>Surname</td> <td>Full Name</td> <td>Department</td> <td>Mail</td> <td>Login</td>   </tr> <? for($i=0;$i<$info["count"];$i++) { $row[$i] = "<tr>" . "<td>" . $info[$i]["givenname"][0] . "</td>" . "<td>" . $info[$i]["sn"][0] . "</td>" . "<td>" . $info[$i]["cn"][0] . "</td>" . "<td>" . $info[$i]["description"][0] . "</td>" . "<td>" . $info[$i]["mail"][0]  . "</td>" . "<td>" . $info[$i]["username"][0]; } sort($row); for($i=0;$i<$info["count"];$i++) print $row[$i] . "\n"; print "</table>"; } print "</body></html>"; ?>[/color]

I am trying to separate this:  mydomain\myname To do this I am using the explode function as such: $word = "mydomain\myname"; $separated = explode("\", $word); echo $separated[0]; echo $separated[1]; However, the backslash does not work.  Is there a way to explode backslashes?

Got it figured out! The best way to do this is to create a batch file that includes php.exe and the php file that needs to be executed: C:\php\php.exe C:\apache2\htdocs\emailscript.php then I set up the scheduled task to run the .bat file when I need it. Next thing to figure out is how to set up a cron job on linux to do the same thing.

I would like to run a simple php file that backs up my database.  The file is in one of the virtual directories.  I know I can do it with other ways, but I'm interested in how to do it on a windows OS, and using the windows scheduled tasks wizard - if possible. I've read that parameters need to be set up, but I don't quite understand what that means. Does anyone know how I can do this in a simple step by step fashion? thanks!

I have 2 pages.  Form.php  & Paginate.php I enter the username into the form.php and it sends me over to paginate.php where it looks for records with the username I chose. I can see all the results on Paginate.php, but if I click to go to the next page (paginate.php?page=2)  everything goes blank! Do the search parameters get lost after one page?  Any help would be appreciated! thanks!

Ah yes, I didn't explain the dates.  The form fields: username, begindate, enddate search for certain employees and the dates of their internet usage.  Unless it is not necessary I put the 00:00:00 into the code to search between time of day as well. However, I am very open to anything better!

were you repeating what I put?  or is there something different?

According to phpmyadmin I have a few indexes.  Here is the sql for creating that table: CREATE TABLE `log` (   `datetime` datetime NOT NULL default '0000-00-00 00:00:00',   `ident` varchar(20) NOT NULL default '',   `ip` varchar(40) default NULL,   `url` blob NOT NULL,   `what` blob NOT NULL,   `how` varchar(40) NOT NULL default '',   `size` varchar(9) NOT NULL default '',   `ip_unresolved` varchar(15) NOT NULL default '',   KEY `ident` (`ident`),   KEY `datetime` (`datetime`,`ident`) ) TYPE=MyISAM; And here is the Query: SELECT datetime, ident, ip, what, url FROM log WHERE ident = '$username' and datetime between '$begindate 00:00:00' and '$enddate 23:59:59' The tables are from DansGuardian: http://dansguardian.org/ for web content filtering. 

Yes, I read the tutorial on PHPFreaks.  It is very helpful.  But it seems there is a limitation to query speeds even when using pagination.  I have over 11 million records to query.  With or without pagination the browser still takes about the same time to load. I am guessing that the query is actually looking through the entire database to give the pagination results, regardless that only 15 results are to be shown on the page at a time. To my limited experience in the pagination world, there's no other way to make the query execute faster. Any ideas?

After optimizing my database tables my queries are running smoother and a little bit faster. I have thousands of rows of data to view and everyday I need to wait for a while for the results to show up on the browser. My question is: Does paginating speed up the query? Or is there another way to speed up the query? Currently all results are showing in a repeating table, so I have alot of scrolling to do. But I'm open to other ideas for possible faster results. thanks!

I have thousands of internet log records to review, and before I added pagination to the query , the pages would be miles long, and obviously take a while to load. Now, the pagination makes it look nicer, but it stalls and fails to load after a few seconds. Is there a way to stop the freezing?  Or am I out of luck? Below is the code I use. The Red is the actual pagination code, while the rest is the query result. Any help would be appreciated. [B][SIZE=1][COLOR=DarkRed] if(!isset($_GET['page'])){ // If current page number, use it     $page = 1; } else {  // if not, set one!     $page = $_GET['page']; } $max_results = 15;  // Define the number of results per page $from = (($page * $max_results) - $max_results); // Figure out the limit for the query based on the current page number. [/COLOR] [/SIZE][/B] if (!$subsearch) { $sql = "SELECT datetime, ident, ip, what, url FROM log WHERE ident = '$username' and datetime between '$begindate 00:00:00' and '$enddate 23:59:59' order by datetime $ordervar [B][SIZE=1][COLOR=DarkRed]LIMIT $from, $max_results[/COLOR] [/SIZE][/B]"; } else { $sql = "SELECT datetime, ident, ip, what, url FROM log WHERE ident = '$username' and url LIKE '%$subsearch%' and datetime between '$begindate 00:00:00' and '$enddate 23:59:59' order by datetime $ordervar [B][SIZE=1][COLOR=DarkRed]LIMIT $from, $max_results[/COLOR] [/SIZE][/B] "; } $result = mysql_query($sql, $connection); print "<table border='2' width='100%' cellspacing='0' cellpadding='0'>\n"; print "<tr><td><font color='#336699'><b>Date Time</b></font></td><td><font color='#336699'><b>Username</b></font></td><td><font color='#336699'><b>Computer Used</b></font></td><td><font color='#336699'><b>Displayed</b></font></td><td><font color='#336699'><b>Web Page Viewed (limit 45 characters)</b></font></td><tr>\n"; while($row= mysql_fetch_array($result)) { $url = substr($row[url], 0, 45);  // limit the url string to 45 characters print "<td>$row[datetime]</td><td>$row[ident]</td><td>$row[ip]</td>\n"; if (strstr($row[what], "DENIED")) { print "<td><font color='red'><b>DENIED</b></font></td>\n"; } else { print "<td><font color='green'><b>ALLOWED</b></font></td>\n"; } print "<td><a href='$row[url]' target='_blank'>$url</a></td></tr>\n"; } print "</table>\n"; [B][SIZE=1][COLOR=DarkRed]$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM log"),0); // Figure out the total number of results in DB: $total_pages = ceil($total_results / $max_results);  // Figure out the total number of pages. Always round up using ceil() echo "<br><br><center><span class='FormValueBold'>Select a Page</span><br />";  // Build Page Number Hyperlinks // Build Previous Link if($page > 1){     $prev = ($page - 1);     echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> "; } for($i = 1; $i <= $total_pages; $i++){     if(($page) == $i){         echo "<span class='SmallHeader'>$i</span> ";         } else {             echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";     } } // Build Next Link if($page < $total_pages){     $next = ($page + 1);     echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>"; } echo "</center>";[/COLOR][/SIZE][/B] mysql_close($connection); } }

I need help here.  I see so many xml rss feeds out there and wonder how they dynamically populate their feeds. Below is the code I am using from a tutorial I found online. But I still get validation errors that I simply do not understand. I've tested the feed on 3 different readers: Mozilla thunderbird, RssReader 1.0, and FeedReader 2.90. The tutorial showed me to create the feed with a .php extension.  Are not RSS feeds in XML?  You can test the feed at marcsteele.com/z.php in a rss reader. FeedValidator.org gives me the following errors: http://www.feedvalidator.org/check?...teele.com/z.php The weird thing is that I can get it to work on my localhost db, but not when I upload it to my server and call data from the production server's db. I am using IIS for the production server, and apache for my localhost. I can't image why that would make a difference. The only other issue I can image that is affecting the output is maybe apostrophes or special characters. Any help would be appreciated. My code: <? header("Content-Type: text/xml;charset=utf-8"); $connection = @mysql_connect("localhost", "root", "password"); $db = @mysql_select_db('pl', $connection); $sql = "SELECT * from products_description"; $result = @mysql_query($sql, $connection); ECHO <<<END <?xml version="1.0" encoding="utf-8"?> <rss version="2.0"> <channel> <title>Testing Oscommerce RSS Feeds</title> <link>http://localhost/</link> <description>Testing out Dynamic RSS feed from mysql.</description> END; while($row = mysql_fetch_array($result)) { $name = $row['products_name']; // display an item ECHO <<<END <item> <title>$name</title> <link></link> <description></description> </item> END; } ECHO <<<END </channel> </rss> END; ?>

Currently I've managed to create this graph with help from a tutorial on phpfreaks. [img src=\"http://www.coachloanprocessing.com/download/bar-graph.gif\" border=\"0\" alt=\"IPB Image\" /] Here is the code: <?php include ("c:/jpgraph/src/jpgraph.php"); include ("c:/jpgraph/src/jpgraph_bar.php"); $db = mysql_connect("localhost", "root","password") or die(mysql_error()); mysql_select_db("bar_graph",$db) or die(mysql_error()); $sql = mysql_query("SELECT * FROM employees") or die(mysql_error()); while($row = mysql_fetch_array($sql)) { $data[] = $row[1]; $leg[] = $row[0]; } $graph = new Graph(600,150,"auto"); $graph->SetScale("textint"); $graph->SetShadow(); $graph->Set90AndMargin(50,40,0,20); $graph->xaxis->SetTickLabels($leg); $bplot = new BarPlot($data); $bplot->SetFillColor("lightgreen"); // Fill color $bplot->value->Show(); $bplot->value->SetFont(FF_ARIAL,FS_BOLD); $bplot->value->SetAngle(45); $bplot->value->SetColor("black","navy"); $graph->Add($bplot); $graph->Stroke(); ?> And here is the mysql table: CREATE TABLE `employees` (`Name` varchar(50) default NULL, `Marks` int(11) default NULL); What I want to do is replace the top numbers with 00:00 - 23:59 military time. And I need to make it look like this below: [img src=\"http://www.coachloanprocessing.com/download/bar-graph2.gif\" border=\"0\" alt=\"IPB Image\" /] Basically it is a time schedule to let me know when an employee is working during the day. And so far the first example is as far as I can go without pulling my hair out. Does anyone have any ideas how to change the code to reflect this? thanks!

I'm looking to create a bar graph in php that allows me to view when an event is occuring during the day or week. It is similar to what Microsoft Outlook calendar does. Basically, I want to see a horizonal bar from a start time to an end time during a day. Does anyone know of any tutorials that explain this? thanks

I've got it working only if I delete "ENGINE+MYISAM DEFAULT CHARSET=latin1" However, I can't upload if I have the DROP TABLE IF EXISTS command in the sql: [!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--][!--sizeo:1--][span style=\"font-size:8pt;line-height:100%\"][!--/sizeo--][u]DROP TABLE IF EXISTS address_book;[/u] CREATE TABLE address_book ( address_book_id int NOT NULL auto_increment, customers_id int NOT NULL, entry_gender char(1) NOT NULL, entry_company varchar(32), entry_firstname varchar(32) NOT NULL, entry_lastname varchar(32) NOT NULL, entry_street_address varchar(64) NOT NULL, entry_suburb varchar(32), entry_postcode varchar(10) NOT NULL, entry_city varchar(32) NOT NULL, entry_state varchar(32), entry_country_id int DEFAULT '0' NOT NULL, entry_zone_id int DEFAULT '0' NOT NULL, PRIMARY KEY (address_book_id), KEY idx_address_book_customers_id (customers_id) );[!--sizec--][/span][!--/sizec--][!--colorc--][/span][!--/colorc--] any thoughts?

I need help with determining how to code PHP to allow me to upload my [!--coloro:#CC0000--][span style=\"color:#CC0000\"][!--/coloro--][u]tables.sql[/u][!--colorc--][/span][!--/colorc--] to my Database. I don't know if the errors lie within my php code, or if the sql file has problems. Here is the code I have so far: [!--sizeo:1--][span style=\"font-size:8pt;line-height:100%\"][!--/sizeo--][!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]<?php[!--colorc--][/span][!--/colorc--] [!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]$dbhost ='localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to the mysql db'); $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db($dbname);[!--colorc--][/span][!--/colorc--] [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--] ?>[!--colorc--][/span][!--/colorc--] <html> <head> <title>Inserting Tables to MySQL with PHP</title> </head> [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]<?php[!--colorc--][/span][!--/colorc--] [!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]mysql_create_db('TESTING-DATABASE'); // creates the database mysql_select_db('TESTING-DATABASE') or die('Cannot select database'); $queryFile = 'tables.sql'; $fp = fopen($queryFile, 'r'); $query = fread($fp, filesize($queryFile)); fclose($fp); $result = mysql_query($query);[!--colorc--][/span][!--/colorc--] [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]?>[!--colorc--][/span][!--/colorc--] <body> </body> </html> [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]<?php[!--colorc--][/span][!--/colorc--] [!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]mysql_close($conn);[!--colorc--][/span][!--/colorc--] [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]?>[!--colorc--][/span][!--/colorc--][!--sizec--][/span][!--/sizec--] So far I can only create the Database, but the file is not uploaded. I know my code may have problems, but I can't find where. Below is what I wanted to upload: [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--][!--sizeo:1--][span style=\"font-size:8pt;line-height:100%\"][!--/sizeo--]CREATE TABLE `002_news` ( `id_news` bigint(13) NOT NULL auto_increment, `ueberschrift` varchar(250) default NULL, `kurztext` longtext, `autor` varchar(100) default NULL, `von` date default NULL, `bis` date default NULL, `langtext` longtext, `bild` varchar(30) default NULL, `weiter` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`id_news`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;[!--sizec--][/span][!--/sizec--][!--colorc--][/span][!--/colorc--] Is it possible that the ENGINE=MyISAM DEFAULT CHARSET=latin1 is the cause? Because when I take it out, the uploading works. But why would this be an issue? Help! Marc