Mysql-link resource error

I have produced a section for adding jobs to my website using data assist, but I have used dynamic lists so that i can select from a list that is stored in a database. On the insert page i keep getting the following two errors:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/ukrecrui/public_html/admin/UKJobs/Jobs_Insert.php on line 41

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/ukrecrui/public_html/admin/UKJobs/Jobs_Insert.php on line 44

--------------------------------

mysql_select_db($database_Connection, $Connection);
$query_WADADynListSpeciality = "SELECT Value, Speciality FROM Speciality";
$query_limit_WADADynListSpeciality = sprintf("%s LIMIT %d, %d", $query_WADADynListSpeciality, $startRow_WADADynListSpeciality, $maxRows_WADADynListSpeciality);
$WADADynListSpeciality = mysql_query($query_limit_WADADynListSpeciality, $Connection) or die(mysql_error());
$row_WADADynListSpeciality = mysql_fetch_assoc($WADADynListSpeciality);

-------------------------------------

please can someone help point me in the right dirrection

Kind Regards

Brian

Do you have the require once line of code for you connection before the query on the page? If not this could be the problem. When you get this error it is telling you that the variable that is being referenced in the mysql_select_db is not valid. This variable should be set in the connection file that you have, so long as it is included on the page before this code you should not get this error.

Hi,

I have the require once line of code at the start of the page. When I create all the pages using Dataassist the insert page is the only one that populates this error. I have been using Dataassist for a long time now and never had this error before.

The connection file works fine for all the other pages (Update etc, but does not for the Insert page). I have ran the wizzard several times and even with no template and it still produces the error.

I have attached the inset page code if this helps

Kind Regards

Brian

Are you getting this error on this page currently? The lines of code that are referenced in the error you first posted are not in this file. In the error you posted the line of code that was causing the error looked like this:

mysql_select_db($database_Connection, $Connection);

In the file you posted that line of code is not present, instead you have a select db that looks like this:

mysql_select_db($database_localhost, $localhost);

By the looks of your connection file it seems that the $localhost reference is the correct one. If you continue to have problems with this please also post back with a copy of any of the other DataAssist pages that are not giving you an error.

Hi,

I have tried to re produce the insert page with dataassist, it works fine when you do not use a template or my own template a have created with sculptur.

But when I use the Power CMS admin template it throws up the following error:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/ukrecrui/public_html/admin/AddJob/Jobs_Insert.php on line 20

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/ukrecrui/public_html/admin/AddJob/Jobs_Insert.php on line 24

It seems to move the <?php require_once('../../Connections/localhost.php'); ?> down to line 38.

I have attached the admin code and the new insert page that has the above error.

Kind Regards

Brian

It looks like DataAssist is just putting in it's code at the very top of the page, this probably has to do with how the code is crafted and the order that the code and template are applied to the page.

The fix for this page is to move the other include lines up to the top of the page, I have made this update so you can see the difference. When the include lines are above the code that makes use of them you should not get errors relating to the variables or other values in the include files.

Many thanks, I move the code on the insert page to the top of the page, but still got an error. I then noticed that all other dataassist pages had the same problem. So I move the lines to the top on all the other pages like the results page and all works fine.

Thanks again for you help with this.