[SOLVED] whats wrong with this mysql ?

[jjk2]

im trying to replace video_name with a new name that has random characters added on to it.

 

<?php

$conn = mysql_connect('localhost', 'user', 'password') or die ("failed to connect");
$db = mysql_select_db("somedatabase", $conn) or die ("failed to find db");

$result = mysql_query("SELECT * FROM videos WHERE ID > 1186") or die("failed query");


while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$tmp_sid = md5(uniqid(mt_rand(), true));

$newname = $tmp_sid . '__' . $row['ID'] . '.wmv;

$sql = "UPDATE videos SET original_video = $newname WHERE VIDEOID = $row['VIDEOID']";
$query = mysql_query($sql) or die("epic fail");

mysql_query($query) or die("cannot send query");

}

mysql_close($conn);


?>

[trq]

Your missing a few quotes.

 

while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
  $tmp_sid = md5(uniqid(mt_rand(), true));

  $newname = $tmp_sid . '__' . $row['ID'] . '.wmv';

  $sql = "UPDATE videos SET original_video = $newname WHERE VIDEOID = {$row['VIDEOID']}";
  $query = mysql_query($sql) or die("epic fail");

  mysql_query($query) or die("cannot send query");

}

[jjk2]

Invalid query: Unknown table '912764293f0a8f3643c056c4df5951bd__100.wmv' in field list

 

 

[trq]

$sql = "UPDATE videos SET original_video = '$newname' WHERE VIDEOID = '{$row['VIDEOID']}'";

[jjk2]

mysql_fetch_array(): supplied argument is not a valid MySQL result

[trq]

Post your code.