Re: [PHP] Creating an Advanced Form

2012-11-03 Thread Matijn Woudt
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

Re: [PHP] Creating an Advanced Form

2012-11-02 Thread Robert Stone
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

Re: [PHP] Creating an Advanced Form

2012-11-02 Thread tamouse mailing lists
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,

Re: [PHP] Creating an Advanced Form

2012-11-02 Thread Jay Blanchard
[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

[PHP] Creating an Advanced Form

2012-11-02 Thread Jonathan Davies
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()