Op 3 nov. 2012 02:12 schreef "tamouse mailing lists" <
tamouse.li...@gmail.com> het volgende:
>
> I'm sorry. This code just makes me weep.
>
> Let's just take a quick look at this line here:
>
> > $rsSearch = mysql_query($sqlSearch);
>
> You have not supplied a database connection, so mysql_query w
Hi Jonathan,
Haven't used MySql for ages. More used to Oracle and PostgreSql.
Your table nmc_cd contains foreign keys pointing to nmc_category and
nmc_publisher. Create a view containing all the data from those three tables
using implicit joins as the data in table nmc_cd should NOT contain any
I'm sorry. This code just makes me weep.
Let's just take a quick look at this line here:
> $rsSearch = mysql_query($sqlSearch);
You have not supplied a database connection, so mysql_query will fail.
Further, you have not even checked the result to *see* if it failed.
Once you fix those things,
[snip] Warning: mysql_fetch_assoc(): supplied argument is not a valid
MySQL result resource in
/var/www/vhosts/numyspace.co.uk/web_users/home/~unn_w11014928/public_html/search.php
on line 261[/snip]
It would appear that your query is not returning a result. Echo out the
query and try running
Hi,
I am attempting to create an advanced form with 9 different search fields.
I am using the WHERE 1 AND sql function to add onto the generated end sql
function so I don't have to created over 300,000 IF statements. The code below
is showing up this error:
[quote]Warning: mysql_fetch_assoc()
5 matches
Mail list logo