For Programmers: Free Programming Magazines  


Home > Archive > PHP Language > November 2005 > problem with mysql since the move









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author problem with mysql since the move
scot_nery

2005-11-20, 3:55 am

I just moved my files and my data over to a new host.
old server: PHP 4.4.0 MYSQL 4.0.24
new server: PHP 4.3.9 MYSQL 4.1.12

now, this query won't work.
SELECT id FROM mr_discussion WHERE category='$discategory'

this one will.
SELECT id FROM mr_discussion

could someone please help? I searche a lot for this answer. Thank
you.

Scot

Connector5

2005-11-20, 7:55 am

Paste the block of code that you use for the query and some examples of
$discategory please.




"scot_nery" <scot@juggle.com> wrote in message
news:1132459869.671001.28230@z14g2000cwz.googlegroups.com...
> I just moved my files and my data over to a new host.
> old server: PHP 4.4.0 MYSQL 4.0.24
> new server: PHP 4.3.9 MYSQL 4.1.12
>
> now, this query won't work.
> SELECT id FROM mr_discussion WHERE category='$discategory'
>
> this one will.
> SELECT id FROM mr_discussion
>
> could someone please help? I searche a lot for this answer. Thank
> you.
>
> Scot
>



scot_nery

2005-11-20, 7:55 am

The best way to solve a problem is to post it on the internet. Then,
after a thorough forhead beating, you'll apologize and say "Thank you
for helping me. I was an idiot and forgot to check _______."

The "_______" in this case is get variables. My old server would
exract the $_get variables. New one doesn't.

Thank you.

wideangle@gmail.com

2005-11-22, 7:56 am

Dealing with $_get variables?

> Then, after a thorough forhead beating, you'll apologize and say "Thank you
> for helping me.


Oh, right! It happens all the time, at least for me ;)



--
Raqueeb Hassan
Bangladesh

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com