[SOLVED] automatic display

[bluebutterflyofyourmind]

so from phpmyadmin, look at the table medic_registered_course and tell me what types you assigned to which fields

[girlzz]

matric_no------>varchar

name-------->text

year---------->varchar

group-------------> int

session---------> varchar

id---------> int

i had made changes in my code but it return to this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'block 2,, 2)' at line 1

 

$insertSQL2 = sprintf("INSERT INTO medic_registered_course (matric_no, name, sessi, `year`,`s_code`, `group`) VALUES ( %s, %s, %s, %s,%s, %s)",
                       GetSQLValueString($_GET['matric'], "varchar"),
                       GetSQLValueString($_GET['name'], "text"),
                       GetSQLValueString($_GET['sessi'], "varchar"),
                       GetSQLValueString($_GET['year'], "varchar"),
			        GetSQLValueString($_GET['txtHint'], "varchar"),
                       GetSQLValueString($_GET['group'], "int"));
				   

[bluebutterflyofyourmind]

where is the field for s_code?

 

also in your sql statement, you should not have ' around year, s_code or group.

 

infact... where is your stuff for s_code. i only see it in one spot in the sql statement.  you have no GetSQLValueString for it

[girlzz]

s_code is retrive from ajax which id="txtHint"

[bluebutterflyofyourmind]

yes but you need a field for s_code to be stored in the database. correct?

[girlzz]

oh that means i had to change at the getvalue string from txthint to s_code??

[bluebutterflyofyourmind]

k in your database......in your table.....do you have a field called s_code?

[girlzz]

yup... in table medic_registered_course

[bluebutterflyofyourmind]

is it's type varchar?

[bluebutterflyofyourmind]

and in your GetSQLValueString you have no case for varchar

[girlzz]

yup... no case for varchar??? explain please

[bluebutterflyofyourmind]

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

 

you have no 

 

case"varchar":
$theValue = other code
break;

[girlzz]

still s_code connot be null... arghhh so stuck!! huhuhuhh

[girlzz]

finally.... it's work!!!! yeaaahhhhh!! thanksss!!!!!!!

[bluebutterflyofyourmind]

excellent.  not sure if anything i said helped but glad you got it working!

 

 

do'nt forget to mark this topic as solved at the bottom of this thread.

 

 

seee ya!

 

-Grant

[girlzz]

thanks a lot.. now i can try to make ajax using matric_no.. if i want to make using ajax,i still have to make new function or just create new ajax?

[bluebutterflyofyourmind]

depends on how you set up your ajax function.

 

i'd say you should make a new AJAX function for each new request.

[girlzz]

ok thanks..