[strange query]

Someone please help? I need this sorted urgently.

[strange query]

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

[strange query]

Query echos as:

 

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

 

so its all fine, that works in phpmyadmin too!

[strange query]

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

[PHP OOP projects]

Could anyone suggest me any small projects/problems where by I can practice and learn PHP OOP?

 

Thanks,

 

Jake

[DISTINCT rules]

Hi all!

 

I'm wondering if I could create rules for when using "DISTINCT".

 

Such as

 

"Unites States" and "United States of America" are both the same, so they are DISTINCT etc.

 

Thanks all,

 

Jake.

 

["Keep" data in form when refreshed]

anyone?

["Keep" data in form when refreshed]

To add to that, the form directs to x.php and if there is an error it goes back to y.php (where the form is)

 

 

["Keep" data in form when refreshed]

Any ideas how I can keep current data in a form when the page is refreshed?

 

Thanks,

 

Jake.

[timestamp conversion]

Yeah, and I've tried what I've come across and they don't worry

[timestamp conversion]

Any ideas?

[Resize image with same aspect ratio]

I'm only 16 and don't have a job, so .... 

[Resize image with same aspect ratio]

My friend has a VPS, this is on a VPS, so he can enable anything I want. Plus I'm getting this for free 

[timestamp conversion]

Hey all! 

 

How can I convert:

 

1969-12-31 19:33:29

 

into, for example:

 

22nd May at 19:33

 

Assuming that the timestamp represents 22nd May, 19:33

 

Thanks,

Jake.

[Resize image with same aspect ratio]

Problem solved = friend gave my unmetered hosting for free:)

[Resize image with same aspect ratio]

err I do pay for it thanks.

[Resize image with same aspect ratio]

I've already said my host doesn't allow getimagesize() ..

 

thanks for trying.

[Resize image with same aspect ratio]

Hi,

 

I have image URL's stored in the database and want to resize them so they fit into the div width of X and so that they mantain their original aspect ratio.

 

My first step would be:

 

GetImageSize($image);

 

where $image is the current URL from the database. However my host does not allow this.

 

Jake.

[Resize image with same aspect ratio]

e.g ?

[Resize image with same aspect ratio]

I don't know the original width/height, all this is coming out from the database

 

I can't use getImageSize() , host has disabled allow_url_fopen

[Resize image with same aspect ratio]

Oh, which keeps the original aspect ratio if there is a limit of 200px on the width? I don't think there is 

[Resize image with same aspect ratio]

Is there anyway to do this without using getImageSize()  ???

 

Thanks

[PHP cURL]

Thanks!

 

Say this was on a page:

 

<div class="foo">bar</div>

 

How would I get everything within the div?? so targetting the class foo

 

Thanks

[PHP cURL]

Could anyone give me an example of say, getting the <title> value of Google with PHP cURL?

 

Thanks,

 

Jake.

[remote document.getElementById()]

On a differnt domain.