Jump to content

Bad syntax in database retrieval


Timmyhavoc

Recommended Posts

Hi
I recently upgraded our site to PHP version 3.4 and now alot of my scripts arent working and i get this notorious and dredded error message:

Notice: Only variable references should be returned by reference in /homepages/20/d158757983/htdocs/ebshop/library/database.php on line 9

Notice: Only variable references should be returned by reference in /homepages/20/d158757983/htdocs/ebshop/library/database.php on line 25

I know this is to do with changing versions but im not the most PHP skilled person so can't see where the errors are, can someone shed some light?

The code producing the error reads like this:

[code]1 - <?php
2 - require_once 'config.php';
3 -
4 - $dbConn = mysql_connect ($dbHost, $dbUser, $dbPass) or die ('MySQL connect failed. ' . mysql_error());
5 - mysql_select_db($dbName) or die('Cannot select database. ' . mysql_error());
6 -
7 - function &dbQuery($sql)
8 - {
9 -    return mysql_query($sql);
10 - }
...
23 - function &dbFetchAssoc($result)
24 - {
25 -     return mysql_fetch_assoc($result);
26 - }[/code]

Id appreciate any help!
Link to comment
Share on other sites

Amazing! that certainly got rid of those warnings. thanks! what seems obvious to you can slip past my eyes so easily.

As for versions Its pretty hard for me to keep up, php is only one of the things i do at work. I generally have to source old scripts ive used in the past to save time.

One other thing which is probably also related to PHP versions, my .htaccess isnt working anymore and its needed to redirect all the include files. It looks like this:

[code]php_value include_path ".;\"my_server_directory"\htdocs\ebshop\;\"my_server_directory"\htdocs\ebshop\library\; \"my_server_directory"\htdocs\ebshop\include\"[/code]

Am i using old code again or am i getting the syntax wrong?
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.