Project Detail

MySQL / PHP Script Fix  

MySQL / PHP Script Fix is project number 281003
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Selected Service Provider)

Selected Providers: royventures

Budget: $30-250

Created: 06/30/2008 at 11:11 EDT

Bid Count: 14

Average Bid: $ 69

07/20/2008 at 11:11 EDT

Project Creator: oldart View PM Post PM
Employer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 (4 reviews)

Bid On This Project
 

Description

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 4.1.12, 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.

Messages Posted: 0 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options

  View PM Post PM

100

1 day

06-30-2008 11:20 EDT

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

help

  View PM Post PM

65

0 days

06-30-2008 11:17 EDT

can you pls provide me your website url. Thanks

help

  View PM Post PM

40

1 day

06-30-2008 12:16 EDT

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

help

  View PM Post PM

50

1 day

06-30-2008 11:22 EDT

We can do the fix

help

  View PM Post PM

150

8 days

06-30-2008 12:06 EDT

Message in PM...

help

  View PM Post PM

100

3 days

06-30-2008 11:16 EDT

Hi, Please see PMB. Thank you,

help

  View PM Post PM

30

0 days

06-30-2008 11:37 EDT

Please see PMB

help

  View PM Post PM

75

1 day

06-30-2008 11:24 EDT

I can fix this

help

  View PM Post PM

30

1 day

06-30-2008 11:46 EDT

Please check PM, Thanks.

help

  View PM Post PM

50

1 day

06-30-2008 11:28 EDT

please view pmb.

help

  View PM Post PM

50

1 day

06-30-2008 11:17 EDT

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

help

  View PM Post PM

50

1 day

06-30-2008 11:39 EDT

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

help

  View PM Post PM

50

0 days

06-30-2008 11:39 EDT

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

help

  View PM Post PM

125

3 days

06-30-2008 11:56 EDT

(No Feedback Yet)

i can help you.

help

    Bid on this Project