strange query

[Vivid Lust]

Hi, the following doesn't seem to be working for some strange reason  ???

 

<?php
...
$sql5="UPDATE settings SET ad1='$ad1' WHERE id='1'"; 
		mysql_query($sql5) //execute query
		or die(mysql_error()); // if error show it 
..
?>

 

I printed out $sql5 I ran it directly in the PHPmyAdmin SQL area and it works fine. However the problem, is that the code doesn't display any error however when looking at the database, the field which it should update is blank.

 

I hope someone can help,

 

Jake

[wildteen88]

Where is the variable $ad1 definded? And when you echo $sql5; does your query look right?

[Vivid Lust]

Query echos as:

 

UPDATE settings SET ad1='adhere' WHERE id='1'

 

so its all fine, that works in phpmyadmin too!

[wildteen88]

What data type is your ad1 field set to? Post your table schema here.

[Vivid Lust]

This what you needed?

 

Campo  Tipo  Cotejamiento  Atributos  Nulo  Predeterminado  Extra  Acción

id int(50) No auto_increment Navegar los valores distintivos Cambiar Eliminar Primaria Único Índice Texto completo

ad1 text latin1_swedish_ci No Navegar los valores distintivos Cambiar Eliminar Primaria Único Índice Texto completo

ad2 text latin1_swedish_ci No Navegar los valores distintivos Cambiar Eliminar Primaria Único Índice Texto completo

artist text latin1_swedish_ci No Navegar los valores distintivos Cambiar Eliminar Primaria Único Índice Texto completo

logo text latin1_swedish_ci No Navegar los valores distintivos Cambiar Eliminar Primaria Único Índice Texto completo

status text latin1_swedish_ci No Navegar los valores distintivos Cambiar Eliminar Primaria Único Índice Texto completo

winnerText text latin1_swedish_ci No Navegar los valores distintivos

[Vivid Lust]

Someone please help? I need this sorted urgently.

[wildteen88]

Seeing as your id field is set to int there is no need to wrap the id in your query within quotes.

 

$sql5="UPDATE settings SET ad1='$ad1' WHERE id=1";

 

if it still does work I dont know what else to suggest.

[Vivid Lust]

still doesnt work ... this is so strange

[wildteen88]

Is there a field with the id of 1 in your settings table? What is the output of

echo mysql_info();

When you place that after mysql_query()

[Vivid Lust]

 

Rows matched: 1 Changed: 1 Warnings: 0UPDATE settings SET ad1='dd' WHERE id=1

[wildteen88]

Yet the field still blank? You sure nothing else in your code is updating the field?

[Vivid Lust]

full code:

 

<?php session_start();  $session = $_SESSION['member']; ?>

<?php

ini_set("display_errors","2");

ERROR_REPORTING(E_ALL);

 

if (!isset($_SESSION['member'])){

header('location:http://www.xxxxxxxxxxx.com/');

die;

}

include('config.php');

$sql2 = "select * from user WHERE email = '$session' ";

$result2 = mysql_query($sql2, $connect)

or die(mysql_error());

while($row=mysql_fetch_assoc($result2)){

$admin         = $row['admin'];

 

}

if($admin !== "yes"){

header('location:http://www.fxxxxxxxxxx/user.php');

die;

 

 

}else{

include('top.php');

 

$ad1 = $_POST['ad1'];

$ad2 = $_POST['ad2'];

$artist = $_POST['artist'];

$logo = $_POST['topLogo'];

 

$sql5="UPDATE settings SET ad1='$ad1' WHERE id=1";

mysql_query($sql5) //execute query

or die(mysql_error()); // if error show it

echo mysql_info();

echo $sql5;

 

//$sql6="UPDATE settings SET  ad2='$ad2' WHERE id='1'";

// mysql_query($sql6, $connect) //execute query

// or die(mysql_error()); // if error show it

//

// $sql7="UPDATE settings SET artist='$artist' WHERE id='1'";

// mysql_query($sql7, $connect) //execute query

// or die(mysql_error()); // if error show it

 

// $sql8="UPDATE settings SET logo='$logo' WHERE id='1'";

/// mysql_query($sql8, $connect) //execute query

// or die(mysql_error()); // if error show it

?>

<div id="signup">

<strong>Images Updated!</strong>

<br /><br />

 

<center>[ <strong><a href="logout.php">logout</a> </strong>] [ <a href="changeimages.php"><strong>back to change images</strong></a> ] [ <a href="user.php"><strong>back to admin home</strong></a> ]</center>

</div>

<?php

include('bott.php');

}

?>

[Vivid Lust]

Is this code helpful? Do you want the code before?

[haku]

That really looks like it should be working.

 

Some other things to check:

 

* Are you sure you are looking at the right table? You should be looking at the table called 'settings'.

* Are you sure you are looking at the right database? Maybe you have two inside your phpmyadmin, and you are looking at the wrong one?

* Are you sure you are looking at the right server? Maybe you are making the changes on a local server, and looking through phpmyadmin at a remote server?

 

All of these seem like stupid mistakes, but they are all mistakes I have made in the past myself  I've wondered for hours why something that should be working wasn't, and it was one of the above.

[Vivid Lust]

Would it make any difference if I included the config.php file twice? a file containg db connection.

[Vivid Lust]

Anyone? I really need this sorted.

[haku]

Did you double check those three things I listed?

[Vivid Lust]

Yes I have and they are correct

[Vivid Lust]

This still isn't working ... help appreciated :S

[Vivid Lust]

Instead of using the previous query, I used this instead:

 

UPDATE `settings` SET `ad1`='http://www.xxxxxxxxxxx.com/images/ad.jpg' WHERE `id`=1

 

And it works like this! However not like this:

 

"UPDATE settings SET ad1='$ad1' WHERE id='1'"

 

When echoing out the above query, it displays correctly as the query at the top here. Anyone know what's going on? Thanks.

 

[wildteen88]

If you remove $ad1 from query and replace it with a simple string like ad here does it update?

[Vivid Lust]

Yes, It updates.... :S

[wildteen88]

Ok... Change your query to

$sql5="UPDATE settings SET ad1='".mysql_real_escape_string($_POST['ad1'])."' WHERE id=1";

[Vivid Lust]

Thanks soo much! It now works

[wildteen88]

How weird. We got there in the end. FYI this code

$sql5="UPDATE settings SET ad1='$ad1' WHERE id=1";
         mysql_query($sql5) //execute query
         or die(mysql_error()); // if error show it
         echo mysql_info();
echo $sql5;       
         
      //$sql6="UPDATE settings SET  ad2='$ad2' WHERE id='1'";
      //   mysql_query($sql6, $connect) //execute query
      //   or die(mysql_error()); // if error show it
      //   
      //   $sql7="UPDATE settings SET artist='$artist' WHERE id='1'";
      //   mysql_query($sql7, $connect) //execute query
      //   or die(mysql_error()); // if error show it
         
      //   $sql8="UPDATE settings SET logo='$logo' WHERE id='1'";
      ///   mysql_query($sql8, $connect) //execute query
      //   or die(mysql_error()); // if error show it

 

Can combined into just one query

$sql5="UPDATE settings SET ad1='".mysql_real_escape_string($_POST['ad1'])."', ad2='".mysql_real_escape_string($_POST['ad2'])."', artist='".mysql_real_escape_string($_POST['artist'])."', logo='".mysql_real_escape_string($_POST['logo'])."' WHERE id=1";