[SOLVED] I have some code linked to mysql ect but the data will not insert into mysql

[jbulmer09]

<?php

$con = mysql_connect("connection","username","database");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("database", $con);

$numbers = $_REQUEST['sendto'];

$from = $_REQUEST['from'];

$smsmsg = $_REQUEST['smsmsg'];

$phonechunks = explode(",", $numbers);

$e = count($phonechunks);

for ($i=0; $i<$e; $i++)

{

$rawdata = "$phonechunks[$i]";

$placeholders = array('+', ' ');

$vals = array('', '');

$newdata = str_replace($placeholders, $vals, $rawdata);

mysql_query("INSERT INTO send (sendto, smsfrom, smsmsg)

VALUES ('$newdata', '$from', '$smsmsg')");

}

?>

Can any one spot the mistake?

[trq]

Could be anywhere, why don't you try and actually debug your errors to see whats happening? eg;

 

$sql = "INSERT INTO send (sendto, smsfrom, smsmsg) VALUES ('$newdata', '$from', '$smsmsg')";
if (!mysql_query($sql)) {
  echo mysql_error() . "<br>" . $sql;
}

]

[jbulmer09]

ok ill do this now, just to add the row is created just no info inserted inside it

 

edit: Query was empty is the out come of that but i dont understand why, when i echo the variables that i would like to insert into the data base they show

[trq]

Yeah, well echoing the $sql var like I have shown will provide us with the details to see exactly what the database is receiving as a query.

[jbulmer09]

hmm so the rariables have info in them but the query is empty. thanks for help btw

the problem is in the variables, if i put in solid info like 1, it inserts it :s

[trq]

Can we see your actual query?

[jbulmer09]

managed to ix it, there was a problem with the data coming in

 

thanks for the help