Question

[3raser]

Thanks to Jcbones for giving me this code, and helping me with my previous problem. I've been fooling with the code to understand it more, and actually learn everything about it. But a question is, $name isn't inserting into the database. This is my file:

 

Justin - Owner	
Josh - Customer
Michael - Employee	
John - Customer

 

And here is my code:

 

$file = file("test.txt");
foreach ($file as $line)
{
$ex = explode("-", $line);
$name = trim($ex[0]);
$job = trim($ex[1]);
mysql_query("INSERT INTO test VALUES ('', $name, $job)");
}

 

Can someone please explain why I get this result in the database:

 

id - name - job

1,,owner
2,,customer
3,,employee
4,,customer

 

I'm not receiving the name. Why?

[PFMaBiSmAd]

To start with, your query does not have any single-quotes around the string data values, so it is impossible that is your actual code that inserted the data you are posting as being the results.

[3raser]

To start with, your query does not have any single-quotes around the string data values, so it is impossible that is your actual code that inserted the data you are posting as being the results.

 

Thanks.

[Pikachu2000]

Sheesh. Everyone's fast tonight . . .