Re: one step up ...

2002-09-27 Thread Clive Smart
Hi there Just type in: "show databases;", which will list all databases, then type in: "use mysql;" or whichever database you require Simple Clive hans schneidhofer wrote: > hi list, > have a simple newbie-question > was looking for a possibility to go back one step after do a "use sample_db"

Re: please help with sql query

2002-09-27 Thread Clive Smart
Hi there Try This: SELECT products.product_name, products.fg_number, images.image_name, images.thumbnail, images.image_path, images.color_depth, images.width_inches, images.height_inches, images.resolution, images.filesize, images.filetype, images.notes FROM products LEFT JOIN images ON produc

Re: Goodday

2002-09-10 Thread Clive Smart
How did this get past the filters? Ocita Gabriel wrote: > Attn: mysql , > > My name is Ocita G, the manager, credit > and foreign bills of Ecobank Plc. I am writing in > respect of a foreign customer of my bank with account > number 14-255-2004/utb/t who perished in a plane crash > [Korean A

Re: Strings between HTML, PHP and MySQL

2001-09-27 Thread Clive Smart
Try SELECT my_table WHERE ident1 = $id1, ident2='$id2'; Note the single quotes around $id2 Clive Mon PC wrote: > > I'm sending variables in an HTML request such as > http://localhost/connexion.php?ID1=&ID2= > > When the variable ID2 is numeric, everything is OK and the query made by > PHP (su