medj Posted September 15, 2006 Share Posted September 15, 2006 by default, my script request MYSQL information from a database. The line I need help with is:LIKE '$c'I have a number of categories on my site that use the variable $cIn this mysql line, i dont want to grab info from the database with variable $c but with the variable $c + the word 'media' on the end of it.I've tried doing LIKE '$cmedia' doesnt work obviously since $cmedia is a whole new variable entirely.I've tried LIKE '$c+media' doesnt workPlease anyone? Link to comment https://forums.phpfreaks.com/topic/20813-question-about-mysqlphp/ Share on other sites More sharing options...
btherl Posted September 15, 2006 Share Posted September 15, 2006 Here are two options:[code]" LIKE '$c" . "media" . "'"" LIKE '{$c}media'"[/code]You can even do complex stuff like "{$arr['fortytwo'][5]}media'". Those {} symbols are very handy :) Link to comment https://forums.phpfreaks.com/topic/20813-question-about-mysqlphp/#findComment-92133 Share on other sites More sharing options...
medj Posted September 15, 2006 Author Share Posted September 15, 2006 Thanks so Much ;DYou just saved me tons of time. Maybe you can tell me what you think of my site:http://blankevolution.com Link to comment https://forums.phpfreaks.com/topic/20813-question-about-mysqlphp/#findComment-92136 Share on other sites More sharing options...
btherl Posted September 15, 2006 Share Posted September 15, 2006 Nice colours and layout.. I'm at work so I'm not going to look any closer :) Link to comment https://forums.phpfreaks.com/topic/20813-question-about-mysqlphp/#findComment-92143 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.