Re: [PHP] It only prints lines that beggin with a number? I'm on a deadline!

2002-11-15 Thread 1LT John W. Holmes
$result = mysql_query (SELECT * FROM `data` WHERE categories); Where categories is what?? You don't have any comparison... What it's doing is evaluating the column as true or false. Any integer column 0 will evaluate to true, so that row will be returned. 1A will be converted to 1, so it'll be

Re: [PHP] It only prints lines that beggin with a number? I'm on a deadline!

2002-11-15 Thread Godzilla
Thanks so much guys, that worked perfectly. I do ok with php but am still on the bumpy part of the road with SQL queries. Thanks again! Regards, Tim 1lt John W. Holmes [EMAIL PROTECTED] wrote in message news:00da01c28cad$b9a90d50$a629089b;TBHHCCDR... $result = mysql_query (SELECT * FROM

[PHP] It only prints lines that beggin with a number? I'm on a deadline!

2002-11-14 Thread Godzilla
Hi everyone, I have a pretty strange problem that may be simple, but I have never heard of it. //I have a database in the following format: 2 2 2 Cd's Cd's DVD's DVD's DVD's DVD's DVD's // Someone recently helped me out in writing a short script that would turn it into