[RESOLVED] query insert confusion.

IceRegent

Hiya.. I have a query for my projects insert, that works fantastical for what I need it to do. But when I run the same type of query for my users table, I get an error message of :
"Error, insert query failedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES ('popeye', 'bluto', '2006-01-01')' at line 1"

I am using bogus information in the user and password and date fields, but the format should be ok. here is the working code from the projects query:

<?php
include "db_config.php";
mysql_select_db(iceregen_MStudio);


$query = "INSERT INTO projects (UserID, ProjDesc, file, OrigProj, OrigUser, ProjDate) VALUES ('3', '$ProjDesc', '$File', '3', '4', '2005-01-01')";

mysql_query($query) or die('Error, insert query failed'.mysql_error());

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed'.mysql_error());
?>

This is the results that this code produces:

Author 	Project Name 	     Original Project 	 Original Author 	Project Date

3 	".craigs1a.mid ."	3 	              4 	          2005-01-01

Now, here is the non-working code from the user's query:

<?php
include "db_config.php";
mysql_select_db(iceregen_MStudio);


$query = "INSERT INTO users (UserName, password, datejoin,) VALUES ('popeye', 'bluto', '2006-01-01')";

mysql_query($query) or die('Error, insert query failed '.mysql_error());

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed '.mysql_error());
?>

There is a numeric autoincrememnting field in front of both of these php tables, and the projects one seems to work fine.

The error code doesnt make it clear to me what is wrong in the user insert code. Can someone lead the blind to the error?

Thank you;
Ice

rane500

You've got an extra comma in the user query...(UserName, password, datejoin,)

IceRegent

Hello; I am trying to replace numeric values when I echo out the info, with alpha values who's numeric ID matches the key ID from a User table. The 2 tables I use are 'Projects' and 'users' from a common database. I am having trouble with replacing the numeric value. Here is the php code I have created:

<?php
include "db_config.php";
mysql_select_db(iceregen_MStudio);

echo '<table border="2" style="border: 2 solid #800000; padding: 1" width="100%" bgcolor="#CCCCCC">';
echo '    <tr>';
echo '        <td width="20%">Author</td>';
echo '        <td width="20%">Project Name</td>';
echo '        <td width="20%" >Original Project</td>';
echo '        <td width="20%" >Original Author</td>';
echo '        <td width="20%" >Project Date</td>';
echo '    </tr>';
echo '</table><br>';

$query  = "SELECT ProjID, UserID, ProjDesc, file, OrigProj, OrigUser, ProjDate FROM projects";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

$remnant = $row['UserID'];

$query1 = "SELECT UserName FROM users WHERE UsedID='$row['UserID']'";
$result1 = mysql_query($query1);
while($row1 = mysql_fetch_array($result1, MYSQL_ASSOC))
  { 
  			echo $row1['UserName'];
  			}

	echo '<table width="100%" border="2" cellspacing="2" cellpadding="2" bgcolor="#84BBD9" bordercolor="#400000">';
	echo '<tr>';
	echo '<td width="20%">' . $row['UserID'] . ' </td>';
	echo '<td width="20%"><a href=/dubious/projects/' . $row['file'] . ' >".' . $row['file'] . ' ."</a></td>';
	echo '<td width="20%">' . $row['OrigProj'] . ' </td>';
	echo '<td width="20%">' . $row['OrigUser'] . ' </td>';
	echo '<td width="10%">' . $row['ProjDate'] . ' </td>';
	echo '<td width="10%">' . $UserInfo . ' </td>';
	echo '</table>' ;  
	echo $remnant, $result1; 
} 

mysql_close();
?>

Here, is the error message I get with the :
$query1 = "SELECT UserName FROM users WHERE UsedID='$row['UserID']'";

like it is. When I trunceate that to :
$query1 = "SELECT UserName FROM users";

I get this response:

MStudio Projects - Click on Project Name to view details about the project.
Author 	Project Name 	Original Project 	Original Author 	Project Date

popeyeolivoilashleymarlenecraig
3 	".craigs1a.mid ."	3 	             4 	              2005-01-01

So, it is reading the UserName's from the 'users' table, but I cannot seem to get a comparison using the 'WHERE' statement to select the "UserName WHERE the $row['UserID'] = the key-autoincrement".. from the users table, which has a table field name of 'UserID'.

Any ideas?

thank you;
Ice

bpat1434

$remnant = $row['UserID'];

$query1 = "SELECT UserName FROM users WHERE UsedID='$row['UserID']'";

Try:

$query1 = "SELECT UserName FROM users WHERE UsedID='$remnant'";

rane500

Does the table contain a column called "UsedID", or should it be "UserID"?

IceRegent

Oh wow, I didnt even see that error. It should be UserID, not UsedID. Could that be the simple problem keeping it from working? I will try that and the other suggestions. Thanks. I will let you know what resolves it.

Ice