Tamamlanmış

MySQL / PHP Script Fix

I recently purchased a small website that uses PHP & MySQL. It worked perfectly on another hosting company, but when I installed it on my server it will not work properly.

I believe it is perhaps a MySQL issue as the previous version of MySQL was [url removed, login to view], and now I am using it on version 4.1.20.

The script is reading and writing to the DB, although it is not working correctly. I am seeing the following errors:

PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/….

And the script is not reading and writing cookies correctly. Here is one sample section of the script that is giving errors:

<? }

} else if ($type == "my-favorites") {

$query_2 = "SELECT * FROM favorites WHERE cookie_id = $cookie_id ORDER BY rand() DESC";

$queryResource_2 = mysql_query($query_2);

while ($row_2 = mysql_fetch_array($queryResource_2, MYSQL_ASSOC)) {

$resource_id = $row_2['resource_id'];

$query = "SELECT * FROM resources WHERE resource_id = $resource_id AND category_id = $id";

$queryResource = mysql_query($query);

if ($row = mysql_fetch_array($queryResource, MYSQL_ASSOC)) {

$title = ShortenText($row['title'],45);

$url = ShortenText($row['url'],60);

$temp_div_number++;

$row_count++; ?>

I am looking for someone who understands PHP and MySQL, and can make my site work correctly. Site also uses AJAX, but I do not believe there is a problem with this.

Beceriler: AJAX, PHP, Betik Yükleme

Daha fazlasını gör: writing in script, writing fix website, writing fix, website errors fix, the writing fix, seeing and writing 4, script writing work, my fix it, my fix, i will fix it, valid id, type of cookies, script writing, php writing, php db, mysql query, Mysql php, hosting issue, fix mysql query, desc

İşveren Hakkında:
( 15 değerlendirme ) Henderson, United States

Proje NO: #281003

Seçilen:

royventures

please view pmb.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(11 Değerlendirme)
4.9

Bu iş için 14 freelancer ortalamada $69 teklif veriyor

value4u

Hi, I can get it done in 1 day. Please check my PM. Thank you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(289 Değerlendirme)
8.2
dboyzhang

Hi, I have experience on AJAX and customized PHP system. Please send me details then I can see whether I can help you. Regards Bo Zhang

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(289 Değerlendirme)
7.1
Rautella

can you pls provide me your website url. Thanks

$65 USD in 0 gün içinde
(203 Değerlendirme)
6.6
mharvinhl

Hi, Please see PMB. Thank you,

$100 USD in 3 gün içinde
(100 Değerlendirme)
6.2
unknownsoftware

Satisfaction guaranteed. Escrow required before i start working on the project. Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(157 Değerlendirme)
6.0
ionix

Message in PM...

$150 USD in 8 gün içinde
(61 Değerlendirme)
6.0
waterstudio

Please see PMB

$30 USD in 0 gün içinde
(68 Değerlendirme)
5.9
www6STECHcom

We can do the fix

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(41 Değerlendirme)
5.8
rshyethmusthafa

I can fix this

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(30 Değerlendirme)
4.8
imedvan

Hi. I can fix it today. It seems problem in php version not mysql. No escrow required. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
3.8
IndoFreelancer

Please check PM, Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.3
freelance218

Hi, I can fix your problem ASAP. Thank you.

$50 USD in 0 gün içinde
(1 Yorum)
3.0
zorro319

i can help you.

$125 USD in 3 gün içinde
(0 Değerlendirme)
0.0