Programming Bulls

I get error "That Access denied using password Yes when uploading excel file.But the Code work perfect in my local machine!Take a look of this peace of code and help me solve this


$uploadDir = 'C:/Program Files/xampp/htdocs/supplychain/supply/Uploaded Files/';

if(isset($_POST['upload']))

{

$fileName = $_FILES['userfile']['name'];

$tmpName = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

I was wondering wich result is better for my friend list...

If I have 1.000.000 rows in a table and need to select multiple rows from it for example

select * from friend where login='fever' will have 200 results

or is it better that I put in an array and split it in php

for example ¦me¦you¦fever¦webmaster¦world¦

select * from friend where login='fever' will have 1 results

$friends=split("\¦",$qeuryresults);

and loop them out...?

Hey guys,

How do I bring a mediumblob from my table into php?

Hi,

I am a newbee as far as My SQL is concerned. I bought a website with a database full of products. I'd like to delete specific records. I want to delete those records with a price less than $4.95 and all products that don't have a photo.

The table is called 'goods'

Price is in the 'price' field ie. $6.95 is 695

Product photo is in the 'photoUrl' field ie. http://www.site.com/pic.jpg. The field is empty if no photo exists.

Hi!

I have a php class that validates user submited content. It goes something like this:

$var = $validate->fct($_POST['something']);

... and in my class:

function fct($var){
   //validates data
   if($noproblem){
      return $var;
   }else{
      //logout the user and exit();
   }
}

I need to be sure that the script exits when !$noproblem. I really don't know if the php waits for the function to end or if it goes on. Any help?

Below I have some PHP code which is a loop to go through and delete a series of users; however, it seems to fail when $in is too large. I'm trying to figure out what determines too large? Is it a PHP issue of the variable being too long? Is it a MySQL issue of how big $in can be? If I can figure it out what/where the limitation is then I could probably program around it by dumping $in into an array and processing it in chunks. Any suggestions or ideas would be appreciated?

Peace - Anthony Borrow, SJ

--- code segment ---

Hi Guys

Could anyone help me, How can I edit database in a live project by entering into cpanel of server? Any suggestion will be appreciated.Thanks

Raj

I have site set up in Dreamweaver, have local host running (wampserver2.0) with pphpmyadmin and everything..Database and recordset are fine, populated locally.

What exactly do I need to do to have the site, when uploaded to my 1and1 server, connect & populate the mySQL database on my 1and1 server??

Would love any info I can get.

Thanks all!

Hi,

I am new to using MYSQL with PHP,

I am trying to create an inventory webpage for our intranet system,

currently I have:

===========================

$ypcodes_sql = 'select * from COMPUTERS';

$ypQuery = mysql_query($ypcodes_sql,$conn) or die(mysql_error());

while($ypArray = mysql_fetch_array($ypQuery))

{

echo('